SQL Server 2012 AlwaysOn now officially supported by VMware

I read yesterday that VMware has updated the “Microsoft Clustering on VMware vSphere: Guidelines for Supported Configurations” KB article linked...

The State of Microsoft Self-Service Reporting

(article published on the MVP Award Program Blog) I really enjoy this topic.  One of the reasons, I suppose, it’s...

Come See Us at SQL Saturday #165 in Lincoln!

I will be speaking with several of my House of Brick Technologies colleagues at SQL Saturday #165 in Lincoln in...

DBMail on a cluster

I’ve always found clusters a pain in the neck.  For my latest pain I just spent the last 2 days...

Excel 2013 – Trouble Installing Silverlight for Power View

Last week during my 24 Hours of PASS session on Choosing a Reporting Platform I fielded a question that appeared...

How BETWEEN is inclusive

This is a old and simple one, but an important subtlety that TSQL developers must be aware of.

Using the BETWEEN...

Interviewing a DBA

I’m not a fan of trivia style interview questions. Yes, I ask a few because you have to in order...

Log File Full–Availability Group Database

I run into an interesting issue with an Availability Group database recently. I was running a data load against a...

One More Reason for Portable Applications

I bet most of us don’t think about installing software that we need/want to try. We’re either running as local...

OVER() clause two simple ways on two different days

I’ve been aware of this clause in TSQL for a long time, but I’ve never really used it. Mainly because...