Ola Hallengren and his ongoing work of his SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization scripts - makes me happy :-)
He made some important updates to his maintenance scripts:
- Support for selection of schemas, objects and indexes. You can select individual or lists of schemas, objects or indexes, use exclusions or use wild-cards. See the documentation for details about how it can be used.
It works like this:
All indexes on the Production.Product table in the AdventureWorks database.
@Indexes = 'AdventureWorks.Production.Product'
The Cumulative update package 11 for SQL Server 2005 Service Pack 3 (Build 9.00.4309) is available at:
And here you can get the whole information of builds that were released after SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 3 was released: http://support.microsoft.com/kb/960598/
Microsoft announced the release of the first version of SQL Server Migration Assistant (SSMA) for MySQL!
Download: Microsoft SQL Server Migration Assistant for MySQL v1.0
I hope you know the other SSMA for Oracle/Sybase/Access ?!
So take a look here:
The Cumulative update package 9 for SQL Server 2008 Service Pack 1 (Build 10.00.2789.00) is available:
And here you can get the whole information of builds that were released after SQL Server 2008 Service Pack 1 was released:
Whitepaper at SQLCAT by Dmitry Artemov: Database Upgrade to SQL Server 2008, Tools and Approaches
This paper documents approaches and tools that can help to upgrade of SQL Server databases from SQL Server 2000 or SQL Server 2005 to SQL Server 2008 (or SQL Server 2008 R2!!!).
Resources for Upgrading to SQL Server 2008 (http://technet.microsoft.com/en-us/library/cc936623.aspx
I wish you a nice day,
At SQL Server Team Blog: SQL Server 2008 SP2 CTP is now available for public testing
The CTP version of SQL Server 2008 Service Pack 2 (SP2) contains the cumulative updates up to SQL Server 2008 SP1 cumulative update package 8. Upgrade only for the following SQL Server 2008 editions:
Download: Download SQL Server 2008 SP2 CTP
And for Express Edition or Express Edition with Advanced Services: SQL Server 2008 Express Edition Service Pack 2 – CTP