Data Orchestration, Ingestion, and Data preparation in Azure cloud – which tool should you choose?
There is a lot of tooling around data enrichment and data orchestration in the Azure cloud and many services with similar features. Azure...
Search
Eitan Blumin
- Sep 16
- 1 min
Too Many Plans for the Same Query Hash
Detect and troubleshoot when the SQL Server query plan cache contains too many different plans for the same query hash.
Guy Glantser
- Sep 9
- 6 min
Is it REAL?
Never use REAL or FLOAT, unless you really need them. In 99% of the cases, what you really need is DECIMAL.
Maria Zakourdaev
- Sep 8
- 1 min
Inverted Index for full-text searches or common words detection
Sometimes there are properties in the document with unstructured text, like newspaper articles, blog posts, or book abstracts. The...
Eitan Blumin
- Aug 30
- 3 min
What is not contained in contained Availability Groups
Contained Availability Groups is a new feature in SQL 2022 to synchronize server-level objects between replicas. But... What does it not do?
Chen Hirsh
- Aug 9
- 1 min
Calculate working days in DAX
A new DAX function to calculate workdays in a period of time
Eitan Blumin
- Aug 9
- 4 min
Could SQL Injection be dangerous even when perfectly safe?
Today, I'm going to ask the question: When is SQL Injection dangerous, even if it's perfectly safe?
Chen Hirsh
- Aug 8
- 2 min
Resetting your data factory dev environment from production
The steps needed to copy Azure data factory production environment to dev, ensuring sync between environments.
Eric Rouach
- Aug 3
- 2 min
Did you say Data Masking?
Author: Eric Rouach, Madeira Data Solutions Date: August 2022 If you are using SQL Server and need a lightweight encryption solution at...
Guy Glantser
- Aug 1
- 2 min
Track SQL Errors
Here is a script to create an event session that captures SQL errors with all the information you need...