Modifying SQL Server Synonyms

One task that often needs to be done when migrating a database to production for the first time is to...

SQLSaturday Goes International

Looking at 2011 and the planned events so far for 2012 it’s easy to see that SQLSaturday is starting to...

Mark a Disk Partition as Inactive

If you are like me then you like to reinstall Windows on your laptop every few months to keep things...

Full Load. Incremental Load. Whaaat?

Back when i was in school, me and a bunch of friends used to hangout at a diner. The diner was...

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