Tuning the Performance of Backup Compression in SQL Server 2008
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 »
Microsoft SQL Server 2005 Service Pack 3!
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 »
Great New Resource for SQL Server 2008 Books Online Information
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 »
Orphan SQL-Server accounts
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 »
SQL Server Management Studio Standard Reports
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 »
SQL Server Policy-Based Management - PMB
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 »
Determine the last change of the sa password?
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 »
Which service pack do I have installed?
Related to previous post's, sometimes it is helpful to quickly determine SQL Server's service pack level.By selecting @@VERSION in a query window ...SELECT @@VERSION AS "SQL Server Version"you / I get following result: more »
SQL Internals Viewer - looking into the SQL Server storage engine
Danny Gould, created a tool to graphically display database storage internals, and seeing how data is physically allocated, organised and stored - the SQL Internals Viewer. more »
Cumulative Update package 7 for SQL Server 2005 SP2
The Cumulative Update package 7 for SQL Server 2005 Service Pack 2 (build 9.00.3239) is now available:
http://support.microsoft.com/default.aspx/kb/949095/
This CU represents:
40 Resolved Issues 37 Unique Customer Requests
CU
tosc more »
