Category: SQL

Which SSIS Package is DTEXEC running right now? Have you ever noticed a rogue DTEXEC process, but didn’t know which of many SSIS packages was actually running, or

Thank you to Nick Haslam ( blog | twitter ) for providing the topic for T-SQL Tuesday #35: What is your most horrifying discovery from your work with

I’m guessing that many developers, and novice to intermediate DBAs, are under the impression that they are golden if no error is returned when they press F5 (or

I was in need of a utility script to drop a handful of tables that started with the same prefix the other night, and had to quickly write

Duplicate data has a way of sneaking into database tables, so it’s nice to have a quick way to find and remove those duplicate rows. My favorite method

I’m excited to finally be making my first contribution to T-SQL Tuesday. Thank you to Aaron Nelson ( blog | twitter ) for providing this month’s topic. The Observer Effect