Thoughts on the 2016 PASS Summit

I’ll have several more posts this week on specific activities at the Summit, but wanted to start with how the...

When disks have different sector sizes for primary and secondary replica log files in an AlwaysOn Availability Group Config

Recently I was analyzing a stress test result for an AG configuration, and as usual I was reading to SQL error logs to see if there is anything out of...

When disks have different sector sizes for primary and secondary replica log files in an AlwaysOn Availability Group Config

Recently I was analyzing a stress test result for an AG configuration, and as usual I was reading to SQL error...

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