Category: "SQL Server"

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 »

SQL Trace Flags - 3502 - Timing of checkpoints

Upgrade for SQL Server 2008 can fail if you have renamed the 'sa' account

Best Practices for Semantic Data Modeling for Performance and Scalability

Virtual Lab: What's New in SQL Server 2008 for Database Administrators

Free on-line lab to started quickly:http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032358030&EventCategory=3&culture=en-US&CountryCode=US CU tosc more »

Webcast: Upgrade and Migration to SQL Server 2008

Learn to install and upgrade to SQL Server 2008, check out this free webcast:http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032384669&EventCategory=3&culture=en-US&CountryCode=US CU tosc more »