Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May 14th I’ll be presenting the third part which is about columnstore indexes. You can watch...
2026-05-07
25 reads
I’m doing a small series on indexing basics for SQL Server, and on May 14th I’ll be presenting the third part which is about columnstore indexes. You can watch...
2026-05-07
25 reads
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB as the source) that I’ve managed to run into, twice. I’ve set up mirroring by...
2026-04-27 (first published: 2026-04-15)
223 reads
A while ago I blogged about a use case where a pipeline fails during debugging with a BadRequest error, even though it validates successfully. If you’re wondering, this is...
2026-03-23 (first published: 2026-03-06)
188 reads
I’m starting a webinar series about SQL Server indexing with the fine folks of MSSQLTips.com. Each “episode” will be about 30 minutes long and will feature a certain topic...
2026-03-18 (first published: 2026-03-17)
15 reads
Quite the title, so let me set the stage first. You have an Azure Data Factory instance (or Azure Synapse Pipelines) and you have a couple of linked services...
2026-03-11 (first published: 2026-03-03)
371 reads
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at dataMinds Saturday. It’s a topic close to my heart, and I’ve always wanted to present...
2026-02-20
22 reads
I’m not trying to start up a debate whether you should use tabs or spaces when indenting code. Personally, I prefer spaces because when I copy the code to...
2026-01-30 (first published: 2026-01-19)
675 reads
Yes, you’re reading that right, we’re going to download a report that cannot be downloaded. Well, it cannot be downloaded from the user interface, that is. Suppose you have...
2025-11-26 (first published: 2025-11-06)
387 reads
The Power BI Enhanced Report Format (PBIR) will soon become the default, and that’s a good thing because it significantly makes git integration easier. You can already enable it...
2025-11-20 (first published: 2025-11-18)
139 reads
Quite a long title for a short blog post ??While deploying a DACPAC (from a SQL Server Data Tools Database Project) through Azure Devops, I got the following error...
2025-11-16 (first published: 2025-11-14)
50 reads
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Comments posted to this topic are about the item Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers