SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

DotNine SQL Server and more

I am a database specialist from the Netherland with my main focus on Microsoft SQL Server. My IT career began 14 years ago as a System Administrator. I have been working with SQL Server for more then 10 years now and a full time DBA for 5 years.

Switching blog website

For quite some years now I have been active on my blog over at www.dotnine.net. While there was nothing wrong with blogging through that URL I frequently got some feedback that my blog posts were difficult to find. People don’t directly associate DotNine with SQL Server, analytics or my… Read more

0 comments, 137 reads

Posted in DotNine SQL Server and more on 14 November 2018

Speaking at PASS Summit

The title says it all, this year I have been selected as a speaker at the world’s largest Microsoft Data Platform conference: PASS Summit!

I will be presenting on one of my favourite topics: In-database analytics inside Microsoft SQL Server (www.pass.org/summit/2018/sessions/details.aspx?sid=76976). So if you happen to be at… Read more

0 comments, 170 reads

Posted in DotNine SQL Server and more on 31 October 2018

Crazy Data Science

I am pretty hyped to be able to finally announce a new project of mine that I have been working on for quite some time now: Crazy Data Science!

Crazy Data Science is a YouTube channel I created to show off real-world Data Science methods and techniques applied to… Read more

0 comments, 277 reads

Posted in DotNine SQL Server and more on 13 March 2018

Accessing AzureML models through SQL Server in-database R services

In a previous article I discussed the various methods available in SQL Server 2016 & 2017 to perform in-database analytics. In the article I used a model that was stored directly inside SQL Server to perform predictions. But what if your models are not stored inside SQL Server but are… Read more

0 comments, 1,844 reads

Posted in DotNine SQL Server and more on 11 December 2017

Performing in-database predictions in SQL Server 2016 & 2017

Starting from SQL Server 2016 Microsoft put a lot of effort into integrating various languages used in machine learning and statistical analysis inside their database engine. In SQL Server 2016 Microsoft introduced the integration of the R language and in SQL Server 2017 Python was added.

Both these languages give… Read more

5 comments, 1,150 reads

Posted in DotNine SQL Server and more on 17 October 2017

Azure Machine Learning Algorithm Flowchart

When you are working with Machine Learning there are many things you need to keep an eye on. You need to prepare the data, deal with any missing values and you need to select an algorithm you will be using for you model.

Choosing an algorithm can be a difficult… Read more

0 comments, 1,216 reads

Posted in DotNine SQL Server and more on 21 July 2017

Using Azure Machine Learning with an on-premises Database

With Azure Machine Learning (AzureML) you have access to a cloud based, flexible and friendly method to perform machine learning tasks on your data. One disadvantage I frequently run into is that cloud based approach of AzureML since the data you are building your machine learning models on has to… Read more

1 comments, 2,401 reads

Posted in DotNine SQL Server and more on 14 May 2017

GroupBy conference recording of Introducing the SQL Server 2016 Query Store available now!

Good news!
The recording of my session “Introducing the SQL Server 2016 Query Store” at the GroupBy conference 2 weeks ago is available for your viewing, listening and reading pleasure!


Not only is a video recording available at the page above, but also a podcast version if you prefer… Read more

2 comments, 1,352 reads

Posted in DotNine SQL Server and more on 5 May 2017

Wait Statistics integration inside the Query Store in SQL Server vNext

I remember writing an article about Query specific wait statistics being available inside execution plans in SQL Server 2016 SP1. The way that works is when you view the actual execution plan of a query (through SSMS or the XML) you are able to see the wait information that specific… Read more

2 comments, 1,365 reads

Posted in DotNine SQL Server and more on 23 April 2017

Configuring and analyzing the Query Store through dbatools

In case you didn’t know this already, dbatools is an awesome collection of Powershell functions that will help you immensely in your work as a DBA. Just one example: migrating SQL Server Instances takes a massive amount of work. You need to backup and restore every database, write down instance… Read more

0 comments, 2,094 reads

Posted in DotNine SQL Server and more on 27 February 2017

Comparing plan consistency and query performance using the Query Store Replay script

The 1.2 version of the Query Store Replay script a number of new features are added that return information of the query behavior on the target server. More specifically, in version 1.2 you are able to compare execution plans and query runtime statistics between replay executions on the source and… Read more

2 comments, 1,870 reads

Posted in DotNine SQL Server and more on 30 December 2016

Replay your workload through the Query Store Replay script!

One of the great features of the Query Store is that it stores query execution plans and runtime performance on-disk and makes it easily accessible through its DMVs and built-in reporting.
Using the information inside the Query Store can make database migrations to higher SQL Server versions far easier, since… Read more

4 comments, 748 reads

Posted in DotNine SQL Server and more on 19 December 2016

Query Store Database Dashboard v1.3 released!

Next to releasing a new version of sp_WhatsupQueryStore, I just released the 1.3 version of the Query Store Database Dashboard!

Release notes:

  • Forced execution plan overview removed Instead you should use sp_WhatsupQueryStore to quickly analyse forced plans by running EXEC sp_WhatsupQueryStore @dbname = ‘your database’, @return_forced_plans = 1.


Read more

0 comments, 424 reads

Posted in DotNine SQL Server and more on 15 December 2016

sp_WhatsupQueryStore v1.2 available

sp_WhatsupQueryStore v1.2 has just been released!
In this new version additional parameters are added to control what information is returned and a change has been made to the information that is returned by default.


  • Changed what information is returned by default when no additional parameters are supplied.
    In the…

Read more

1 comments, 405 reads

Posted in DotNine SQL Server and more on 15 December 2016

sp_WhatsupQueryStore version 1.1 released

Today I released a new version of the sp_WhatsupQueryStore stored procedure. sp_WhatsupQueryStore returns many configuration and performance metrics that are stored inside the SQL Server Query Store through an easy to use stored procedure.

In version 1.1 many new optional parameters are added that influence the output of the stored… Read more

0 comments, 420 reads

Posted in DotNine SQL Server and more on 6 December 2016

Retrieving Query Store query performance data through sp_WhatsupQueryStore

This afternoon I tweeted that a new Query Store related stored procedure I created is available: sp_WhatsupQueryStore.This blog post goes into more detail on how you can use sp_WhatsupQueryStore to easily and quickly retrieve query performance data from the Query Store.


The first thing you want to do… Read more

10 comments, 2,375 reads

Posted in DotNine SQL Server and more on 24 November 2016

SQL Server 2016 SP1 Query Specific Wait Statistics Available Through Execution Plans

SQL Server 2016 SP1 added loads of cool new features and options. One of those is a change that expands the amount of information that is stored inside an execution plan. Since I love using Wait Statistics as a way to identify performance bottlenecks, I was literally jumping through the… Read more

5 comments, 1,700 reads

Posted in DotNine SQL Server and more on 20 November 2016

Query Store changes in SQL Server vNext CPT1

Not only did we receive a brand new Service Pack for SQL Server 2016 this week, since yesterday we are able to play with the first Community Technology Preview (CTP) of SQL Server vNext!

Since I adore the Query Store feature which was introduced in SQL Server 2016, a large… Read more

0 comments, 714 reads

Posted in DotNine SQL Server and more on 17 November 2016

SQL Server 2016 SP1: DBCC CLONEDATABASE now with Query Store data!

SQL Server 20016 SP1 is released today and it introduces a truck load of new features and options. Even better, it makes many of the Enterprise only features available in Standard!

Ever since SQL Server 2014 SP2 introduced the new DBCC CLONEDATABASE command to create a schema and statistics… Read more

2 comments, 1,083 reads

Posted in DotNine SQL Server and more on 16 November 2016

Query Store Instance Dashboard

Last week I shared my custom Query Store Dashboard that can be used to view additional performance information that isn’t always directly available through the built-in Query Store reports.

The dashboard I shared last week returns information on a per-database basis by right-clicking a database with the Query Store enabled… Read more

1 comments, 1,032 reads

Posted in DotNine SQL Server and more on 7 November 2016

Older posts