Archives for: "April 2008"

SQLExamples: Common Solutions for T-SQL Problems

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 »

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: 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. 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 »