by Scott Bekker – In response to the publication of the SQL Slammer source code in a major industry magazine, Microsoft officials are warning users to make sure they’ve taken advantage of the rash of SQL Slammer defenses on the Microsoft Web site.
Other News
Reading XML with the XmlReader
The XmlReader class is an abstract base class that provides non-cached, forward-only, read-only access. The XmlReader class checks that the XML is well-formed, and throws XmlExceptions if an error is encountered. It can read a stream or a document, and it implements the namespace requirements outlin
Upgrading SQL Server, part II: Critical upgrade decisions
By Jeremy Kadlec – This article will begin to detail the technical components faced by DBAs and developers during the upgrade process. The technical components detail critical upgrade decisions related to ANSI NULLS, quoted identifiers and other items. In addition, a valuable redundant upgrade archi
Analyst: XML-enabled Office a plus but not a cure-all
By Eric B. Parizo – Many would argue that Microsoft Corp. hasn’t had nearly as much success in the enterprise software market as it has selling consumer products. However, the Redmond, Wash.-based software giant no doubt hopes its XML-enabled Office 2003 software suite will change that when it is re
Using Stored Procedures in Conjunction with the SqlDataAdapter
by Dan Clark – A well-designed application that uses a relational database management system in the backend should make extensive use of stored procedures. A stored procedure is a named collection of SQL statements that you store in a database. A stored procedure is similar to a function. You call t
Install Those Service Packs!
By Michael Otey – You might not need the new functionality a service pack provides, but prompt installation of service packs could be the very thing that beats virus writers to the punch.
Making Use of the XML Data Source Object
by Premshree Pillai – The XML Data Source Object is an ActiveX control that allows you to manipulate data between XML files and HTML pages. This article will show you the basics of how to extract content from various XML data sources and how to present that data using a little JavaScript.
Ascential Software and IBM DB2 Cube Views Maximize the Performance of Business Intelligence Solutions
Ascential Software Corporation (Nasdaq: ASCL), the enterprise data integration leader, announced full support for IBM’s new DB2 Cube Views software. The Ascential(TM) Enterprise Integration Suite combines with Cube Views to accelerate the development and lower the total cost of ownership for online
Just the Stats, Ma’am
By Robert Catterall – Statistics reports can reveal surprising facts about the subsystem you thought you knew well.
Denormalization of DB2 tables
by Craig Mullins – Speeding the retrieval of data from DB2 tables is a frequent requirement for DBAs and performance analysts. One way to accomplish this is to denormalize DB2 tables. The opposite of normalization, denormalization is the process of putting one fact in many places. This speeds data r