Category: SQL-Server 2008
Backup, Integrity Check and Index Optimization
Aug 18th
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
Aug 13th
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
Jul 27th
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
Jul 26th
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
Jul 8th
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 »
Analysis and Reporting Services, Design and Implementation
Jun 22nd
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
Jun 18th
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
Jun 10th
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
May 19th
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 »
