Monday Morning SQL Break – May 9, 2016

It’s Monday morning (er afternoon) and it’s time for this week’s blog and twitter round-up for last week. If you...

Notes From SQLSaturday Jacksonville 2016

Everything ran smooth The site reminds me of Orlando – limited space for sponsors, but offset by the other advantages (free...

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

SQL Server : Could not load file or assembly ‘Microsoft.SqlServer.BatchParser, Version=10.0.0.0

I have recently experienced an issue with a third-party  backup application (Commvault) that was trying to backup the databases from...

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 Command Timeout – Application Timeout – Attention

When you use ODBC or SqlClient to access data from SQL Server, by default the query will be cancelled if there is no response from the server within a...

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

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