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

Send email from Powershell with attachment

This post  describes how to call  to add an email attachment using Powershell.
In an earlier post - SQL Server – Send email...

Arithmetic Overflow in sp_MSarticle_validation

This is probably a rare occurrence — but I've noticed that data validation for an article with 10 billion or more...

February 2012 – Monthly SQL Server Checklist

It’s the first Monday of February, mostly, it’s a short month, but there’s no reason to skirt on checking out...