AWS EC2 Linux AMI with pyodbc

AWS EC2 Linux AMI with pyodbc, psqlODBC, Microsoft ODBC Drivers Context: Using pyodbc within a small python application to pull tracking data from an Azure SQL Server DB, do...

Using dbatools to verify your SQL Server instances version compliance

One of the main DBA's duties is to guarantee that SQL Server instances are up-to-date in terms of patches (Service...

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...