April 2010 - Posts

• When a restore isn’t really complete - vote on Connect

  This week I discovered that restoring from a full backup doesn’t always restore SQL Server to the same state it was in when the backup was made. There are three settings that, if enabled, are not restored after a database restore. Thanks to Greg Low for Read More... Posted Thursday, April 15, 2010 3:36 PM by John Paul Cook | 4 Comments

• Auditing database source code changes

  Auditing changes to database source code can be easily implemented with a database trigger. Here’s a simple implementation of stored procedure auditing using an audit table and a database trigger. It assumes that a schema named Audit already exists. CREATE Read More... Posted Monday, April 12, 2010 4:41 PM by John Paul Cook | 3 Comments

• Making meetings much more efficient

  Water. Yes, it’s that simple. There needs to be a rule that whoever convenes a meeting be required to drink water. Half a liter of water when the meeting begins and another half a liter every half hour thereafter. That simple rule will motivate the meeting Read More... Posted Thursday, April 01, 2010 11:55 AM by John Paul Cook | 3 Comments Filed under: April Fool's Day