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

Digital Privacy is the Wild West

Who has the legal right to access your personal and private digital assets? The answer can be complex, and will...

Installing Windows Server 2016 Nano on a Physical Server

Hey guys! So here's my adventure in deploying Windows Server 2016 Nano on a physical server. It was a hard...

Monday Coffee 2017-02-27

Ergh, not a fun weekend rugby wise. But anyway…
Last week Microsoft released an image for SQL Server 2016 SP1 Developer...

Red Gate SQL Clone (#1) - Initial Setup

Note this was during earlier beta usage, so some of the UI and other features will have been updated more....

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

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

Columnstore Indexes – part 99 (“Merge”)

Continuation from the previous 98 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is focused on the...

Friday Reading 2017-02-24

Wow that week absolutely flew by! Here’s what I’ve been reading…
Seatbelt learning with Uncle Buck

Buck Woody goes through how he...

Improve performance by replacing temp tables with memory optimized tables - Part 3

Welcome to the last part of this series, you can find the previous post here (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2017/02/01/improve-performance-by-replacing-temp-tables-with-memory-optimized-tables-part-1/) and here (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2017/02/08/improve-performance-by-replacing-temp-tables-with-memory-optimized-tables-part-2/).

Previously we...