Public Role and Security

A good rule of thumb with the public role is to leave it be.  Do not add permissions to this role.  Add permissions on a per database  and per...

Public Role and Security

Having flown a fair amount lately, I was thinking about the various levels of security within an airport.  Part of...

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