Powershell script to find SQL Server instances on remote servers

This is actually part 2 of a process I am creating to automatically discover SQL Server instances in an Active Directory domain. So there will be a series of...

Getting Your SQL Server Backup Footprint

Recently, I needed to be able to determine the total size for all the most recent full backups for certain servers. Luckily for me these particular servers were using...

Find clustered index on non primary key columns

First, some blah... blah... blah...

By default when a primary key constrained is created on a table/view,  SQL Server automatically creates a unique clustered in order to enforce it.  And...

Detail Job History – Back to Basics

With this script, I have the ability to quick show which step is failing, what the command is for that step, what kind of process is running on that...

Detail Job History – Back to Basics

With this script, I have the ability to quick show which step is failing, what the command is for that step, what kind of process is running on that...

Introducing sp_AzSQLDBPermissions (Beta)

I’ve written a version of my permissions scripts for Azure SQL Database. It’s still in Beta but I’m confident enough ... Continue reading

What about orphaned windows users?

I should start off by mentioning that this post is applicable to sql server versions 2012 and up. If you have an older version of sql server, the solution...

SQL Server 2008 and 2008 R2 is end of life on 9 July 2019

Next month, Microsoft is ending five years of extended support on SQL Server 2008 and SQL Server 2008 R2. This follows five years of mainstream support before that. You...

Understanding Columnstore Indexes in SQL Server Part 1

Recently I reviewed filtered indexes, this time let’s look at columnstore indexes. These indexes are very useful for data warehouse workloads and large tables. They can improve query performance...

Basic User Functions in R

As I’ve been learning more about the data platform, I’ve been exposed to some R language code. This makes sense, as more comprehensive data analysis needs something other than...