Browse by Tags

• Conferences
• Katmai
• New Features
• SQL 2005
• SQL Community

• Some things don't change - DB Snapshots & Backups of Snapshots

  Again, I wanted to blog about something that still does not change between 2005 and 2008. At a recent conference, there were some great questions/ideas that should make it to Connect if they haven't already. When DB Snapshots were first introduced, one Read More... Posted Thursday, May 08, 2008 12:40 AM from Rick Heiges | (Comments Off) Filed under: SQL 2008, high availability, SQL 2005

• Some things don't change - Partitioning

  After spending the past couple of weeks at the MVP Summit in Seattle and at SQL Connections in Orlando, I thought I should blog about things that do not change in 2008 (at least partially). One of the reason s to partition your tables is to make it more Read More... Posted Monday, April 28, 2008 9:09 AM from Rick Heiges | (Comments Off) Filed under: SQL 2008, Katmai, high availability

• No More HCL - in 2008

  The old Hardware Compatibility List which was renamed the "Windows Catalog" is no more. When creating a Clustered Solution, you need to have a system that is Certified for clustering or there will be no official support. This has been a point of pain Read More... Posted Thursday, December 20, 2007 12:25 AM from Rick Heiges | (Comments Off) Filed under: SQL Community, SQL 2008, Katmai, high availability, New Features

• Compression in DB Mirroring

  When you start to look at SQL Server 2008, there is a sub-theme of using compression to help drive performance and usefulness. When I hear the word compression, my first thought is "No - I remember Stacker". How many years ago was that obscure reference? Read More... Posted Tuesday, November 20, 2007 9:19 PM from Rick Heiges | (Comments Off) Filed under: SQL 2008, Katmai, high availability, New Features

• Who's got your DB's back?

  While I was reviewing one of the sessions from the PASS Community Summit using the streaming media on some new things in SQL Server 2008, I stumbled across a new reason to mirror. The primary reason to mirror of course is availability and to give DBAs Read More... Posted Saturday, November 10, 2007 1:05 AM from Rick Heiges | (Comments Off) Filed under: Conferences, SQL 2008, high availability