Category Archives: Uncategorized

T-SQL Tuesday #026 – The Wrap Up

Thank you everyone who participated in T-SQL Tuesday #026! I really enjoyed hosting and reading all of the contributions. Thanks also to Adam Machanic (blog | @AdamMachanic) for starting this monthly event and for allowing me to run this show … Continue reading

Posted in Uncategorized | 6 Comments

T-SQL Tuesday #26 – DBA Skillz

Since I’m hosting T-SQL Tuesday this month, I really wanted to participate as well. I chose the topic I missed called Why are DBA Skills Necessary? This topic was originally hosted by Paul Randal (blog|@PaulRandal) back in November of 2010. … Continue reading

Posted in Uncategorized | 1 Comment

T-SQL Tuesday in Local Time

The January edition of T-SQL Tuesday is next week! If you knew that, then you probably already know that the start and end times for T-SQL Tuesday are always at midnight UTC time, and that finding the current UTC date … Continue reading

Posted in Uncategorized | 1 Comment

TSQL Tuesday #026 – Second Chances

UPDATE: The Wrap-Up is here. Happy New Year everyone! Welcome to 2012. Every new year brings with it a fresh start, a second chance to do things differently.  In the spirit of second chances, for this month’s T-SQL Tuesday, please … Continue reading

Posted in Uncategorized | 27 Comments

TOP Tricks (T-SQL Tuesday #25)

T-SQL Tuesday is here again, brought to us this month by Allen White (blog|@SQLRunr). I’ve read Allen’s blog many times for PowerShell advice, but today he’s asking for your favorite T-SQL tricks. I’m not sure if this qualifies as a … Continue reading

Posted in Uncategorized | 2 Comments

Fixing the Query Plan for a Stored Procedure (T-SQL Tuesday #24)

It looks like T-SQL Tuesday is here again, brought to us this time by Brad Schultz (blog) on the topic of stored procedures and functions.  It’s been a while since I joined this blog party (or blogged at all for … Continue reading

Posted in Uncategorized | 1 Comment

More Recursion–Removing Multiple Spaces

My last post about recursive CTEs reminded me of a recursive SQL Server function I wrote a while back for removing multiple spaces from strings.  By removing multiple spaces, I mean replacing all consecutive repeating spaces with a single space. … Continue reading

Posted in Uncategorized | Leave a comment

The Missing UNGROUP BY Clause (T-SQL Tuesday #18)

For May 2011, T-SQL Tuesday is brought to us by Chicago’s own Bob Pusateri  (blog | @SQLBob). Bob chose common table expressions, otherwise know as CTEs as the topic of the month.  Thanks for hosting Bob, and for the great … Continue reading

Posted in Uncategorized | 6 Comments

Meme Monday–Running with SQL

My Meme Monday 11 word blog post: “Running fast, heart racing, working through SQL problems in my mind.” I was on vacation last week in Arizona. We were in Phoenix a lot, but also spent time in Sedona and visited … Continue reading

Posted in Uncategorized | 3 Comments

Disable all SQL Agent Jobs

Recently, I was looking for an easy way to disable all of the SQL Server Agent jobs as part of a migration to a new environment. My first thought was to just stop the SQL Agent service, but there were … Continue reading

Posted in Uncategorized | 5 Comments