A DateRange Table Valued function

The function is an inline table-valued function (or sometimes called a parameterised view) so it can be used just like a view or a table but needs parameters. It generates a single-column table of datetime2 with rows differing by any multiple of any of the dateparts that SQL Server provides.

ErrorHandling for running or deploying code

Do you ever wish you had a better way to run or deploy scripts? We use this format for all types of work.

A simple powershell script to look up server hardware and OS information

This is a simple powershell script to query and display hardware and OS information from a remote computer.

It uses CIM (Common Information Model) that is available since Powershell version 3 so as long as you have version 3 and up, you should be able to run this script against any server that you have access to.

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.