One of the new features available in SQL Server 2008 is compressed backup which takes backup of a database with mimimum possible size. The syntax is backup database db_name to disk = 'backup_path' with init , compression But this works only in Enterprise Edition of the SQL Server 2008 and not...

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Edition and SQL Server 2008 Enterprise Edition Notification Contents: New and Major Modifications SQL Server 2005 and SQL Server 2008 reports 701 errors with large batch sizes http://support...

It is over 1 year and first anniversary for SQL Server 2008 RTM, last year the RTM is released on August 06th 2008 re. http://sqlserver-qa.net/blogs/sql2008/archive/2008/08/06/4727.aspx post. HAPPY first anniversary.... and kudos to SQL Server Development team!!!...( read more )

I have received a good feedback about number of blogs posted about SQL Server Feature Pack, in this regard recent post about Do you know how many tools are included in SQL Server 2008 Feature Pack? here is another update for you to test & deploy the SQL Server 2008 Feature Pack, April 2009 release...

A new whitepaper covering the topic of performance troubleshooting in SQL Server 2008 has now been released. You can download the paper from the following link: http://msdn.microsoft.com/en-us/library/dd672789.aspx...( read more )

During a recent visit to Seattle for a Microsoft TechReady conference, I learned from a colleague that it's possible to run the SQL Server 2005 Performance Dashboard reports on SQL Server 2008, with a couple of slight modifications. There is a great new feature in SQL Server 2008 called Performance...

On January 19, 2009 Microsoft shipped the Third Cumulative Update for SQL Server 2008 RTM. This CU represents 36 Resolved Issues and 30 Unique Customer Requests. More details and download details can be found here: http://support.microsoft.com/kb/960484/en-us...( read more )

The SQL Server 2008 Technical Reference Guide has just been released, covering the essential steps and best practices to upgrade existing 2000 and 2005 instances to 2008. There is also a list of other upgrade resources available at http://msdn.microsoft.com/en-us/library/cc936623.aspx These guides are...