TSQL Tuesday Archive

BCP for Flat File ETL

Brent Ozar is hosting today’s #TSQL2sday about the most recent issue you closed. Working with a consulting firm for a variety of clients, I tend to come across all sorts of issues. The most common one is

Automating File Processing with Python and SQL Server

Garry Bargsley ( b | t ) asks us this month what does “Automate all the things” mean to you. After all, if we have to do something over and over, it only makes sense to automate

TSQL Tuesday: “Disabling” Triggers Without ALTERs

I’ve worked with my share of Triggers over the years. Most of the time, they were relatively simple affairs – do a simple update to a date if a row changed or track some basic audits somewhere.

TSQL Tuesday #102: Giving Back

This TSQL Tuesday comes to us from Riley Major (b | t), He asks us in what ways we can give back to the SQL Community. He suggests blogging, speaking, answering questions, mentoring, or if we have

T-SQL Tuesday #99 : Singing and Music

This month’s T-SQL Tuesday is hosted by Aaron Bertrand (b/t), and he offers as a topic what he calls Dealer’s Choice. We can either share something about which we’re passionate outside of the world of SQL Server

T-SQL Tuesday #97 – Learning Goals for 2018

This month’s T-SQL Tuesday is brought to us by Mala Mahadevan.  Mala has challenged us to set some goals for our own learning in 2018. This could be learning to improve our social skills, technical skills, or

TSQL Tuesday #96: Folks Who Have Made a Difference

This month’s T-SQL Tuesday, hosted by ewald, touches on the people who have made a positive difference in our journeys in the SQL Server world. Please pardon if you’re reading this and feel left out – that’s