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

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

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

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 month's T-SQL Tuesday is the brainchild of Matt Velic and was inspired by a quote from Adam Machanic on the importance of understanding the APPLY operator. It's a good trick to have up your sleeve as it can do some nifty things and really save you some keystrokes when used properly. My first experience with APPLY …

Read More

T-SQL Tuesday this month is being hosted by the one and only Jes Borland (blog | twitter), and the topic of the month is aggregation. Powerful and fast aggregation tools are one of the biggest reasons to use a database. Without them, there would be a lot less awesomeness to look forward to – kind of like a meal without …

Read More

This Month's T-SQL Tuesday is being hosted by Pat Wright (blog | twitter) and Pat is asking about tips and tricks for making life easier through automation using either T-SQL or PowerShell. Recently I have been doing more and more work in PowerShell in order to get familiar with it. So far I've been quite happy. Batch …

Read More

This month is the 14th T-SQL Tuesday (my how time flies!) and it's graciously being hosted by MidnightDBA and newly-minted MVP Jen McCown (blog | twitter). Jen is asking what our techie resolutions are for 2011 – what we hope to accomplish and why. I think this is a great topic, and I'm so glad I hadn't already done a …

Read More