In an effort to break the routine and be original, data visualization practitioners often attempt to create special graphs For example,...

Accessing Synapse serverless SQL pool external table with an SQL user

First, let's look at the Microsoft documentation: Hints are options or strategies specified for enforcement by the SQL Server query...

During my work, I see a lot of databases and TSQL coding. I see many coding mistakes, one of which is counting without actual necessity....

One of the biggest disadvantages of SQL Server has always been the lack of a monitoring system. A system that collects performance...

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...