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)
http://sqlsat173performanceprecon.eventbrite.com
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.


Accommodations:
** 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
Reservations1-800-321-2211

Register

*We do ask that you consider to OPT-IN for the Sponsors of this event. Without their assistance, we cannot bring this FREE event to you. You can always opt-out if and when they contact! Thank you for your consideration.

Click here to view/download event summary in XML format.

Join us on Twitter!

Event News

Oct 9,2012
 ** 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 BI track due to the large number of submissions in that category.
We would really like to keep our Professional Development track as well, but are currently light on presentations int hat category, so if you have anything along those lines you'd like to submit, please do so!
We are very excited and know we are going to have a very difficult time narrowing down the schedule!


Aug 20,2012
We have a NEW Twitter account!
Follow @SQLSATDC and the #SQLSAT173 hashtag on Twitter for updates!

Event Sponsors

  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
SQLSaturday Home
PASS