Tuesday, June 12, 2012

SQL Saturday Pensacola presentation file downloads

I had a great weekend at my fourth annual visit to Pensacola for SQL Saturday, which had many great sponsors, the biggest of which was water.

I presented in the lunch-hour Lightning Talk competition and won Best Content with my five minute presentation, "Finding Missing Indexes In Your Ill-Begotten Databases", a title that the presentation picked up when I was presenting mainly to Developers at the Baton Rouge .net User Group.  You can download the presentation slidedeck and sample files here.

At 3:15pm I presented to a full room on SQL Server Permissions and Security Principals.  I was happy with the positive feedback I received, as this was the first time I'd presented this topic at a SQL Saturday.  You can download my slidedeck and samples files here, including the two-part demo demonstrating how stored procedures and views allow you to minimally-provision users with direct table permissions.