I voted in the PASS Election - you should too!

If you are a member of PASS you have probably already received an email that looks like this:

--

From: <hq@sqlpass.org>
Date: Fri,...

Use Powershell to Manage Idera SQL Diagnostic Manager

Idera SQL Diagnostic Manager (or as I call it "SQLdm") is a great monitoring and performance tuning tool that I...

Time to Vote-PASS Board of Directors

It’s that time of year where we get to vote for the three best candidates to serve a two year...

SQL Saturday 151 Interview: Stacia Misner

Hello Dear Reader SQL Saturday 151 is just around the corner.  If you haven't registerd there is still time to...

Full Text Search – CONTAINS

I’ve been working on a new presentation for full text search and brushing up on some of my T-SQL operators....

Cannot assign a default value to a local variable !

You will hit this error Cannot assign a default value to a local variable in case you are running SQL 2005/below,and you try...

SQL SERVER : How to List All Email Subscription configured in SSRS ?

Often I used to get request from my business managers to get a list of all subscriptions configured in SSRS...

MDS Error: “The status of the specified batch is not valid”

In Master Data Services (MDS), I received a strange error when I was calling a stored procedure (stg.upd_name_Leaf) to batch...

Off to the Center of the Universe

“New York City…center of the universe..” – Rent
I’m off to New York this morning for the start of the 2012 SQL...

DBA Manager Needed in Orlando–Putting My Network to Work!

I”m working with a client in Orlando that needs a manager for their data team, seems like a prime opportunity...