Category: SQL-Server 2008

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 an… more »

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:… more »

#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 Pac… more »

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… more »

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 fo… more »

How To Stay Current with SQL Server Cumulative Updates

Analysis and Reporting Services, Design and Implementation

Interesting whitepaper at SQLCAT - Develop Reporting Services reports using Analysis Services data; a SQL Server 2008 technical case study http://sqlcat.com/whitepapers/archive/2010/06/22/develop-reporting-services-reports-using-analysis-services-data-… more »

Technical Note: SQL Azure Database Client

Interesting technical note at SQLCAT - Best Practices for Building Reliable SQL Azure Database Client Applications http://sqlcat.com/technicalnotes/archive/2010/06/17/best-practices-for-building-reliable-sql-azure-database-client-applications.aspx CU… more »

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 updates to the maintenance scripts:New job for purging job history. It's using the stored… more »

#CU 8 for SQL Server 2008 Service Pack 1

The Cumulative update package 8 for SQL Server 2008 Service Pack 1 (Build 10.00.2775) is available: http://support.microsoft.com/kb/981702/ And here you can get the whole information of builds that were released after SQL Server 2008 Service Pack 1… more »
1 2 3 4 5 6 7 »