Your Modernization Journey starts now

Journey

Recently Microsoft introduced SQL server 2022. We wrote this post to make sure you won’t be missing out on all the fun and exciting new changes. Are you as thrilled as we are? Start your modernization journey now!   Modern Times SQL Server 2022 Recently Microsoft introduced SQL server 2022, the most hybrid SQL server […]

Parameter sniffing solved with new Parameter Sensitive Plan Optimization feature

If you’re someone that works a lot with Microsoft SQL Server, there’s no doubt that you’ve had issues with an issue called “Parameter sniffing” before. Up until now, you had to figure out a way around it. SQL Server 2022 solves this issue – almost completely – through a new feature called Parameter Sensitive Plan […]

SQL Server Reporting Services 2019: what has changed compared to earlier versions?

When trying to do a standard install of SQL Server, you may have noticed that the 2017 or newer versions of SQL Server Reporting Services (SSRS) aren’t installed as well. That’s because SSRS now has its own separate installer. In this blog, we’ll show some of the changes compared to older versions of the software […]

The magic of Scalar-valued function inlining in SQL 2019

When one of my clients asked me for a reason to upgrade to SQL 2019, the first thing that came to mind is Scalar-valued function inlining. Reason? Well, for some reason developers like stuffing their SQL with SVFs, and that… makes… it… so… slow. Are SVFs really that bad? And is scalar-valued function inlining useful […]

XML fun on Azure SQL

For a client project I was recently asked how to efficiently handle translations in SQL Server. As, in this particular case, the client application was very proficient in processing XML data I chose in cooperation with the development team to use XML as the datatype to handle this specific case. While XML has been suitable […]

When tempdb becomes permanentdb

What can go wrong when you combine memory-optimized tempdb with the resource governor? In-memory tempdb metadata If you are using SQL Server 2019 you’ll see that one of the new features allows you to convert some tempdb system tables in in-memory OLTP. If your system is overloaded with a busy tempdb, you can reduce contention […]

Een inleiding tot Partitioning, deel 1

Naar aanleiding van een migratieproject bij een van onze klanten, kreeg ik inspiratie om enkele zaken rond Partitioning uit te klaren. Partitioning is geen performance feature, maar is voornamelijk een methode om het management van grote tabellen te vergemakkelijken. Dat betekent dat het geen invloed kan hebben op de performance. Wel integendeel, het kan zowel […]

Should I use serverless for all my Azure SQL Databases?

When I first heard about the new serverless compute tier, I wondered if I could use it for all my Azure SQL databases to save my clients some money. (Spoiler alert, you can’t 🙂 ) But first things first, what the heck is serverless? Azure SQL Database serverless is a new compute tier made for […]

Prevent lock escalation on indexed views

Recently I was at a customer who had created an indexed view which spanned multiple tables as part of a release. Although the index was already created, it wasn’t being used by the application yet. Short after the release, they noticed large blocking chains. When large(r) operations were executed on one of the underlying tables, […]