Not An Administrator For Analysis Services Tabular

A couple of weeks back I installed SQL Server 2016 on my personal machine, including SSAS Tabular. Yesterday I created...

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...

Upcoming Speaking Engagements

In the next few months I will be speaking at some awesome events around Europe.
 
SQLBits – April 5-8 

SQLBits is THE SQL...

Speaking at VS Live–Austin

I’ll be speaking at Visual Studio Live – Austin in May 2017. I was fortunate to be selected to speak again,...

Database cloning – CLONEDATABASE

Database cloning is a new feature supported in SQL Server. Only SQL Server 2014 SP2 and SQL Server 2016 SP1 support cloning. The command syntax is very simple [crayon-5e96566157e7c824875345/]...

Database cloning – CLONEDATABASE

Database cloning is a new feature supported in SQL Server. Only SQL Server 2014 SP2 and SQL Server 2016 SP1 support cloning. The command syntax is very simple [crayon-5e81b52ed8fb5359335187/]...

Database cloning – CLONEDATABASE

Database cloning is a new feature supported in SQL Server. Only SQL Server 2014 SP2 and SQL Server 2016 SP1...

Queries with optional parameters

These are those queries where you are pulling for, let’s say, a first name, a last name, a state, and/or...

SQL VNext sp_configure on Windows and Linux with dbatools

This weekend I set up some SQL vNext virtual machines, two on Windows and one on Linux so that I...

The Empirical Rule

I am resuming technical blogging after a gap of nearly a month. I will continue to blog my re learning...