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

My SQLbits sessions

Since today its official, I'm presenting 2 sessions at the SQLbits conference in Liverpool
(http://www.sqlbits.com) from September 30 –
October 1. Here...

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

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

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

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

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

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

Updating Views

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

August Monthly SQL Server Checklist

First day of the month and first Monday of the month.  The list is coming out a bit late due...