I’ve been meaning to join in on the T-SQL Tuesday event for the last couple months and let the time opportunity slip by. This month’s topic is reporting and its seems like a good time to get in on the event. The great thing about reporting is that for the past few months I’ve been … Continue reading TSQL Tuesday #005 – Wait Stat Report – #TSQL2sDay
Yesterday I mentioned the upcoming SQL Server 2008 R2 launch event, and today I’m going to bring up this months Minnesota SQL Server User Group (twitter) meeting. This month’s meeting will be sponsored by Fusion-IO. Besides the pizza and drinks, they’ll be discussing SSD and some of their products. If you want to get an … Continue reading Discover SSD… or PASSMN April Meeting (4/20/10)
It was bound to happen, a launch event for the upcoming release of SQL Server 2008 R2. This is a great thing because it means we’ll be able to play with the cool new toys in production soon and start getting our client’s upgraded. I do wonder though if there are talking dolphins in these … Continue reading Discover SQL Server 2008 R2
A couple days ago I was playing around with some Event Notifications and the Certificate that I’d created for them on my development machine. Low and behold I’d made a classic mistake and forgotten to write down the password for the certificate. Thus I was left without a critical component necessary for signing my procedures. … Continue reading Getting Rid of a Certificate
Part of being in the technology industry requires a constant dedication to learning. The world is a constantly changing place and the things you know today aren’t going to be cutting edge tomorrow. Those that stay in place and don’t change with the times can sometimes appear to be zombies. Just drooling along from one … Continue reading Free Brains… I Mean Beta Exams
Last week I presented at the March Minnesota SQL Server User Group (PASSMN) meeting on using CTEs in SQL Server. The session is meant as an overview and introduction to CTEs with some examples of their use and what some of the effects can be. Overall the session was well received and I got the … Continue reading ABCs of CTEs at PASSMN
Every now and then I work with people that just use the default trace templates available within SQL Server Profiler. Using the default traces and you end up being limited to just some performance stats on procedures and batches that have completed. There isn't exactly an issue with doing this, except that there is so … Continue reading There Is Much More to Profiler
The SSWUG Spring 2010 Virtual Conference is coming up. On April 7, 8, and 9, attend a conference from the comforts of your living room, office, or couch. And while you are at it you’ll get to sit on on some incredible presentations, interaction with speakers, chat with other attendees, make new contacts, lots of … Continue reading SSWUG Spring ’10 Ultimate Virtual Conference
After setting up backups on a client’s servers, I started to get the error message below each night at approximately the same time. Sometimes on the same database and other times on other database. The only constant appeared to be the time in which the error occurred. Processed 1 pages for database 'MyDatabase', file 'MyDatabase_log' … Continue reading Interesting Backup Failure
A while ago I had read about the hidden threat of forwarded records. These silent killers are like storm troopers in the bush waiting to get you when you least expect it. And then the other day I saw a T-SQL Tuesday post by Sankar Reddy on (blog – twitter) on determining if your SQL … Continue reading Find Tables with Forwarded Records
Strate SQL 