Randi Vertongen

06 Mar 2019 SQL Server Plan Guides: A Walkthrough, Part 2

In the first part of this blog series on SQL Server plan guides, we looked into the basic plan guide setup. In this part we will be taking a closer look at somethings you cannot do as well, as how to add a plan guide to procedures, and how to find queries that are using plan guides.

12 Feb 2019 SQL Server Plan Guides: A Walkthrough Part 1

Plan guides are some strange things, and can be very high risk. This post does not have the intention to get all you fine people to implement plan guides everywhere, it should be one of the last resort options in your toolkit.

19 Dec 2018 Queries are running slower after migrating?

There's a solution for everything. If your queries are running slower after migrating, you can use the Query Store to force lower compatibility plans.The query store is a very easy way to track the queries happening in your database, ...

13 Dec 2018 When the SQL Server Agent overrides default behavior: QUOTED_IDENTIFIER

For a customer, I recently migrated one of their databases from 2012 to 2017, whilst putting compression on all the indexes. The process of recreating the Indexes on 8 new filegroups took 3 hours for a 400GB database.

07 Nov 2018 How To: Azure SQL DB Cross database queries using synonyms

When helping a fellow dba on dba.stackexchange.com, I came across an interesting subject. What about synonyms in Azure SQL DB? We know that synonyms that stay in the current database scope work, but how do we get cross db synonyms to work?

26 Jun 2018 SQLGrillen 2018: “Fun for the whole SQL family”

On June 22 a delegation of fourteen Koherians went to Lingen in Germany to attend the event SQLGrillen 2018. Colleague Randi Vertongen joined the club. Read his report of a day full of databases, bratwurst and beer.

26 Mar 2018 Security features in SQL Server 2017

SQL Server has many features that support creating secure database applications. In this blogpost I’ll guide you through the latest security features in SQL Server 2017: Common Language Runtime (CLR), dynamic data masking, row level security and always encrypted.

16 Jan 2018 Efficient and clear-cut monitoring of your databases with SQL Operations Studio

A while ago, Microsoft released a preview version of SQL Operations Studio. We've tested the preview version to get acquainted with it.