EMS MS SQL Manager is a powerful graphical tool for Microsoft® SQL Server administration and development. It makes creating and editing MS SQL Server database objects easy and fast, and allows you to run SQL scripts, manage users and their privileges, build SQL queries visually, extract, print and s

By Itzik Ben-Gan – Two readers submit solutions to problems of how to track dates and times. Using auxiliary tables is the key.(R, $)

This three-day course will teach database professionals who are already proficient in the implementation and maintenance of enterprise databases about the core architecture of Microsoft SQL Server™ 2000 and how it works. The primary focus of this course is to give experienced database professionals

SQLXML enables XML support for your SQL Server Database. It allows developers to bridge the gap between XML and relational data. You can create XML View of your existing relational data and work with it as if it was an XML file.

By Don Schlichting – Share data between SQL and almost anything using Linked Servers. Think of a Linked Server as an alias on your local SQL server that points to an external data source. This external data source can be Access, Oracle, Excel or almost any other data system that can be access

By Vyas Kondreddi – Click here to check out the best testing books, covering all software platforms!

By Shawna McAlearney – A Los Angeles filmmaker’s lawsuit targeting Microsoft’s vulnerable software could signal a sea change for the software industry if judges and jurors decide that vendors should be legally responsible for damages caused by flaws in their products.

Microsoft’s Windows Server 2003 product family doesn’t support SQL Server 2000 Service Pack 2 (SP2) and earlier releases.

By Brian Moran – SQL Server needs a clear warning sign that lets you know that you need more than the Index Tuning Wizard to find the most efficient indexing strategy for your system, even though it’s helpful in simplifying the complex activity of selecting indexes.

SQL Server 2000 Service Pack 3a (SP3a) addresses specific issues discovered in SQL Server 2000 since its ship date.