A new DAX function to calculate workdays in a period of time

Today, I'm going to ask the question: When is SQL Injection dangerous, even if it's perfectly safe?

The steps needed to copy Azure data factory production environment to dev, ensuring sync between environments.

Author: Eric Rouach, Madeira Data Solutions Date: August 2022 If you are using SQL Server and need a lightweight encryption solution at...

Here is a script to create an event session that captures SQL errors with all the information you need...

The SplitQuery feature in EF is a terrible feature in most cases. Developers should avoid using it.

Sometimes you need to delete data from multiple tables with foreign keys. Here is a useful script that can save you a lot of time...

Let’s say you have a very large table on SQL Server 2012 Standard Edition. Most of the time you get poor performance. What can you do?

I'm excited about delivering a pre-con session in Data Platform Virtual Summit 2022 - The Performance Tuning Magic Show

One of the cool features introduced in SQL Server 2017 is the option to pause and resume an online index rebuild operation...