Torsten Schuessler

Frequently you'll want to know how fast your database-backup has been growing. Perhaps you have implement a SAN Backup-Device for Backup-to-disk, or you only want know how fast your database has been growing.This TSQL statement will query the… more »

There is an interesting post by Buck Woody: http://blogs.msdn.com/buckwoody/archive/2008/05/06/why-you-should-upgrade-to-sql-server-2008.aspx CU tosc more »

There is a new great WIKI ressource for common T-SQL solutions at MSDN Code Gallery, it's called SQLExampels.In this WIKI presented information, represents the suggestions, ideas, and opinions of Volunteer Moderators and Answerers (you know Arnie Roland… more »

There is an interesting technical note by using the backup compression and its benefits in SQL-Server 2008 at SQLCAT. Follow up: http://sqlcat.com/technicalnotes/archive/2008/04/21/tuning-the-performance-of-backup-compression-in-sql-server-2008.aspx CU… more »

UPDATE READ THIS: Microsoft SQL Server 2005 Service Pack 3 + Cumulative Updates Microsoft SQL Server 2005 Service Pack 3 Beta now available Last week, Francois Ajenstat announced on The Data Platform Insider that Microsoft will deliver SQL-Server 2005… more »

The SQL User Edutcation Team have created a new scoped Search macro on Windows Live search.It helps you to narrow your search to just the SQL Server 2008 Books Online documentation(BOL) and eliminate extranneous results from other sources, like the SQL… more »

By using SP_MSForEachDB you can detect and display orphan SQL-Server accounts from all the databases of your SQL-Server. EXEC SP_MSForEachDB 'USE [?]; -- SYSTEM DATABASE ARE EXCLUDED IF DB_ID(''?'') > 4 SELECT ''?'' as DBName, name AS… more »

Buck Woody has completed his full list of SQL Server Management Studio Standard Reports. You can get to them from the tag Standard Reports , but he has also posted a list of them all with the links.Follow up this link:… more »

There is a new blog maintained by the entire team of SQLPMB. This blog is dedicated to Policy-Based Management introduced in SQL Server 2008. http://blogs.msdn.com/sqlpbm/default.aspx CU tosc more »

Let us face it, when did you last change the sa password? You can check last change in SQL Server 2005, for the sa login by using LOGINPROPERTY function. Execute the following T-SQL code: more »