By Vyas Kondreddi – It is always better to be proactive than reactive, when it comes to identifying and eliminating SQL Server performance issues. This article shows you how to analyze the data gathered by Profiler, to identify the performance issues. This article also provides four generic stored p

The Microsoft® SQL Server™ 2000 Web Services Toolkit delivers tools, code, samples and whitepapers for building XML Web services and Web applications with SQL Server 2000. This toolkit enables developers to easily create XML Web services via SQLXML 3.0.

Marcin Policht’s first article in the ‘SQL Server Management with WMI’ series discusses the use of Windows Management Instrumentation (WMI) in managing SQL Server and includes sample scripts to start and stop SQL Server.

(Randy Dyess) Article which briefly discusses using the OSQL command line utility to manage multiple servers and databases.

The path to the next generation of SQL Server in April includes beta testing a 64-bit version and a third service pack.

By Itzik Ben-Gan – It’s a kind of magic: Create four set-based solutions to a common SQL problem.

By Paul Krill – MICROSOFT, with its upcoming “Yukon” and 64-bit “Liberty” variants of its SQL Server database, is looking to oust Unix as the platform of choice for the enterprise, a Microsoft official stressed during a keynote speech Wednesday at the Professional Association for SQL Server Summit c

By Joe Wilcox – Microsoft has for the third time delayed the launch of its Windows .Net Server 2003 high-end operating system. During his Comdex keynote address on Sunday, Microsoft Chairman Bill Gates revealed that the company would launch Windows .Net Server 2003 in April, marking the third

Alexzander Nepomnjashiy continues his series focusing on SQL Server alerts and errors with a detailed look into using the Windows Performance Monitor to proactively track SQL Server performance.

You can configure a SQL Server mail profile so you can send and receive e-mail by running Transact-SQL code (for example, by using the xp_sendmail extended stored procedure to send e-mail). You can also configure a mail profile for SQL Server Agent so that e-mail will be sent to operators automatica