(Ken Henderson) SQL Server 2000 clients connect to SQL Server using a stack of APIs, object libraries, and protocols. Ken Henderson walks through each one and explains how they work and interoperate.
Other News
Application Monitoring Saves The Day
(Charles Babcock) Software developers at Northern Trust Corp. earlier this year made a change in one of the bank’s IBM DB2 database systems that resulted in an error that, if left unattended, could have interrupted the bank’s ability to produce a handful of timely reports.
Shrinking SQL Server Transaction Logs with SQL-DMO
(Armen Hakobyan) Workers of the one of our division departments installed an application that used MSDE as a database server. That application was constantly hanging up with no visible reason until we finally found out that the cause of such strange behavior was the too quickly growing transaction l
Tuning ORACLE to Minimize Recovery Time: For Solaris Operating System on SPARC
This article provides recommendations for tuning ORACLE on SPARC processor-based systems running the Solaris Operating System to minimize recovery in the event of a system or database failure. This article is relevant for any audience level.
What’s Brewing in XML: XML Messaging Protocols
(Bhavish Sood) Largely used until now for representing data, XML is now being adopted for data interchange. XML messaging technologies such as SOAP, UDDI, and WSDL will facilitate inter-enterprise cooperation on the Internet. This article is a brief look at what’s brewing in the XML messaging space.
Protect your sites from potential Dreamweaver vulnerabilities
(John McCormick) If you develop applications and e-commerce Web sites with any version of Dreamweaver MX, MX 2004, or UltraDev 4, they may contain serious to critical vulnerabilities that can allow an attacker to access the back-end database server without discovering a valid user ID and password.
Effect of hardware compression on NULLs
(Craig Mullins) What effect, if any, would hardware compression have on the storage of NULLs in a DB2 databse? Would it save any space? (R)
Self-Managing PL/SQL
(Steven Feuerstein) Oracle has introduced significant management automation features in its flagship database product and has described the new Oracle Database 10g release as “the self-managing database.” Given that achievement and direction, I thought it would make sense to talk about how to write
Protocol Design: Structure and Syntax
(Itamar Shtull-Trauring) Protocols use syntax, the way the data they send is formatted and organized, to send and receive structured information. A POP3 server knows that the bytes in the message RETR 1 followed by a CRLF should be parsed by splitting, based on the space character. The first par
Attach and Detach..Again
(Andy Warren) Attaching and detaching databases has got to be one of the handiest features in SQL7/2K. It worked well enough in SQL7, but SQL2K added a nice interface in Enterprise Manager to let you browse the file structure and pick the files you needed – a great time saver compared to typing in t