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

Rant: Security Isn't Sexy and It's a Shame

I grew up immersed in security. My father was a US Marine and going on and off base meant... security....

SQL Saturday #79 South Florida

SQL Saturday in South Florida is quickly approaching in just 2 short weeks.  As usual, if you are in the...

Applying a Snapshot -AltSnapshotFolder Parameter

Did you know a snapshot can be applied using the Distribution and Merge Agent –AltSnapshotFolder parameter?  This means that after...