Cumulative update package 2 for SQL Server 2005 Service Pack 3

The cumulative update package 2 for SQL Server 2005 Service Pack 3 (Build 9.00.4211) is now available:http://support.microsoft.com/kb/961930And here you can get the whole information of builds that were released after SQL Server 2005 Service Pack… more »

Microsoft SQL Server 2008 System Views Map

The Microsoft SQL Server 2008 System Views Map shows the key system views included in SQL Server 2008, and the relationships between them. The map is similar to the Microsoft SQL Server 2005 version and includes updates for the new and updated the… more »

Microsoft SQL Server 2005 Service Pack 3 + Cumulative Updates

Aaron Bertrand describes in his Blog some very interesting inaccessibilities which belongs to SP3 and CU#10 / CU#11 (CUs after SP2). Take a look at his post:… more »

German translation of Tibor Karaszi`s updated datetime article

Frank Kalis, has translate the The ultimate guide to the datetime datatypes article to German. An article of great value, original written by Tibor Karaszi.So check it out in: EN : The ultimate guide to the datetime datatypes GER: Der ultimative Guide… more »

Cumulative update package 10 for SQL Server 2005 Service Pack 2

Cumulative update package 10 for SQL Server 2005 Service Pack 2 (Build 9.00.3294) is now available: http://support.microsoft.com/kb/956854And here you can get the whole information of builds that were released after SQL Server 2005 Service Pack… more »

Microsoft SQL Server 2005 Service Pack 3 Beta now available

Now it`s time. Microsoft SQL Server 2005 Service Pack 3 Beta is now available for testing. But remember these packages have been made available for general testing purposes only. Do not deploy the Beta software in production. Download SQL 2005 SP3… more »

SQL Server Integration Services Best Practices

SQLCAT (new look and feel:-)) gives us a new best practice to Microsoft® SQL Server® Integration Services (SSIS): more »

Ultimate guide to the datetime datatypes

Tibor Karaszi has updated his Ultimate guide to the datetime datatypes for SQL Server 2008!Remember - SQL Server MVP Frank Kalis, has translated this article to German.http://www.karaszi.com/SQLServer/info_datetime.asp CU tosc more »

Cumulative Update package 1 for SQL Server 2008

The Cumulative Update package 1 for SQL Server 2008 (Build 10.00.1763.00) is now available: http://support.microsoft.com/kb/956717/en-us CU tosc more »

List all tables with specified field

DECLARE @COL_NAME NVARCHAR(50) SET @COL_NAME = '%SOMESTRING%' SELECT DB_NAME(DB_ID()) AS DatabaseName, B.name AS TableName, A.name AS ColumnName FROM sys.syscolumns AS A INNER JOIN sys.sysobjects AS B ON… more »