Pitching Pebbles – Using Certificates to Grant Privileges

I’m sure you’ve heard the story by Stephen Covey about the professor that fills a jar with rocks, pebbles, and sand as a metaphor for time management and prioritization. I’d relate it here, but I think this video is much more fun. Obviously this metaphor applies to all aspects of our lives, but we can [...]

December 19, 2011  Tags: , ,   Posted in: Security, T-SQL, Uncategorized  No Comments

Mirror, Mirror…

So, while I was discussing database snapshots in SQL Server, I kind of glossed over the subject of database mirroring, assuming you already had it set up in your environment.В  But maybe you don’t.В  So today I’m going to go through the steps involved in setting up database mirroring in SQL Server 2008.В  To keep [...]

March 21, 2011  Tags: , ,   Posted in: Features, General  No Comments