Category: "SQL Server"
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 Azure - Project "Houston"
Jul 22nd
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
Jul 20th
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
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… more »
#CU package 2 for SQL Server 2008 R2
Jun 24th
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
Jun 24th
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
Jun 22nd
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
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:
Changed behaviour in the job that deletes old output… more »