Getting Database Properties – DatabasePropertyEx()

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

Stairway to Virtualization Level 2 up at SQL Server Central

Yesterday the next installment of the Stairway to Virtualization series went live on SQL Server Central! This level focuses on...

Speaking at 24 Hours of PASS

I’m thrilled to announce that I’ve been selected to present as part of the next 24 Hours of PASS! The...

Database Growth

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

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...

Test first; Mileage may vary;

I went to a SQL Saturday recently and saw a number of great sessions. If you haven’t been to a...

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...

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...

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...

Script and Presentation DAC- Universal Automated SQL Installations