SQLSaturday 173

Washington DC, United States

PASS SQLSaturday is a free training event for professionals who use the Microsoft data platform. These community events offer content across data management, cloud and hybrid architecture, analytics, business intelligence, AI, and more. This event will be held on Dec 08 2012 at The Microsoft Technology Center, 5404 Wisconsin Ave, Suite 700, Chevy Chase, Maryland, 20815, United States

Register Now

Welcome to SQLSaturday #173

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Dec 8 2012 at the Microsoft MTC , 5404 Wisconsin Ave Suite 700, Chevy Chase, MD 20815. Admittance to this event is free, but we do charge a lunch fee of 10.00 so that we can provide a lunch - not pizza! Please register soon as seating is limited, and let friends and colleagues know about the event.

Pre-cons registration extended to midnight 12/6/2012 only!

There is still a chance to join one of our pre-con sessions!
Not only are we adding an additional BI track to our existing 5 tracks (Now we have 2 DBA, 2 BI, 1 Dev & 1 Professional Dev tracks) and have some new & exciting things we are doing.
We are really excited that we are able to offer 2 pre-con sessions this year!
Unlike the regular SQL Saturday sessions, these pre-cons give you an entire day of small group training with some of the best in the industry!
We have listed each session below, as well as links to the registration site.
This is a great way to use up your end of year training budgets to advance your SQL knowledge even more!

The price of each session if just $125 and that includes the training and lunch!
They are scheduled to run from 9 – 5 on Friday 12/7/2012 at the same facility we are hosting SQL Saturday.
There are only 24 seats available in each session so don’t delay in getting your registration in!

SQL Saturday #173 pre-con Sessions offered:
            Automate and Manage SQL Server with PowerShell – Allen White (register here) http://sqlsat173powershellprecon.eventbrite.com
This soup-to-nuts all-day introduction to PowerShell for the SQL Server DBA will start with the basics of PowerShell and teach you the fundamental SMO object model, how to manipulate data with PowerShell, and how to use SMO to manage objects. We'll then move on to creating Policy-Based Management policies, working with the Central Management Server, managing your system inventory, and gathering performance data with PowerShell.

We'll wrap up with a look at the new PowerShell cmdlets introduced for SQL Server 2012 and how you can use PowerShell to manage SQL Server 2012 in server environments, including the new AlwaysOn technology and Windows Server Core. At the end of the day, you'll be ready to put PowerShell to work automating and managing SQL Server in your organization.
About the Instructor:
Allen White is a Practice Manager for UpSearch Technology Services in Northeast Ohio. He's spent over 35 years in IT and has been using SQL Server since 1992. He is a certified MCITP in SQL Server and an MCT and has been awarded Microsoft’s MVP Award for the past 5 years. Allen is President of the Ohio North SQL Server User's Group and answers questions about SMO and PowerShell in the MSDN Forums. You can read his blog at http://sqlblog.com/blogs/allen_white/default.aspx.
A Deep Dive into Waits-based Performance Tuning – Eddie Wuerch (register here)
Start with a simple proposition: a process is either working or waiting. You can tune the working part, but are you seeing the whole picture? There are many different resources on which your process could be waiting – a lock, memory, disk, CPU, and much more. When a process must wait, SQL Server will log it. There are hundreds of different wait types, and they are a gold mine of data for finding and solving performance problems – and proving the changes worked. Eddie Wuerch takes his extensive experience as a speaker, trainer, mentor, and DBA in one of the largest and busiest SQL Server environments in the world and distills it into a collection of performance tuning topics for DBAs and developers tuning databases of all sizes. After attending this seminar, you will be able to gather wait stats and use them to zero in on performance issues affecting your databases. Stop guessing, start knowing!
About the Instructor
Eddie Wuerch is a DBA, developer, trainer, and frequent conference speaker specializing in SQL Server for over ten of the twenty years he has spent in IT. Eddie is currently the tech lead of the DBA team at ExactTarget, a leading SaaS ESP located in Indianapolis. Eddie and his team design, manage, and tune the many multi-terabyte 24x7 SQL Server database clusters that form the foundation of the ExactTarget application. He holds MCITP certifications in SQL Server 2005 and 2008 development and administration, and is a Microsoft Certified Trainer.
Cancellation policy for all pre-con sessions:
Cancellations more than 1 month prior to the event will be refunded 100%, 2 weeks prior 50% and within the last 2 weeks prior no refund will be given. Please contact sqlsaturday173@sqlsaturday.com for refund processing.

*NEW* After Party location has been confirmed!

We will be meeting after our event for a social event at Clyde's, just 1 block up the street.

Starting at 7 we will have non-alcoholic drinks available as some appetizers brought out. Feel free to join us and help wind down a great day fo SQL learning!

A cash bar will also be available! See you there!

Event Parking:

The Mazza Gallerie parking facility seems to have the most flexibility. There are other parking garages close by, but Mazza opens early enough to accommodate even the earliest bird. A word of caution...this is an older garage and apparently has some tight turns. Those staying at the Courtyard Marriott may find the garage there to be more convenient. Parking at the Mazza Gallerie Parking Garage is around $17 for 8-12 hours.

** NOTE: This pricing offer block expires on 11/14/2012!!**

The hotel is 2 blocks from the Microsoft office and 2 blocks from the Friendship Heights Metro station on the Red Line. We have secured a block of rooms at $119 / night for both Friday and Saturday. Hotel guests can park at the hotel for $15.00 / day.

You can make your reservation online with our group rate at: Courtyard Marriot Reservations. If you call them, just let them know that you are attending the SQL Saturday event at Microsoft in December.

Courtyard by Marriott Chevy Chase
5520 Wisconsin Ave
Chevy Chase, MD 20815
Phone 1-301-656-1500

Event Location

Event news

 ** SPEAKERS TAKE NOTE **We will be closing the call for speakers on Sunday October 14th. If you have any sessions you would like to submit please be sure to do so by then.We are also adding another Read More

We have a NEW Twitter account!Follow @SQLSATDC and the #SQLSAT173 hashtag on Twitter for updates! Read More


Profile Image

Contact The Organizer

Send Message

XML Icon

XML Feed

Access event's XML feed

View Feed

Connect With Us

What is a PASS SQLSaturday?

PASS SQLSaturdays are local events organized by PASS community members around the world. PASS is a not-for-profit association for data professionals who leverage the Microsoft Data Platform, offering interactive learning built by community and guided by trusted data experts.

Back to Top cage-aids