By Itzik Ben-Gan – Can a cursor really out-perform a set-based solution? Put your skills to the test in calculating maximum concurrent sessions.

In this article, Alexander Chigrik shows you how you can copy a single text or image value into or out of SQL Server by using the textcopy.exe utility.

By Dennis Fisher – Security vendors are introducing capabilities that up the ante for traditional anti-virus applications to help catch more viruses and rein in emerging threats, including memory- resident worms such as SQL Slammer and Code Red.

By Robert Lemos – A viral one-two punch–the Code Red and Nimda worms–convinced Microsoft in mid-2001 that security needed to become its top priority. That decision led directly to the creation of the company’s Trustworthy Computing initiative. Mike Nash, vice president of the security busin

by Roger Jennings – If you use SQL Server or BizTalk and plan to use .NET, you’ll definitely want to look into the SQL Server 2000 Web Services and BizTalk Server 2002 Toolkits.

(Randy Dyess) This is a short article containing descriptions of 65 documented and undocumented trace flags currently available in SQL Server 7.0 and 2000.

See how Microsoft SQL Server Notification Services sends personalized, timely messages to a wide variety of devices.

By Lisa Vaas – Microsoft Corp. has put out hot fixes for two known bugs in its SQL Server database software. The first bug is explained in a Microsoft online article entitled “FIX: Cannot Remove Microsoft SQL Server 2000 Desktop Engine After You Upgrade to MSDE 2000 SP2”. According to the art

Part 3 of this Web Seminar series describes how SQL Server accesses and possibly makes changes to its data structures when processing queries. Kalen Delaney uses the undocumented commands introduced in Part 2 of this Web Seminar series to examine how pages have changed after updates or deletes are p

How can I pass a large XML document to a stored procedure?