Articles tagged SQL Server

01 March 2024
01 March 2024

Friendly Deletes in SQL Server

One of the first things you learn when working with SQL Server, and other transactional based SQL systems, is that set based operations perform best. If you are querying data, a cursor pulling individual rows doesn’t perform as well as a single query. It doesn’t matter if that cursor is on the client side or … Read more
29 February 2024
29 February 2024

Find and Replace Text in Strings in T-SQL

String manipulation is an inevitable task for developers and data professionals alike. Despite all the best efforts to normalize databases, eventually we are faced with some sort of text-based data stored within a relational database and need to extract detailed information from it. Those of us who have tackled these challenges fully understand how code … Read more
09 February 2024
09 February 2024

Automating BCP with PowerShell

I was talking with a good friend that has an environment with terabytes of information and to create a homolog or dev environment to him is a pain. He comes to me with a solution : A PowerShell script that gets only the first 1000 lines of each table, creates the inserts and schema files … Read more
30 August 2021
30 August 2021

5 SSIS tricks you would like to know

How to make conditional decisions in a package It may seems strange the lack of a decision task for the control flow. However, there is a work around to allow us achieve the same effect we would have with a “decision task”. The precedence control between tasks can be based on an expression. Building the … Read more