Posted in Scripting SQL Server Tools TSQL TSQL Tuesday

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…

Continue Reading... BCP for Flat File ETL
Posted in Scripting TSQL Tuesday

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…

Continue Reading... Automating File Processing with Python and SQL Server
Posted in Programming SQL Server TSQL TSQL Tuesday

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…

Continue Reading... TSQL Tuesday: “Disabling” Triggers Without ALTERs
Posted in TSQL Tuesday

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…

Continue Reading... TSQL Tuesday #102: Giving Back
Posted in TSQL Tuesday

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…

Continue Reading... T-SQL Tuesday #99 : Singing and Music
Posted in TSQL Tuesday

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….

Continue Reading... T-SQL Tuesday #97 – Learning Goals for 2018
Posted in TSQL Tuesday

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….

Continue Reading... TSQL Tuesday #96: Folks Who Have Made a Difference