Syncing QA data with Production

Applies to: xSQL Data Compare v7.0.0 and higher

WARNING: this article focuses on the data transfer / synchronization task and does not address operation security issues and sensitive data scrubbing /...

Who owns your availability groups?

Question: Who owns your availability groups?
The person who creates the AG becomes the owner by default. Did you know that...

Who owns your availability groups?

Question: Who owns your availability groups?
The person who creates the AG becomes the owner by default. Did you know that...

Why Can’t I View My Power BI Content Pack?

I had a call with a customer this morning discussing different ways to publish Power BI content and how to...

Why I don’t love SELECT INTO

Long ago there were locking / blocking problems with the SELECT INTO statement. That’s not the case anymore and for AdHoc...

Data Warehouse Fast Track for SQL Server 2016

Microsoft Data Warehouse Fast Track for SQL Server 2016 is a joint effort between Microsoft and its hardware partners to...

Fun and Contests at Summit 2016

I’ll be attending the 2016 Pass Summit as a part of the Redgate Software crew. I’m not speaking this year,...

Installing SQLCMD

For anyone who wasn’t aware SQLCMD is a command line tool for running T-SQL statements and scripts. Before anyone says...

Statistics Are Vital For Query Performance

This is post #10 supporting  Tim Ford’s (b|t) initiative on #iwanttohelp, #entrylevel. Read about it here.
When you send a query to your...

This Week In Data – Episode 9 (What Does Pizza Have to Do with the Cloud?)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...