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

So I quit my job last week. As is the practice at most companies, I had to complete an exit interview. Since my former employer was rather geographically distributed and there were no human resources staff in my office, my exit interview was on paper instead of face-to-face. I liked this much better because I had more …

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

Quick thought: I first posted to this blog a year ago today. Since then there have been 62 more posts, hundreds of comments and some readership numbers I'm proud of. My sincere thanks to all of you who have stopped by to read or have offered support here or on Twitter. I love the SQL Server community! This year I …

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