Murder in Raleigh

I am about to set sail on a new venture with my next official whistle stop.  This year has been plenty full of whistle stops and I plan on...

Murder in Raleigh

I am about to set sail on a new venture with my next official whistle stop.  This year has been...

Writing Parametrized MDX for Reporting Services

Writing MDX inside of Reporting Services has been the nemesis for many report writers for far too long.  If all...

Deny vs Revoke

Quick quiz. Which of these two commands is the opposite of GRANT?
DENYREVOKE 

Well lets start with some definitions
GRANT – Grants permissions on...

Effective Business Intelligence

How Business Intelligence Can Help
Effective business intelligence starts with questions that will help your organization make better decisions.  For example,...

ExpressProfiler - new release

Just released new build of ExpressProfiler.
No major changes, just cosmetic improvements - shortcut here, confirmation dialog there, new captured events (SQL:StmtStarting/Completed,...

Renaming or Changing SQL Server Cluster Instance

Renaming or Changing SQL Server cluster instance process is bit different from renaming a stand-alone instance.
Refer : Rename or Change SQL...

Let SQL Server Write Code for You

Introduction
Many times I happen to find myself in a situation where, as a DBA, I need to write some long...

Building The SQLSaturday Orlando Marketing Plan-Part 29

Received an email from LinkedIn that the ad was approved and so far we’ve spent a whopping 83 cents! Not...

Building the SQLSaturday Orlando Marketing Plan-Part 28

Today at lunch I looked at LinkedIn advertising. I only capture the last part to share here, but you put...