April 12th marked the first edition of Seaql Saturday in the Netherlands, the inaugural event situated in the southern part of the country. The event focused on SQL Server only; as advertised, it was a Fabric-free event. This blog post will discuss my experiences and why you should attend the next edition. Before the event … Continue reading Speaking experiences at Seaql Saturday
Some time ago, I wrote a number of blogposts comparing the different Azure SQL options to give you some idea about performance, differences between tiers and differences between the Stock Keeping Units (SKU's). This was done by creating data in the database itself and review the metrics. This works fine and gave a good overview … Continue reading Loadtesting SQL, the sequel
The best place to store your data is in a SQL Server database that no living being can ever access. The end. No, I'm kidding, of course. But there's an atom of truth in this joke. Because for years we, in the structured data industry, have always been convinced that a database is the best … Continue reading DP-700 Training: Choose an appropriate data store
Welcome to my Ted Talk, data transformation is done in T-SQL. Thank you. Well, yes once upon a time, maybe. Nowadays there are many more ways that lead to the dark side (also known as data vault) and the happy side (also known as the star schema or dimensional model). Did I lose you yet? … Continue reading DP-700 Training: Data transformation options
This post can come as a shock if you're used to writing T-SQL. Because not only is there more than one useful language to process data, realtime data in this case, but it also has enough similarities to SQL to look familiar and is different enough to leave you flustered. Now, to get a complete … Continue reading DP-700 Training: Process data using KQL
By the time you read this, I'm guessing the big #MSIgnite announcements were yesterday. You can use that hashtag to find most of the posts on social media. And there were many, very cool, announcements! Let me quickly take you through my favourites. Databases! As I still love the DBA work, announcing SQL Server 2025 … Continue reading Top Highlights from #MSIgnite 2024
It's been a long time coming, but all of a sudden there were a number of posts from Microsoft announcing the first preview of SQL Server Management Studio 21. This is big as it's quite the overhaul from the SQL Server Management Studio we're used to. To give you some idea, here are my first … Continue reading SQL Server Management Studio 21: First Impressions & Features
This blog won't be very long and will describe a connection issue I experienced with a customer including the solution and some context why this solution worked. I hope this saves you time when dealing with the same error. Issue The customer can connect to the Azure Sql database with Sql Server Management Studio (SSMS) … Continue reading Fixing Azure SQL Client Connection Timeouts
Very recently, Microsoft announced the public preview of the Microsoft Fabric Copy Job. This blog will give an explanation of what a Copy Job is, how to create one and why it can be an enormous help in speeding up your data ingestion. What it is The copy job is essentially an abstraction of a … Continue reading Microsoft Fabric Copy Job: Simplifying Data Ingestion
Welcome back to this mini series on Azure Sql Server with Copilot. In the previous posts I wrote about a general introduction of this toolset (click here for more) and had some fun in the Azure Portal getting stuff done (click here for more). In this third part, I'm going in for the data and … Continue reading Sql Server and Copilot. What the query it this? Part 3, query editor
Reitse's blog 