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

ETL Atomicity

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

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

Webinar on Change Tracking for Data Warehouse Loads

Join me online on Tuesday, November 15th at 1:00PM as I host a webinar entitled “Managing Data Warehouse Incremental Loads...

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

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

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

Launching Columnstore.NET

I am so glad that the time has arrived to announce my next project – the Columnstore.NET! This site will incorporate...

PASS Summit Announcements: Power BI reports on-prem in SSRS

Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception.  I’m writing a set...

Reinforcing the Importance of Statistics on Row Estimate

I recently wrote an introductory post about the importance of statistics. I just received a reinforcement on how important they...