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

Awesome new features in SQL Server 2011 “Denali”: IIF and CHOOSE functions

SQL Server 2011 “Denali” introduces two new features for flow control which may help you to keep your T-SQL cleaner than...

Bad Network Performance? Check the TCP Chimney Offload/Receive Side-Scaling/Network DMA Settings

We recently ran into a case where connecting to a Windows Server 2003 server with SQL Server installed on it,...

Fitting In-The Editorial

This editorial I wrote ran on SQLServerCentral a couple weeks back and generated a lot of comments, and more than...