Torsten Schuessler

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

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

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

Link: http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!6984.entry

:-)

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:

http://support.microsoft.com/kb/981356/

CU
tosc

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: http://support.microsoft.com/kb/960598/

CU
tosc

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-a-sql-server-2008-technical-case-study.aspx

CU
tosc

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
tosc

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 files. The old version returned an error if there was no files to delete. This has been changed not to return an error.
• Bug fix: Collation conflict when creating the objects in a database with a collation other than the collation in tempdb.
• Changed default for backup compression. In the new version the backup compression default in sys.configurations is used in SQL Server 2008 Enterprise Edition and in SQL Server 2008 R2 Standard, Enterprise and Datacenter Edition. In SQL Server versions and editions where backup compression is not supported the default is 'N'.
• New job for purging job history. It's using the stored procedure sp_purge_jobhistory
• New job for purging backup history. It's using the stored procedure sp_delete_backuphistory
• New job for deleting output files
• If you have an index with page locking disabled and you rebuild it online using multiple CPUs, the fragmentation will in some cases not go away. This is a bug in SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2. I have made a workaround in IndexOptimize setting MAXDOP = 1, when you rebuild an index online that has page locking disabled
• Now backup compression is supported also in Standard Edition

CU
tosc

Link: http://www.glorf.it/blog/2010/05/31/sql-talk/sql-pass-wunschliste-fuer-franken

CU
tosc