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

Reblog: July 25 to July 31

Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...

Speaker of the Month: August 2014

Speaker of the Month is now officially one year old.
I went back and reread my first post. The goals were...