Create a Tally Function (fnTally)

Many people have published high performance, read-less, Inline Table Valued functions that use Itzik Ben-Gan's wonderful "Virtual Numbers Table" to replace WHILE loops and other forms of RBAR. This one is Jeff Moden's version.

Previous Monday to the Start of the Previous Quarter

Previous Monday to the Start of the Previous Quarter

VIEW to list running and completed jobs

This view will list all completed and running jobs. It give running times, current step (if active) and average run times for steps.

Look up AD user properties using powershell

I realize that this is a bit of a lengthy script for something that you can use a one liner in the power shell:

Example:

Get-ADUser

But I needed to highlight certain properties of given user and take certain actions based on the values. And the result is this power shell script.

Creating an Automated Database Update\Upgrade Script with RedGate SQL Compare Command-Line and Powershell

A script to drive SQL Compare for building upgrade scripts.

Add working days but avoid holidays

A function to add or subtract working days taking into account weekends and using a table of non-working days.

Count non-NULL rows and get definition

Get a count of non NULL rows.

Find Estimate Time of recovery for database after Reboot

This Script will  read the Estimated Time for recovery from Error Log

Generate views to correct the column collation on a target DB's tables automatically

You find you are querying a vendor supported database where you're not allowed to make any collation changes, and which has a weird collation setup: default DB collation that matches your server and other databases all character related columns are explicitly a different collation that does not match your DB or server collation Rather than […]

Audit Users logging in using "sa" or service accounts

Security is probably one of a production DBA's most important tasks and if developers use application or service accounts to run queries in your production environment you need to identify then and prohibit it. I notice some unwanted activity after staring a new job and decided to create a script that notifies me via email when […]