How Do I Add an R Package to SQL Server from In-Database R?

Hello Dear Reader!  I'm working on some really fun stuff with in-database R using SQL Server 2016.
I needed to...

TSQLTuesday.com

I’ve hosted a page on this blog that has all the T-SQL Tuesday blog invitations and roundups linked. I did...

Determining the Cost Threshold for Parallelism

In the previous post, I showed how you can get full listings of your execution plan costs. Knowing what the...

Power BI Custom Visuals Class (Module 40 – Long Text Viewer)

In this module you will learn how to use the Long Text Viewer Power BI Custom Visual.  The Long Text...

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