Category: "SQL Server"

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

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

How To Stay Current with SQL Server Cumulative Updates

#CU package 2 for SQL Server 2008 R2

The Cumulative update package 2 for SQL Server 2008 R2 (Build 10.50.1720.0) is available: http://support.microsoft.com/kb/2072493/ And here you can get the whole information of builds that were released after SQL Server 2008 R2 was released:… more »

#CU package 10 for SQL Server 2005 SP3

The Cumulative update package 10 for SQL Server 2005 SP3  (Build 9.00.4305 ) is available: http://support.microsoft.com/kb/983329/ The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 3 was released:… more »

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… 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: Changed behaviour in the job that deletes old output… more »