Coffee's Variety Problem

Spaghetti Sauce Origins
During the 1970s consumers had a limited number of spaghetti sauces that they could purchase at their local supermarket. Each store-bought sauce tasted the same, developed in test...

Power BI Custom Visuals Class (Module 25 – Scroller)

In this module you will learn how to use the Scroller Power BI Custom Visual.  The Scroller has the appearance...

Delayed Durability in the wild…

Background
We have recently been working on large data migration project for one of our clients and thought I would share...

More dbatools–Get-DbaTcpPort

After the MVP Summit, I was excited to check out more code and features in all aspects of SQL Server,...

Business Analytics Day Jan 11, 2017 Chicago

I hope you can join me at the Chicago Microsoft Technology Center for the PASS Business Analytics Day, on Wednesday,...

Why would you never use SSIS Fast Load…?

We all know that if you want SQL Server to push data into a table then you want to batch the...

Test Post

When was my index created or at least last updated?

SQL Server stores a create date and a change date for each object in the sys.objects system view.

Unfortunately while...

Monday Coffee 2016-11-14

Communication in the workplace.
With the release of Microsoft Teams we now have a dazzlingly array of software designed to increase...

Enabling Cortana for dbareports PowerBi

Last week at the Birmingham user group I gave a presentation about PowerShell and SQL Server

It was a very packed...