A few months ago, one of my customers asked me to create a new DEV environment. The interesting part of the project was the request for...

Recently, one of my customers decided to downgrade the SQL Server edition. It was an Enterprise to Standard change, due to licensing...

Author: Eric Rouach, Madeira Data Solutions Date: October 2022 Pre-requisites: · Basic/Intermediate understanding of Microsoft...

This month's T-SQL Tuesday blog party is about Dynamic SQL. Lots of us have a story or a situation that worked out, and Steve Jones...

There is a lot of tooling around data enrichment and data orchestration in the Azure cloud and many services with similar features. Azure...

Detect and troubleshoot when the SQL Server query plan cache contains too many different plans for the same query hash.

Never use REAL or FLOAT, unless you really need them. In 99% of the cases, what you really need is DECIMAL.

Sometimes there are properties in the document with unstructured text, like newspaper articles, blog posts, or book abstracts. The...

Contained Availability Groups is a new feature in SQL 2022 to synchronize server-level objects between replicas. But... What does it not do?

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