S3OLV – Get your Merge On

We are rapidly closing in on the February meeting for S3OLV.  You might remember reading about the upcoming meeting here.
We...

Freedom

Not too long ago, I blogged about a Book called Daemon.  Freedom is the sequel to Daemon. I enjoyed reading this book.  The story continues from Daemon, but in...

Freedom

Not too long ago, I blogged about a Book called Daemon.  Freedom is the sequel to Daemon.
I enjoyed reading this...

Opt In/Out of Personalized Microsoft Ads

Nice to have the option, you can opt-out (default is in) of having personalized ads. I turned it off, the...

Avoiding Bad Query Performance

There’s a very old saying, “When you find yourself in a hole, stop digging.”
And my evidence today is:

That’s certainly not...

LAST_VALUE() Analytic Function–SQL Server 2012

Earlier, i discussed FIRST_VALUE() function. FIRST_VALUE() returns the first value from an ordered set of records. Similarly LAST_VALUE() returns the last...

PIPE CLIP – (| CLIP)

The main focus of this blog is to write about SQL Server related stuff – but now and then in the...

Webcast: Successfully Meeting Your Audits for SQL Server

Tomorrow at 3 PM Eastern I'll be giving a webcast in conjection with Idera and MSSQLTips.com:
 
Registration for Successfully Meeting Your...

A Script A Day - Day 7 - Memory Queries

Today's script is a collection of a few memory queries I've collected from various sources over the years.  These queries are by no...

Conditional Default Values in SSRS

I’d like to share with you a laziness efficiency method I use when developing reports in SQL Server Reporting Services. ...