Presentations Materials From Last Week

Last week I spoke at the PASSMN meeting here in Minnesota and then via a webcast to the Edmonton PASS chapter.  For both nights the presentations seemed to go fairly well – especially given the e-mail requests for the presentation materials after the events. PASSMN Meeting Session: Error Logs and Deadlocks, Oh My Tired of … Continue reading Presentations Materials From Last Week

Speaking at Tampa SQL Saturday

I've been selected to speak at the Tampa SQL Saturday coming up at the end of January. I'm a bit pumped to be going down there since I woke up this morning to below zero weather for yet another day. Not that I'm complaining, but my feet could definitely use a little bit of heat. … Continue reading Speaking at Tampa SQL Saturday

Wait Stat Categories

A few weeks ago I posted a job that I use to track wait stats in the DBA database that I bring to a number of clients.  I had promised to follow-up with a couple or three reports that could be used to monitor the values that were being aggregated in those tables. Before getting … Continue reading Wait Stat Categories

Pushing Excel Through A Wormhole

With the next release of SQL Server, data analysis is going to go through a major change with the PowerPivot add-in for Excel and SharePoint.  If you haven’t been keeping up with these changes to Business Intelligence, has an opportunity for you to get up to speed.  On January 22, 2010 there will be … Continue reading Pushing Excel Through A Wormhole

Does Your Stored Procedure Grant Itself Permissions?

It’s a very good question. One that might not seem to insidious. Nothing that should be able to bring down the system and cause failures. Or will it? I’ve been to a number of clients and done it myself before where I start to check out a stored procedure with some performance issues and sitting … Continue reading Does Your Stored Procedure Grant Itself Permissions?