by Brad M. McGehee – This fifth part of the SQL Server Performance Audit series covers SQL Server database options and configuration settings.
Other News
Battening down the Windows: Don’t forget the database!
By Margie Semilof – Malicious crackers love to crash corporate networks via Web servers, but Windows administrators should spend more time locking down the place where they keep the company crown jewels — the database servers.From an installation and configuration standpoint, Microsoft SQL
Oracle to boost app server
By Paul Krill – ORACLE IN EARLY 2003 plans to release a new version of the Oracle application sever that will feature enhancements such as a certificate authority to boost the use of the product for e-business transactions. Oracle also may have something up its sleeve similar to Hewlett-Packard’s bu
SQL Yukon a major security concern
By Jo Ticehurst – Users should hold off deploying Microsoft’s next version of SQL Server until the first service pack because of major security concerns, analysts have warned. Yukon, the company’s next SQL release, is due next year, but analyst Gartner has said that it expects it to contain a
Dynamic Method Dispatch
by Zlatko Sirotic – Oracle9i Database has support for inheritance, method overriding, and “dynamic method dispatch.” When you have inheritance and overriding, the process of selecting a method implementation is called dynamic method dispatch because it is done at run time, not at compile time. A met
Oracle, SQL Server test needs judge’s decision
Oracle says they have evidence that proves beyond a reasonable doubt that their 9i R2 Enterprise Edition with Red Hat Linux Advanced Server can beat Microsoft’s SQL Server 2000′ when it comes to price and performance. It’s not clear, though, whether Microsoft had a fair trial, says this author. As i
Microsoft readies SQL Server 2000 SP3
By Barbara Darrow – Microsoft is putting the final touches on Service Pack 3 for SQL Server 2000 and hopes to ship it next month, the company confirmed Monday.This, the first service pack in nearly a year, will roll together fixes in the first two service packs and focus on security and “ser
DataDirect tool converts XML to SQL
By Peter Williams – DataDirect Technologies has launched software designed to cut time and complexity in transforming data between relational databases and XML for Java applications.jXTransformer is written entirely in Java and is aimed at web application architects and developers who conver
IBM, MS reject MySQL
By Paul Krill – AS INTEREST IN open-source databases builds, data management veterans IBM and Microsoft argue that alternative open-source databases such as MySQL lack the strength and functionality for enterprise deployment.
Grid Computing: Electrifying Web Services
By Dirk Hamstra – Grid computing makes it possible to dynamically share and coordinate dispersed, heterogeneous computing resources. Flexibility and ubiquity are essential characteristics of Web services technologies such as WSDL, SOAP, and UDDI. The Open Grid Services Architecture (OGSA) combines t