International Features in Microsoft SQL Server 2005

This white paper introduces Microsoft SQL Server developers to the international features of Microsoft SQL Server 2005. Topics covered include an explanation of Unicode, added support for supplementary characters in SQL Server 2005, the changes in collation in different versions of SQL Server, changes in data types, performance, updates on data providers, and new international support features in SQL Server 2005 Analysis Services and Integration Services.

Drop FK For A Specific Table

Drop FK For A Sprecific Table

Identify SQL Server 2005 Standard Login Settings

Gaining insight into my SQL Server standard and Windows logins has historically been a challenge in terms of determining password changes, failed login attempts, etc. I have noticed that you have experienced the same issue with your tip entitled 'When was the last time the SQL Server sa password changed' and I have noticed some information in the forums on the topic as well.

myLittleAdmin for MS SQL Server 2005

A short review from the perspective of a web hoster on this handy software utility.

How to Implement an Automatic Sliding Window in a Partitioned Table on SQL Server 2005

This article shows how to implement an automatic sliding window in a partitioned table on Microsoft SQL Server 2005.

Upgrading SQL Server 2005

Top Queries in SQL Server 2005

This article illustrates how to query dynamic management views to find the TOP queries based on average CPU and average I/O.

Row Level Versioning

Row Level Version is one of the most coolest features introduced by SQL 2005.

Automating SQL Server Profiler

This article details the steps to automate the generation of Sql profiler traces in a Testing environment. The facility is useful when an application is User Acceptance Testing phase where a bunch of test users logon to the Testing site and use the application.

SQL Server 2005, Windows Vista and Office 2007 Compatibility