pointers, solutions and scripts for the SQL DBA
not intended to replace common sense

7/31/2011

SQLSaturday Baton Rouge #64


Free SQL Server and .Net training!  Chance to win great prizes!  What more could a SQL Server Professional ask for? If this sounds good to you then don’t miss your opportunity to attend SQL Saturday! #64, the largest FREE training event dedicated exclusively to SQL Server, .Net, Development and Business Intelligence in Louisiana.
SQL Saturday! #64? What is it? When is it? Where is it? How do I get involved? Let me fill you in.
What:
An all day FREE training event with SQL Server and .Net sessions spread out over six tracks of Business Intelligence, Database Administration, SQL Development, and .Net.
When:
Saturday, August 6, 2011. Online registration is now open, but it is filling up fast so reserve your spot now. Attendee check-in will begin at 7:00am until 8:45am with opening comments from 8:30am to 9:00am and the first sessions beginning at 9:15am. A full list of session tracks and schedule is available.
Where:
Louisiana State University, College of Business
1109 Patrick F. Taylor Hall
We’ve posted a Google map on the Location page, but just in case here is the location and text directions!
Link to directions: http://www.eng.lsu.edu/misc/directions.html
Lodging:
The Cook Hotel
3848 West Lakeshore Drive
Baton Rouge, LA  70808
Call:  (225) 383 2665
Note:  Mention SQL Saturday when making reservations for event rates.  All reservations must be received before 7/13/2011.
www.thecookhotel.com
Hotel Map: link
How: All you have to do to get involved is register online to reserve your spot. Show up and attend the sessions that you like.
So what are you waiting for? Register today to be a part of SQL Saturday! #64!
SQL Saturday! #64 is presented by the Baton Rouge Chapter of the Professional Association for SQL Server (PASS) and brought to you by these sponsors.
Twitter info:
The event hash tag is #sqlsat64.  Follow the official SQL Saturday Baton Rouge twitter account at @SQLSatBR!  The Baton Rouge chapter of PASS tweets at @BRSSUG.

7/14/2011

Finding Missing Indexes in Your Ill-Begotten Databases

Last night I presented at (and won!) the Baton Rouge SQL Server and .net User Groups Speaker Idol Competition Summer 2011.  My topic was a humor-ridden presentation of nonclustered indexing strategies for SQL Server and how indexes impact application performance, geared towards a majority-developer audience.

Thanks to all who attended and voted, and a big congrats on a job well done to the other contenders!

Click here to download the slidedeck and sample scripts, in a zip file.