Building Open Source PowerShell

Open Source PowerShell is available on several operating systems, that really what’s special about the whole project! To get PowerShell to function on these various systems we need to...

Building Open Source PowerShell

Open Source PowerShell is available on several operating systems, that really what’s special about the whole project! To get PowerShell...

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

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