DBCC CloneDatabase for SQL Server 2012

Dear All,

In case you are wondering, title of the post is not a typo 🙂 DBCC CloneDatabase is going to be...

Setting Up a Drillthrough Action in your Power BI Report

At some point this weekend, the Microsoft Power BI folks turned on the drill-through feature in the Power BI service....

New Baby Musings (AKA Things I’ve Thought Upon On Sleepless Nights)

Hello!
One month ago I became a dad for the 3rd time. And so my spare time, which has always been...

Thank you for Microsoft MVP

My head may very well explode. I was done some tuning today and glanced at the Outlook new mail notification....

Livestreaming the Redgate Hub for the US

The Livestream launch for the Redgate Community Hub is next Wednesday, Sept 6, 2017. To ensure that our customers and...

Macros in ER/Studio Data Architect is your data modeling lifebelt

[2017-Sep-01] There is a well-known phrase, "the rescue of a drowning man is the drowning man's own job" from one of the...

Sample Databases For SQL Server

As a blogger, one thing that I appreciate greatly is examples of technical features. This is mainly because
technical features can...

SSIS ForEach Enumerator File Order

I saw on slack recently a question about how the ssis file enumeraror orders (or more specifically doesn't order) files....

Knowing Your Data

Is it possible to be an effective data professional without knowing anything about the domain of data you support? I...

Viewing the Statistics Objects Used to Create an Execution Plan

A while ago now I was running some Performance Tuning workshops and was asked how you can find out which Statistics...