SQL Server Find Unused Data Files

You know that old SQL Server you’ve left running the last 5 years and had numerous databases dropped and restored...

4 SQL Injection Techniques For Stealing Data

Watch this week’s episode on YouTubeI’m not advocating that you start using SQL injection to start stealing other people’s data.

However,...

Advent of Code 2018 – Day 5 (Alchemical Reduction)

Advent of Code 2018 – Day 5
As I explained in a recent post, I’m participating in this year’s Advent of Code...

Advent of Code 2018 – Day 5 (Alchemical Reduction)

A T-SQL approach to solving the 2018 "Advent of Code" programming challenge. This solution includes a recursive case-sensitive string replacement.
The post Advent of Code 2018 – Day 5 (Alchemical...

Azure Data Factory v2 and its available components in Data Flows

Many of you (including me) wonder about it. Namely: Is it possible to move my ETL process from SSIS to...

Enabling Query Store

Performance tuning in SQL Server is one of the main jobs a DBA has.  Starting with SQL Sever 2016 a...

Flagrantly ignoring the 10% rule

My friend Michael J. Swart has a rule of thumb he calls Swart’s Ten Percent Rule. If you’re using over...

SQL Data Discovery and Classification in SSMS 17.5

Data exploration and documentation can be cumbersome, classifying data can be one of those tedious but necessary things. With the...

UDL files and connection strings

A co-worker showed me a really neat trick the other day. We deal with a lot of connection problems and...

Useful T-SQL queries and scripts to work in SQL Server

This post is about some queries and scripts that I use in my daily work on SQL Server. Some of them are self-explanatory, i.e. the name of the query/script...