Q.How Many Weeks in the Year? A.It depends

ISOWEEK 52 Weeks in the Year

Stardate 12:20:2011 Week 51 SSC.Com Web Blog, Planet Earth.  With only approximately two weeks left...

SQL Server 2012 – new conversion functions

With SQL Server 2012 comes a new set of conversion functions, that will certainly help doing type casts and conversions...

SSAS – Display Folders

Display folders are an often used tool in Analysis Services to help end users navigate through a cube or dimension...

Creating a Service Master Key in SQL Server

The basis for all the encryption in SQL Server is the Service Master Key, which is the top of the...

Suspect Database

Suspect database generally caused by internal IO issue, and the best way to resolve it to ask hardware person to...

SQL Server 2012 Diagnostic Information Queries (December 2011)

Since the final RTM release of SQL Server is getting ever closer, I thought it was a good time to...

Junk dimensions

Junk dimensions are dimensions that contain miscellaneous data such as flags and indicators.  When designing a data warehouse, you might...

Pitching Pebbles – Using Certificates to Grant Privileges

If you fill the jar with pebbles first, you'll never have room for the big rocks.
I’m sure you’ve heard the...

SELECT GetDate() – 30 AS [This actually works??];

I just ran across this in a piece of code (that I didn’t write):
… WHERE Thing >GETDATE()- 30
Aaaand it works....

PASS Summit 2012 Evaluation Results

I say it all the time because it’s worth repeating, feedback is a gift. Good, bad or indifferent (well, not...