A while back I decided I need to get down to brass tacks and figure out SQL Server CLR. I'd looked at examples and seen some pretty cool stuff being done with it. Unfortuantely, I hadn't taken the time to become acquianted enough to know enough about the unknown. This limited my ability to be able … Continue reading FileSystemHelper SQL Server CLR – Codeplex
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)
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
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
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
Ever need to group dates and round them to intervals? I had this exact need for a report on wait stats I was working on for an upcoming post. I wanted the flexibility to be able to group a list of dates by either minute, hour, date, etc. And then also round those dates within … Continue reading Grouping and Rounding Dates
A couple weeks back I was asked “How come Microsoft has yet to put TRIM() in SQL?” I don’t really know why there isn’t a TRIM() function in SQL Server. There is an LTRIM for function removing leading spaces. And an RTRIM function for removing trailing spaces. But there isn’t a TRIM function. Let’s be … Continue reading Please, no TRIM()?
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
Strate SQL 