pointers, solutions and scripts for the SQL DBA
not intended to replace msdn, common sense or oxford commas

Sunday, October 14, 2012

Database Design Contest at the 2012 AITP Region 3 Student Conference

Had a great Friday in Lafayette, LA on the campus of the University of Louisiana-Lafayette.  31 different teams submitted database designs on my problem statement that required an ERD and sample data set.  The database design contest was sponsored by the Baton Rouge SQL Server User Group, a chapter of PASS.

When judging, I didn't see any identifying info besides a randomly-assigned number. I was happy to announce that the winner of the contest got a perfect grade on a 14-factor grading system, and that the top six places all got more than a 90% grade.  A big thanks to my Baton Rouge colleague Kristen Reeves, a former speaker at the BRSSUG, for helping me grade the entries.

Congratulations to all the contestants at the 2012 AITP Region 3 Student Conference Database Design contest!

Thursday, October 11, 2012

Performance Tuning Presentation from October 2012 BRSSUG Meeting

Thanks to the 15+ folks who attended the Baton Rouge SQL Server User Group meeting last night!  I hope everyone enjoyed "everyone gets a book" night!

I presented on SQL Server Performance tuning, which began with Michelle Ufford's article from GoDaddy on how she saw massive performance gains just by correcting columns to more appropriate data types.  Here's a link to that article: https://web.archive.org/web/20130629210916/http://inside.godaddy.com/scaling-database-data-types/

Then we went through database compression, indexing and execution plans, index INCLUDE structure, the missing indexes feature, how foreign keys can affect performance, isolation modes and MAXDOP.

I've uploaded all my sample scripts in a .zip file to the brssug.org website here for you to download.

Thanks for attending, see you November 14!

UPDATE 20141104: Link to a cached copy of Ufford's article.