Speaking at SQL Saturday Rochester this weekend!

I’ll be presenting my session Easing into Scripting with Windows PowerShell this Saturday, May 16th at SQL Saturday Rochester.
SQL Saturday is a free, all-day event for learning about SQL Server and...

Synchronizing Read / Write SQL Agent Jobs Across AlwaysOn Replicas

Intro
AlwaysOn availability groups are a powerful enhancement to SQLServer HA, and offer many improvements over older database synchronization techniques like...

Automating Storage Benchmarking with DiskSpd and PowerShell

My recent post on using the new DiskSpd utility to help you benchmark your storage is a great primer on how...

Building a job to monitor other jobs

The other day Tom Roush (b/t) and Tim Radney (b/t) were having a discussion on twitter about using scheduled windows...

Database Growth

Last week I got into a conversation with a colleague about how SQL Server grows the database.  We were both fairly...

Excel in T-SQL Part 2 – The Normal Distribution (NORM.DIST) Density Functions

Today’s blog will be the second in a multi-part series on replicating Excel functions in T-SQL, continuing with Excel’s NORM.DIST...

Getting Database Properties – DatabasePropertyEx()

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

MDX #46–6 different ways to detect a particular member in MDX script

There are many great tips in MDX with SSAS 2012 Cookbook
The book MDX with SSAS 2012 Cookbook has many great...

Powershell for SSRS in SharePoint: Multiple data sources and shared datasets

I thought that I would leave any further attempts to improve my Powershell script that was used to deploy SSRS...

Putting Your Head in the Clouds - Microsoft Azure

By David Postlethwaite

Microsoft Azure

Let’s take a look at the Microsoft Cloud offering. Originally called Windows Azure it was renamed in...