My Favorite SQL Prompt Features

SQL Prompt from Redgate Software is one of the tools that I cannot live without. Well, that’s probably an exaggeration...

Implementing Smart Differential Backups Using Ola Hallengren’s Backup Scripts in SQL Server 2017

This is part 2 of 2 on taking smart backups. I wrote a previous blog on how to use configuration...

How to run a PowerShell script file with Verbose, Confirm or WhatIf

Before you run a PowerShell command that makes a change to something you should check that it is going to...

Inverted Polygons? How to Troubleshoot SQL Server’s Left Hand Rule

Last week we looked at how easy it is to import GeoJSON data into SQL Server’s geography datatype.
Sometimes your source...

Inverted Polygons? How to Troubleshoot SQL Server's Left Hand Rule

Last week we looked at how easy it is to import GeoJSON data into SQL Server's geography datatype.
Sometimes your source data won't be perfectly formatted for SQL Server's spatial...

Introducing: The SQLUndercover Inspector

Introducing: The SQLUndercover Inspector! Finally we have a V1 almost ready to hit our GitHub but what exactly is it?
 

Just another...

Server Audit Mystery 1: Filtering class_type gets Error Msg 25713

The other day I ran into an odd problem trying to answer the following question on DBA.StackExchange:
How to filter out...

Outlining (Day 22)

SSMS supports Outlining, the ability to selective hide blocks of code. This can be very useful, especially when working with...

Outlining (Day 22)

SSMS supports Outlining, the ability to selective hide blocks of code. This can be very useful, especially when working with...

The world of Automatic Tuning – SQL Server 2017

Times are changing, 10 years ago I would never have thought that self-tuning databases would be available as a packaged...