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

Participate in the PASS Election Process

Once again it is time for the Professional Association for SQL Server (PASS) Board of Directors election. This year there...

Running a document database on Sql Server

Running a document database on Sql Server.
Since Microsoft is slow to come out with a product of their own to...

SP_HELPTEXT showing old Store Procedure name after rename, is it a Bug?

Question : Today morning, I received a call from one of my old friend, with an query for SQL Server. He...