SQL Tact

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


SQL Server Admin Best Practices with DMV's at SQLSaturday Pensacola 2016

Great attendance and awesome questions from my 1130AM session on "SQL Server Admin Best Practices with DMV's". As promised, all the script files, including the demos we skipped for sake of time, and the entire info-packed slidedeck are available for download here on the official SQLSaturday Pensacola 2016 website.

If you have any questions or would like to get in touch, please let me know, contact info inside. Happy to meet, and thanks again for participating in the session and asking so many great questions. Thanks also to the brave contingent of developers from Alabama who survived the experience with a room full of anti-GUID DBA's. :)

It was an awesome event and I have very thankful to Karla Landrum for resurrecting the event,  the first SQLSaturday in Pensacola since 2012. Back home in Baton Rouge now I had a great weekend and was very glad that the wife and I were both able to be a part of a tremendous speaker lineup.

Thanks also to photographer/SQL extraordinaire Jamey Johnston for taking photos at the event and also for agreeing to photograph SQLSaturday Baton Rouge in August!


SQLSaturday Pensacola Up Next For Me, Baton Rouge on the Horizon

Looking forward to the triumphant return of SQLSaturday Pensacola on June 4, thrilled that this start-of-summer tradition is back! This has been in the past a pilgrimage that the wife and I enjoyed in early June, and we'll both be there again now that the event is returned for the first time since 2012.

I'm speaking at 11:30AM on SQL Admin Best Practices with DMV's in room 1776.

But my end-of-summer SQLSat has been, since 2009, my own hometown SQLSaturday Baton Rouge at LSU. Please help us spread the word about SQLSaturday Baton Rouge, to be held on August 6 at LSU!

Register now for SQLSaturday Baton Rouge, and check the Volunteer box to help us out!

Key dates for SQLSaturday Baton Rouge: 

Call for Speakers is OPEN, closes June 1Call for Speakers
Call for Sponsors is OPEN, closes July 25Sponsor Plan

All Sponsor bag materials must be received by July 30 

Baton Rouge User Groups Networking Night: July 13 at the La. Tech Park.
Call for Speakers for Networking Night 10-minute talks is OPEN: Networking Night Call for Speakers


Hello SQLSaturday Houston!

I've been looking forward to speaking at SQLSaturday Houston again all year!

Big thanks to the organizing crew behind this great event, poised to be Houston's biggest ever.

I'll be giving a presentation on SQL Server Permissions and Security Principals at 8:30am in room 148.

Also don't miss my colleague Robert Bishop's presentation on "Hostile Takeover", about inheriting legacy SQL Server systems, at 9:45am in room 117.

The slides and sample scripts for my presentation are available for download here or here.

UPDATE: The video from this session is available via UserGroup.TV here: http://usergroup.tv/videos/sql-server-permissions-and-security-principals