Category: "SQL Server"

Cumulative update package 9 for SQL Server 2005 Service Pack 2

The Cumulative Update package 9 for SQL Server 2005 Service Pack 2 (Build 09.00.3257.00) is now available: http://support.microsoft.com/kb/953752/en-usAnd here you can get the whole information of builds that were released after SQL Server 2005 Service… more »

Scaling Out SQL Server 2005

Kevin Cox from the Microsoft SQL Server Development Customer Advisory Team point it out, the SQL Server scale well. CU tosc more »

Paul S. Randal - Surviving Corruption: From Detection to Recovery

TechEd Demo: Using the SQL 2005 Dedicated Admin Connection to fix Msg 8992: corrupt system tables by Paul S. Randal. http://www.sqlskills.com/blogs/paul/2008/06/12/TechEdDemoUsingTheSQL2005DedicatedAdminConnectionToFixMsg8992CorruptSystemTables.aspx CU… more »

SQL Server 2008 Release Candidate 0 (RC0) now available

First, the Microsoft branding team unveiled an official new logo for SQL Server 2008.   more »

Building and Deploying Large Scale SQL Server Reporting Services

At SQLCAT there is a new technical note that introduce the Building and Deploying Large Scale SQL Server Reporting Services Environments, which provides general guidance on how to set up, implement, more »

SQL Server Automation Scripts

The Microsoft SQL Server Community introduces a new OPSDB Section (SQL Server Automation Scripts), with T-SQL Scripts for administration and analysing the entire SQL Server.You can visit OpsDB Section here. CU tosc more »

How Microsoft IT Leverages SQL Server 2008 SSIS Dataflow Engine Enhancements

http://sqlcat.com/presentations/archive/2008/06/04/how-microsoft-it-leverages-sql-server-2008-ssis-dataflow-engine-enhancements.aspx CU tosc more »

PHP Driver for SQL Server 2005

There is a new SQL Server 2005 Driver for PHP Community Technology Preview, a PHP 5 extension that allows for the reading and writing of SQL Server data from within PHP scripts.For more Information please read SQL Server 2005 Driver for PHP… more »

Sync All Logins on a Server in a single click using SP_MSForEachDB

Ken Simmons, has published an interesting article about login sync, on SQL Server Central. Follow up: Sync All Logins on a Server in a single click using SP_MSForEachDB CU tosc more »

SQL Server 2005/2008 Performance Troubleshooting

SQLCAT, has published a flowchart explaining how to troubleshoot most common performance and scalability issues with SQL Server. Follow up: SQL Customer Advisory Team’s Troubleshooting SQL Server 2005/2008 Performance and Scalability Flowchart CU tosc more »