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:
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.
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