SQL Server 2011 “Denali”: Get T-SQL query metadata without executing it

SQL Server 2011 “Denali” introduces couple of new procedures which enable you to read query metadata without executing it. Previous...

Presenting Hardware 301 at 24 Hours of PASS on September 7

PASS just announced today the next occurrence of 24 Hours of PASS (24HOP), which is called the Summit Preview version....

Register for 24 Hours of PASS NOW! #sqlpass

Do you need to perfect your SQL Server skills?  Would you like to get 24 hours of free SQL Server...

How to Run Programs as a Domain User from a Non-domain Computer

As a consultant or contractor, many times the client we are at does not provide us with a laptop, so we must...

SSAS errors: DefaultMember(Measures,Measures) (1, 1) The ‘[xxx]‘ member was not found in the cube when the string, [Measures].[xxx], was parsed.

When attempting to browse an Analysis Services cube you may be presented with the following error message:

DefaultMember(Measures,Measures) (1, 1) The...

A Really Bad Day

I was out of town for work one day, literally on the other side of the country, in a car...

I’m A Part Of Things Greater Than Myself, The POSSE Is Here.

Something Is Missing…
Some of you know I have a deep passion for the SQL Server community. I’ve always been extremely...

All About Execution Plans

If you’re attending the PASS Summit this October, I’d like to make a suggestion. The Summit itself is only three...

Detecting Fake Reviews

I saw this write up about Cornell coming up with a way to detect fake online reviews with about 90%...

Updating Views

Written by Ian Treasure
 
Gethyn recently posted on deleting from a view. He used a common situation where several tables are...