SSRS Subscription Schedules

Reporting Services

Reporting Services (SSRS) is a tool that permits you to create and deliver feature rich reports. The reports can...

T-SQL Tuesday #091 – Databases and DevOps

Implementing DevOps with databases presents a unique set of challenges. However, just because something might be hard doesn’t mean that...

var Microsoft_Data_Platform_MVP = “Yip.”;

The 2nd June 2017 will always be something of a special day for me.
It was the day I was awarded...

Working with Data in Always Encrypted

In this post we’re going to create some encrypted columns in a table in a test database and look at...

An Unexpected Side-Effect of Invoke-WebRequest

Recently I was working on a bit of PowerShell to download the awesome First Responder Kit from Brent Ozar Unlimited. The canonical URL for the FRK is http://firstresponderkit.org/ but...

Backup to NUL

Yes, I spelled that correctly. NUL not NULL. NUL is basically a location you can send a backup to. In...

Database Fundamentals #1: Install SQL Server

To get started with SQL Server, you need to install it. However, I’m not going to teach you how to...

Endpoint Owners – Back to Basics

"What the heck is an endpoint?" Well, that is a good question. An endpoint in the simplest form is a connection or point of entry into SQL server.
Related Posts:

Changing...

Endpoint Owners – Back to Basics

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

Experienced DBA: Rookie Mistake

M.A.S.H 4077.  Mobile Army Surgical Hospital.  One of my all time favorite TV shows that I still watch to this...