Or maybe I should say, with some complications. Or challenges. When I got the job to restore a bacpac file, I didn't think much of it. Because it's quite easy. Get the bacpac and restore it with Azure Data Studio or Sql Server Management Studio. Get coffee, done. Then I got these requirements: The bacpac … Continue reading Restoring a bacpac file, but differently.
Or, how SQL Server behaved differently than I expected but managed to process quite a lot of rows before giving up. Let's begin We have a customer that would like to see the actual value of their stock in a table. They buy their stock at different times and at different prices. Calculating the stock … Continue reading SQL Server Common Table Expressions, a tale.
It's the end of the year, a time to reflect, look back and, as Kay Sauter asked, thank people. As it's easy to forget in our hectic days, a topic like this one is great to take a step back and think about it. I also find it quite difficult (perfectionist) as I don't want … Continue reading T-SQL Tuesday 169 – Thank you
Welcome to my blog series on Azure SQL DB performance. In this blog I'll write about my findings with the Azure SQL DB General Purpose Compute Optimized tier. Quite a mouth full. Click here for information about the set-upClick here for the scripts I’ve used Intro In my previous blog, I wrote about the General … Continue reading Azure SQL Database Performance comparison part 6 of 9: General Purpose Compute Optimized
Welcome to my blog series on Azure SQL DB performance. In this blog I'll write about my findings with the Azure SQL DB Premium tier. Click here for information about the set-upClick here for the scripts I’ve used Intro In my previous blog I wrote about the standard tier, one that has 9 SKU’s and … Continue reading Azure SQL Database Performance comparison part 3 of 9: Premium
Welcome to my blog series on Azure SQL DB performance. In this blog I'll write about my findings with the Azure SQL DB Standard tier. Click here for information about the set-upClick here for the scripts I’ve used Intro This tier is more expensive than the basic, but starting at 12 euro’s per month up … Continue reading Azure SQL Database Performance comparison part 2 of 9: Standard
A short blog about my latest speaking experiences #dataweekender #sqlfriday #zekerweten
Splittings string with @SQLServer. #Microsoft #sqlserver #tsql #zekerweten
One way that might speed up you inserts and deletes on Clustered Columnstores. @Microsoft @SQLServer @AzureSQL.
If you've been working with Azure for more than a few months, you'll find that deploying resources with the portal is a tedious, time consuming and, at times, a frustrating excercise. It's the best starting point you can get, because the portal will show you a lot of options and offers a easy learning curve. … Continue reading Azure Infrastructure as Code
Reitse's blog 