March 2009 - Posts

• How does that AD user account get access to the database?

  Granting Active Directory (AD) groups access to a database can quickly become complex when the AD groups may nest many levels. Consider the following scenario: You are requested to give Joe the same access to a database as John has. You look up John in Read More... Posted Thursday, March 26, 2009 2:19 AM by Linchi Shea | 8 Comments Filed under: Scripts, Scripting, Security

• Database snapshots -- are you using them?

  Database snapshots were introduced in SQL Server 2005, and have been around for several years now. One of the main motivations is that you can create database snapshots to protect your database from user or application errors. It's one more weapon in Read More... Posted Wednesday, March 25, 2009 7:09 PM by Linchi Shea | 24 Comments Filed under: SQL Server 2005, General trends

• A DBA utility database in every SQL Server instance?

  I was reading Louis Davidson’s post earlier today, and what he said below caught my attention: “I am a big believer in having the database be as self contained as possible, so I try to put [maintenance] objects and such in the database, typically in a Read More... Posted Monday, March 16, 2009 6:54 PM by Linchi Shea | 27 Comments Filed under: Best Practices