Fast Table Valued Function to return all prime numbers within a range

A TVF to select prime numbers

EmbeddedSplit8K

Starting from a string, it returns values embedded in delimiters.

Data Dictionary

I use this script to create data dictionaries.

Automatically Failover (Enable or Disable) Jobs Based on HADR Role

If you have a SQL Server with a High Availability solution (AlwaysOn Availability Groups, Database Mirroring, etc.), and you also have a bunch of jobs which you need to be run on the Primary server only. You need to be able to "failover" the jobs in case the Primary server is no longer Primary.

Detect and Repair Non Trusted Foreign Keys

Create the code to detect and repair non trusted foreign keys

String Replace in Stored Procedures with Powershell

Find a string in a stored procedure and replace with powershell

Disk Space Check

I was using this script to check disk space on individual servers for quite some time. And now since I started to use registered servers for MS SQL, I thought of a little modification to the script.

The Pesky Windows Power Plan Oh My

The below script will build a csv file for import of the servers Power Plan Setting.

Prevent accidental DB drop\delete

This script trigger will help you to accidental DB drop/delete

sp_what

Better* than sp_who2, with less re-checking data to get answers. Also, it is SnaZy. With a capital Z.

*Dont you just love totally non subjective assessments like this?