DBSave SQL Server Backup von DD-MEDSOFT

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.

Full story »

Backup, Integrity Check and Index Optimization

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'

Full story »

#CU 11 for SQL Server 2005 Service Pack 3

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

Migrate from MySQL to SQL Azure or SQL Server

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:

CU
tosc

Microsoft Driver for PHP for SQL Server 2.0

#CU 9 for SQL Server 2008 Service Pack 1

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

Database Upgrade to SQL Server 2008

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

SQL Azure - Project "Houston"

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

SolidQ Journal

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

SQL Server 2008 SP2 CTP

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