Why am I attending Kevin Kline’s pre-con on “Troubleshooting & Performance Tuning Microsoft SQL Server 2008 R2” at SQL Saturday #89 in Atlanta on September 16th? For starters I am a production DBA. Sure I create SSRS reports and build ETL processes with SSIS and the like, but at the end of the day I […]
Month: July 2011
Listing Stored Procedures From Every Database
Recently I answered a question on AskSSC that I thought I would create a quick blog about. Someone had asked if there was an easy way to run SELECT * FROM SYS.PROCEDURES on every database. I immediately thought of the undocumented stored procedure sp_msforeachdb. I posted a response and gave a bit of advise to […]
Planning a SQL Saturday
On June 8th we announced SQL Saturday 89. The call for speakers went out to all those who had submitted sessions at a previous SQL Saturday, an alert went out to sponsors and the event was live. Immediately emails started coming in, people started registering and sessions were being submitted. The event really took on […]