This market bulletin provides answers to frequently asked questions about the Slammer worm. It includes detailed information about which systems are susceptible to the virus, provides links to the latest security patches, and suggests proactive steps that customers can take to safeguard their system

Troubleshooting performance issues involves using a series of steps to isolate and determine the cause of an application slowdown. Possible causes include blocking, system resource contention, application design problems, or a particular set of queries or stored procedures with long execution times.

By Darryl K. Taft – Web services will play a key role in Yukon, the next version of Microsoft Corp.’s SQL Server database, a company executive said. Giving a preview of the upcoming technology at the VSLive show here, David Campbell, product unit manager of the SQL Server Engine at Microsoft,

By Eli Leiba – Enabling full text search in T-SQL is not as popular as doing it with the Enterprise Manager. Nonetheless, it can be useful in certain situations. Here are the steps to implement FTS in T-SQL.

Brian Moran apologizes for oversimplifying the the problem of the SQL Slammer Worm and a DBA’s responsibility to their system’s security.

By Dennis Callaghan – Microsoft Corp. on Wednesday announced that it is adding reporting capabilities to its SQL Server business intelligence platform, a move that financial analysts predicted could threaten reporting software vendors.

Q. How can I configure SQL Server merge replication to work in only one direction?A. By default, with merge replication you pass data in both directions: changes at a publisher are sent to a subscriber, and changes at a subscriber are sent back to a publisher. In some cases, you might want t

Book by Ken Henderson – Teaches that stored procedure development does not occur in a vacuum–it involves a wide variety of skills, subjects, and technologies–and helps the reader become a better software engineer, not just a stored procedure expert. The most complete coverage of SQL Server stored

This article was written by Vaiyapuri Subramanian. He writes “In SQL Server 2000, XML can be parsed using the extended stored procedure sp_xml_preparedocument. This works fine as long as a well-formed xml is provided. Then do whatever needs to be done and you can call the extended procedure sp_xml_r

By Peter Galli – As Microsoft prepares for the April launch of Windows Server 2003, it is already hard at work on what it sees as the next big challenge: the virtual datacenter.