This month's T-SQL Tuesday is hosted by…ME! I asked everyone to share stories of how they came to love presenting, and I have not one but two tales of my own. They both took place at about the same time: my freshman year at the University of Illinois. I can't remember which one came first, so you get to read both! …

Read More

It's been almost two years since I last hosted T-SQL Tuesday, and I'm very happy to be doing so again! If you're not already familiar, T-SQL Tuesday was the brainchild of Adam Machanic (@AdamMachanic), who prophesized that we all could benefit from "a recurring, revolving blog party" with a new topic given …

Read More

It's once again the second Tuesday of the month, meaning it's T-SQL Tuesday! This month's topic comes to us from Jen McCown (blog | @JenniferMcCown). Jen is asking us to share our knowledge about filegroups, and it just so happens that I have a story about migrating to new storage that involved a large number of file …

Read More

This year, time seems to be flying by faster than ever. It's October already, and we're up to our 35th installment of T-SQL Tuesday. This time we're hosted by Nick Haslam (blog | @nhaslam). Nick's asking "what is your most horrifying discovery from your work with SQL Server?" The story that scares me the most …

Read More

July 2012 is the thirty-second installation of T-SQL Tuesday – wow that’s a lot! I can still remember reading posts that were part of the first one… This month’s topic comes from Erin Stellato (blog | @erinstellato), the newest employee of SQLskills (congrats Erin!!) She’s asking us to track what we do for a day and …

Read More

It’s been a while since I’ve written for T-SQL Tuesday, but I couldn’t resist this month’s topic. Aaron Nelson (blog | @SQLvariant) is asking about logging, and it needn’t to pertain to SQL Server. I love transaction logs a lot, but there’s plenty of other logs in my life, the vast majority of which actually involve …

Read More

This month's T-SQL Tuesday is brought to us by newly-minted MCM Argenis Fernandez (blog | @DBArgenis), who I had the pleasure of meeting in person for the first time a few weeks ago. Argenis is asking if we specialize or not, why we do (or don't) specialize, and why we feel that's a good thing. For a very long time …

Read More

Happy T-SQL Tuesday to all! (and happy Valentine's Day too!) This month's T-SQL Tuesday comes to us courtesy of Steve Jones (blog | @way0utwest). Steve is asking us to write about "big data" – specifically the problems we've solved or interesting ways we've found to work with it. In honor of the holiday, I'm …

Read More

This month's T-SQL Tuesday is hosted by Allen White (blog | @SQLRunr) and is an invitation to show off a nifty T-SQL trick you use to make your job easier. Here's one of my favorites as of late: Some of the source systems we copy from shard their data across multiple similar tables. For example, instead of having 1 …

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