Well, we're back at the top of the month again, and this time around for Meme Monday we're to talk about what we'd love to see under the tree from Microsoft. This got my creative juices flowing, and I came up three wishes: First and foremost, if I had one wish that I could wish this holiday season, it would be that all …

Read More

This month brings us the 24th edition of T-SQL Tuesday (24 already? wow….). This time around our topic comes from Brad Schulz (blog) and has to do with stored procedures and functions. Brad's asking us to write whatever we'd like about either of them. While from the bird's-eye view both functions (the table-valued …

Read More

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

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