After my trek to Iowa City last year for SQL Saturday #50, I knew I'd have to travel to more out-of-town SQL Saturdays in the future. Unfortunately I couldn't make it back to Iowa City this year, but I was very happy when I found I would be able to travel to Kansas City this time around for SQL Saturday #101. This is …
Read More

Have you ever had one of those times where you spent hours trying different ways to make something work the way you envisioned, only to find that the solution was staring you in the face all along? I have those more often than I'd like to admit – and while the title of this post seems like a DBA 101 topic, the answer …
Read More

I'm very happy to have been chosen to speak at SQL Saturday #101 in Kansas City on October 29th. Those responsible for planning have put together an excellent schedule with a great group of speakers that I'm proud to be among!

I'll be presenting 2 sessions that day:

Backups and Recovery In Depth takes a good look at …

Read More

This month's T-SQL Tuesday topic comes to us courtesy of Stuart Ainsworth (blog | @codegumbo), and is early due to the PASS Summit being next week. Perhaps those planning next year's summit will do a better job to make sure they don't interfere with any blogging parties :)

Stuart's topic for the month is joins, and …

Read More

This month the 22nd T-SQL Tuesday comes to us courtesy of Robert Pearl (blog | @PearlKnows), and he's asking us to write about formatting data for presentation to end users. He describes end-users as "boss, supervisor, department head, the analyst, employees, or customers". I'm going to take the liberty of extending …

Read More

Everything is good in moderation, and when it comes to having multiple filegroups in your database, I believe this to be true there as well. Having multiple filegroups allows you to spread your data across multiple disks, and can also come in handy for features like partitioning. When applied properly and reasonably, …
Read More

I'm back! I really never left, but due to the time spent putting the final pieces together for my wedding things got a bit stale here. I can't really say I'm sorry though, as the whole experience created some great blog topics! As you now know if you didn't already, I got married recently. My fianceé wife and I had a …
Read More

Howdy folks and Happy T-SQL Tuesday Wednesday! Contrary to popular belief, both myself and my blog are not dead, it's just that preparations for my upcoming wedding have taken up nearly all of my spare time. Once I return from my honeymoon I hope to be back to blogging as usual!

This month's topic comes from none …

Read More

Back in January, the T-SQL Tuesday topic was about our "techie resolutions", and I was happy to contribute my list. As of today, 2011 is half over (already?!?) so it's time to check on my progress.

Speak More – So far this year the only SQL Saturday I've made it to was #67 in Chicago, which I helped to plan. …

Read More

This month's T-SQL Tuesday comes to us courtesy of Allen Kinsel and the topic is disasters. In the spirit of the beginning of hurricane season, Allen's asking for stories related to disasters, either preparing for them or recovering from them. A recent tale I have is not quite about preparing for a disaster, but …

Read More