DBSave SQL Server Backup

DBSave von DD-MEDSOFT ist eine auf dem NET Framework basierende BACKUP-Lösung zur Sicherung und Wiederherstellung von bis zu 4 Microsoft SQL Server Instanzen. Es werden alle  MS SQL Server  Versionen unterstützt - einschließlich MSDE- u. Expresseditionen.  Die Installation ist zu folgenden Betriebssystemen kompatibel:   Windows XP, VISTA, Windows 7, Windows Server 2003, Windows Server 2008.

Mehr lesen »

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:

http://support.microsoft.com/kb/2258854

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/

CU
tosc

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:

• SSMA for Oracle v4.2
• SSMA for Sybase v4.2
• SSMA for Access v4.2

CU
tosc

Link: http://blogs.technet.com/b/dataplatforminsider/archive/2010/08/05/microsoft-drivers-for-php-for-sql-server-2-0-released.aspx

The Cumulative update package 9 for SQL Server 2008 Service Pack 1 (Build 10.00.2789.00) is available:

http://support.microsoft.com/kb/2083921/

And here you can get the whole information of builds that were released after SQL Server 2008 Service Pack 1 was released:

http://support.microsoft.com/kb/970365/en-us

CU
tosc

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!!!).

Database Upgrade to SQL Server 2008 Tools and Approaches
(http://sqlcat.com/whitepapers/archive/2010/07/22/database-upgrade-to-sql-server-2008-tools-and-approaches.aspx)

Resources for Upgrading to SQL Server 2008 (http://technet.microsoft.com/en-us/library/cc936623.aspx

I wish you a nice day,
tosc

The SQL Azure team have just announced the CTP1 of  Project Code-Named <<Houston>>!

<<Houston>> is a lightweight and easy to use database management tool for SQL Azure databases -  a web based admin tool.

CU
tosc

There is a new monthly SQL Server reading material for free at http://www.solidq.com/sqj
So take a look and have a nice day,

CU
tosc

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:

• Enterprise
• Standard
• Evaluation
• Developer
• Workgroup

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

CU
tosc