SQL Server 2016 at the BRSSUG Meeting on May 11

Looking forward to the BRSSUG/BRPBIUG meeting this Wednesday night May 11, I'll be giving a presentation all about SQL 2016!

This...

SQL Server – Row Level Security in SQL Server 2016 – Part 3

Hi friends, continuing from the previous post in this post we will learn how to add the blocking predicate to...

Update to Date and Time Dimensions

Wanted to just post my latest versions of my Date and Time Dimension scripts.  It has been a couple years...

Why I Love SQLBits

Last week I attended SQLBits 2016 in Liverpool. I had such a great time, and I would like to share...

Why I Love SQLBits

Last week I attended SQLBits 2016 in Liverpool. I had such a great time, and I would like to share...

Putting your Head in the Clouds–An Introduction to Cloud Computing and Microsoft Azure

If you attended David’s session Putting your Head in the Clouds today at SQL Bits today you can download the...

SQL 2016-Always Encrypted

As you know this has been introduced in sql server 2016, I am not going in details on it but...

Connect is Working! Get in While the Getting is Good!!!

TL;DR: Go Vote / File on Connect NOW! For years I’ve avoided Connect, it’s true. In an ironic twist fit for a recursive-CTE I think I quit using Connect...

Connect is Working! Get in While the Getting is Good!!!

TL;DR: Go Vote / File on Connect NOW!
For years I’ve avoided Connect, it’s true.
In an ironic twist fit for a recursive-CTE...

A strange OS bug on a SQL Server migration

This is another situation that happened on a database migration at a client site. The database migration was done by using SSIS packages on quite a big database of 450 GB,...