This sample app demonstrates how to use SQLXML 3.0 and Visual Basic .NET to create a Web-based tool for managing projects and tasks, thus improving team productivity.

With this download, Josh Sullivan – the winner of our VBeXpress competition – demonstrates how his easy-to-use class makes it a breeze to work with the XML features of SQL Server 2000.

Book By Ales Spetic, Jonathan Gennick – The recipes in this chapter show you how to effectively use SQL for common statistical operations. While SQL was never designed to be a statistics package, the language is quite versatile and holds a lot of hidden potential when it comes to calculating the fol

By Henry Lau – How to take advantage of features in SQL Server 2000 and Excel 2002 in order to distribute enterprise data to Excel 2002 via XML.

By Don Kiely – How to use OLAP features in Microsoft SQL Server Analysis Services from Microsoft Excel 2002.

By Brian McWilliams – Officials at the SANS Institute, a computer security education and analysis organization, also reported today that they have received “exploit code” that indicates the increase in port 1433 scans may be due to a self-propagating worm rather than to manual probes by would-be att

By Brian Moran – Microsoft is preparing a new best-practices guide that specifically addresses managing security vulnerabilities in a SQL Server environment.

By Guy van den berg – New to SQL Server 7.0 the Index Tuning Wizard is one of the many novel self-administrative features included in this release. Within this series of articles I’ll take a look at the wizard, how best to use it and how to interpret its’ output.

by Alexander Chigrik – You can never know too much about SQL Server trace flags. In this article, find out about those that are undocumented in SQL Server 2000.

By Brian Moran – Find out about the latest SQL Server security patch, which you can download from Microsoft’s Web site, and learn how to sign up for Microsoft’s security bulletin service.