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

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.