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.

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.