Link Power BI to Azure Synapse Analytics
Author: Eric Rouach, Madeira Data Solutions Date: October 2022 Pre-requisites: · Basic/Intermediate understanding of Microsoft...
Search
Vitaly Bruk
- Oct 11
- 3 min
T-SQL Tuesday #155 – Too many single-use plans issue
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...
Maria Zakourdaev
- Sep 16
- 1 min
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...
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.