Automating DBCC Page

Way back in 2006, Paul Randal documented DBCC PAGE on his Microsoft blog at http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/10/625659.aspx. In his post, you will...

Data gateway confusion

Microsoft has created data gateways as a way that cloud products such as Power BI and Azure Machine Learning can...

Optimize For Unknown

Hello Dear Reader!  It's been a while.  I was working with a friend and we came across an interesting problem....

Power BI Custom Visuals Class (Module 30 – Linear Gauge)

In this module you will learn how to use the Linear Gauge Power BI Custom Visual.  The Linear Gauge would...

Run Book, Run!!!

How many of you actually have a “Hit-by-the-Bus” handbook? What is that, you ask? It is a document that explains...

sp_helptext vs object_definition()

I’ve been using sp_helptext for years. Honestly I probably end up using it at least once a day. But I...

SQL Agent Permissions

Problem

I was contacted by a user asking if it was possible for his team to be able to execute specific...

Database Backup History – Back to Basics

In this article I explore the basic of querying backup history data as a foundation to reporting on essentials such as storage and job management.
Related Posts:

The Mystery of Missing...

Database Backup History – Back to Basics

Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...

Database Configuration

It’s amazing just how much the landscape changed with the release of SQL Server 2016 SP1. For example, I just...