I was writing some dynamic SQL that generates some SQL statements to load my facts and dimensions into a data warehouse. Some of those SQL statements can become very...
2023-02-17 (first published: 2023-01-31)
633 reads
For the first workdays of this new year, I had the pleasurable task of resetting a bunch of passwords. The passwords belong to Azure AD users, service principals, SQL...
2023-02-15 (first published: 2023-02-01)
520 reads
When working in business intelligence, data engineering or data in general, there are some “mantras” that are being adopted by the larger community as “best practices”. For example, I...
2023-02-14 (first published: 2023-02-13)
45 reads
I’m excited to announce I’ve been selected again as a speaker for Techorama 2023. Techorama is one of the biggest Microsoft-focused events in the European mainland, and it’s always...
2023-02-14
24 reads
Typically you have a bunch of pipelines that are started by one or more triggers. Sometimes, a pipeline needs to be manually triggered. For example, when the finance department...
2023-02-08 (first published: 2023-01-25)
220 reads
I have a Logic App that reads out a SharePoint library and stores all the documents found into Azure Blob Storage (ADF only supports Lists). I was trying to...
2023-01-30 (first published: 2023-01-18)
79 reads
The book Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems by Martin Kleppmann was recommended to me by a colleague. The author has worked at companies...
2023-01-09 (first published: 2022-12-29)
216 reads
Let me start by wishing everyone the best for the year 2023! We’re going to kick off the new year with a virtual conference: the Data Community Austria Day...
2023-01-09
32 reads
This is a bit of a niche blog post, because you don’t actually need this to make your Azure Function work :). When you create a new HTTP-triggered Azure...
2023-01-02 (first published: 2022-12-16)
200 reads
The nice people from Packt Publishing sent me a digital copy of Benjamin Nevarez new book to review: SQL Server Query Tuning and Optimization – Optimize Microsoft SQL Server...
2022-12-26 (first published: 2022-12-02)
335 reads
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Please I am hoping for some feedback Specifications: Windows Server 2022 SQL Server 2022...
Comments posted to this topic are about the item How Do the Experts Become...
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers