Writing More This Month

I haven’t written much in a while, having had to put more time into both personal and professional obligations over...

A New Beginning #SQLFamily

For the years I have been watching the SQLPASS session recording and hearing that it's really a different experience to...

Query Store - Part 3 - How it works?

Query Store collects 2 important kinds of data. They are

1) Compile time statistics - Query Plan, Estimated Costs, Estimated number of...

Always Encrypted Column Encryption

I have a need to encrypt a column within my SQL Database (Azure). I decided to use Always Encrypted. This feature...

ETL Atomicity

I still remember the first real ETL process I developed. I was working for a hospital at the time, going...

Folders to Check for errors in SQL Patching or Installation

Recently, while applying SQL Server 2012 Service Pack 3, encountered the following error and SQL Patch failed to upgrade.

"The patch...

Looking Back–Game Night at the 2016 #sqlsummit

I’m trying to look back at some of the events of the recent Summit, and Game Night was one of...

Master Data Services – Database Error has Occured when Publishing Business Rule

I was preparing a demo for a session about the new features of Master Data Services in SQL Server 2016....

Open Data is like a soup

[2016-Nov-04] Open data is like a soup, some people like it hot (or made with all the latest updates); some people...

PASSion Award and what it means to me

2016 is going to be a special year in my life. There was an article on Oscar awards a while...