By Lisa Vaas – Microsoft Corp. has consolidated the database security tools that shield SQL Server 2000 and MSDE 2000 installations from the Slammer worm. SQL Server 2000 SQL Scan, SQL Check and SQL Critical Update are now available in a single download, the SQL Critical Update Kit, which can be dow
Author: SSWUG Research
How can I pass a large XML document to a stored procedure?
How can I pass a large XML document to a stored procedure?
SQL Server 2000 Data Storage, Part 3: Working with SQL Server Data Structures
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
XML for Data: Reuse it or lose it
One of the great features of XML is that you can easily reuse your designs all the way down to the component level. In this first installment of a three-part series, columnist Kevin Williams provides an overview of XML reuse in enterprise-level solutions, with examples in both XML and XML Schema.
Understanding XML Trust
Today, eXtensible Markup Language (XML) has become the standard for communication between applications over the Internet. In particular, it serves as the protocol for accessing Web Services via SOAP. However, as messages are transported over the Internet, security problems can be considerable.
Westbridge exec: When XML is a factor, standard firewalls don’t cut it
By Eric B. Parizo – Experts expect Web services security to be a key focus in 2003, and there are a number of companies eager to take advantage of the growing market niche. One of those firms is Westbridge Technology Inc., a Mountain View, Calif.-based startup. SearchWebServices.com recently spoke w
Killing Sessions on NT Using Thread Number
by Loay AbuZaineh – Sometimes after killing a session on NT, the status of the session will be changed to KILLED and it will keep this status for a very long time before it dies.A faster way to remove it is killing the session thread from NT itself after using the “alter system …” command.
SQL Server Gets BizTalk Adapter
By Lisa Vaas – Microsoft Corp. has made available for download Microsoft BizTalk Adapter for SQL Server, which allows users to read and write to any SQL Server database installation from BizTalk Server 2002.
HTTP Communication from Within the Oracle Database
Steven Feuerstein and Bryn Llewellyn continue their series on new Oracle 9i features with an article on how to use Utl_Http to implement a requestor in a B2B implementation.
Newly leaked Longhorn version gets lukewarm reviews
By Joris Evers – Although a spokesman for Microsoft confirmed the authenticity of the operating system build, the company stressed that the final product will look much different when it is released.