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

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 other …

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 rather …

Read More

Two weeks ago I had the pleasure of attending the SQLskills Immersion Event on Internals and Performance taught by Paul Randal (blog | @PaulRandal) and Kimberly L. Tripp (blog | @KimberlyLTripp). I had been wanting to attend one of these for quite some time, and when it was announced they would be coming to the Chicago …

Read More

A great big thanks to all who contributed posts to T-SQL Tuesday #18! There were 23 posts in all and they covered a wide variety of tips and tricks that can be done with CTEs! If you're looking to learn a ton, read through all the awesome content below! Without any further ado, here's a quick look at what everyone …

Read More

This month marks the 18th installment of T-SQL Tuesday. T-SQL Tuesday was started in December 2009 by Adam Machanic (blog | @AdamMachanic) and is defined as "a recurring, revolving blog party". Any blogger wishing to participate is invited to write about the given topic, chosen by whoever is hosting that particular …

Read More

This weekend I took and passed Microsoft Exam 70-451 (MCITP: Database Developer 2008). I'm pleased to say my score on this exam was much higher than its prerequisite, 70-433, which I wrote about a few months ago. Much like last time, I am happy to offer my thoughts for those who might be taking this test in the future. …

Read More