A Day In The Life of a SQLBits Volunteer

So SQLBits has finished for another year. About 1500 people registered for the largest SQL Conference in Europe held over...

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

Common uses of stored Procedure sp_MSforeachtable

We will get the brief idea about undocumented procedure sp_MSforeachtable of the Master database.

sp_MSforeachtable can be used to loop through all...

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

Events I Wish PASS Organized

I was talking a bit with a friend at SQLSaturday Jacksonville and realized I needed to write down a thought...

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