July 2008 - Posts

• Oh, What a Tangled Web

  At Tech Ed 2008 I made a mental note when Paul Randal mentioned that you can't use Database Mirroring when you've got the Filestream feature turned on. I like Database Mirroring and so that was useful information. In preparing a bunch of demos for SQL Read More... Posted Thursday, July 31, 2008 10:17 AM by AllenMWhite | 3 Comments Filed under: SQL Server 2008

• Partition Wizard Makes it Simple

  The partitioned table was one of the great new features of SQL Server 2005. We could now manage data based on some range data, usually a date value, and keep the different ranges in separate physical files, and use rolling range scripts to move old data Read More... Posted Monday, July 28, 2008 9:44 AM by AllenMWhite | 0 Comments Filed under: Database Administration, SQL Server 2008

• Tools for the Reluctant DBA

  We all know them, they're usually developers or network admins who show some abilities when database problems arise, so they're "elected" to the role of DBA, whether they want it or not. They often don't have the necessary training or insight into the Read More... Posted Monday, July 07, 2008 11:00 AM by AllenMWhite | 3 Comments Filed under: Database Administration