Last week, one of my coworkers had a nice case. From a dataset, he needed the third row based on an indicator and a timestamp. That sounded a bit vague so I started out with creating a table that contained some records with the columns he'd have to filter on. CREATE TABLE dbo.demo ( id … Continue reading Fun ROWNUM() case, get n’th row from dataset.
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
A short blog on how to get Always Encrypted to work in your app and in the ODBC connection.
Testing out if you can use preceding and following in the same windowing function @Microsoft @SQLServer #zekerweten
My short thoughts on migrating/upgrading SQL Server for #tsql2sday #tsql2sday147
Splittings string with @SQLServer. #Microsoft #sqlserver #tsql #zekerweten
One way that might speed up you inserts and deletes on Clustered Columnstores. @Microsoft @SQLServer @AzureSQL.
Reitse's blog 