(Ian Gilfillan) In November, I looked at Oracle’s purchase of InnoDB, as well as their release of Oracle Express, and the effect on MySQL. In short, I concluded that the positives for Oracle were clear, but that MySQL must be feeling outmaneuvered. Since InnoDB, with its full transactional capabilit
Other News
Retrieving SQL Server 2005 Database Info using SMO: Scripting Tables, Views, Stored Procedures
(Jagadish Chaterjee) This article is the third in a series focusing on retrieving SQL Server 2005 information using SMO along with Visual Basic 2005 and Visual Studio 2005. In this article, we mainly deal with four topics: retrieving the column information of a selected table; scripting the selected
HIPAA compliance and disaster recovery
(Mike Talon) Disaster recovery (DR) planning often fails to take into consideration how various regulations and compliance issues will impact the firm after a disaster strikes. Though it doesn’t impact all businesses, those regulated by the Health Insurance Portability and Accountability Act of 1996
Tech tips: Database performance analysis
(Glenn Robinson) In a previous article, I showed how managing DB2 on the iSeries is made easy using iSeries Navigator (iNav). This functionality extends beyond just being able to work with the different types of objects in a library (or schema), but also to executing SQL statements via a GUI as well
Defining MySQL Cluster Data Nodes
The [NDBD] section is used to configure the behavior of the cluster’s data nodes. There are many parameters which control buffer sizes, pool sizes, timeouts, and so forth. The only mandatory parameters are: –Either ExecuteOnComputer or HostName. –The parameter NoOfReplicas
Implementing a Provider Independent Data Access Layer in .NET
(Manoj G) For applications built using Microsoft DNA, ADO provided one of the easiest ways of data access. ADO gave developers, COM based API for data access and using ADO components, a multitude of data sources could be accessed. The main reason for this was that ADO used the OLEDB provider interna
Comparison of 32-bit and 64-bit Oracle Database Performance on the Dell PowerEdge 6850 Server with Microsoft Windows Server 2003
(Larry Pedigo) In the spring of 2005, Dell introduced the PowerEdge 6850 server, an Enterprise-class server scalable to four processors. The Dell PowerEdge 6850 server is an update of the popular 6650 server, featuring significant new technological advances. One of the most significant new features
AJAX and Atlas: An Overview of Two AJAX Implementations
(Ben Reichelt) Since Ajax has taken off among Web developers, there have undoubtedly been many frameworks, APIs, and libraries to allow people to leverage Ajax with ease. I’d like to take a look at two of these Ajax packages for ASP.NET and show the differences and similarities of them. I will compa
Mastering Ajax, Part 3: Advanced requests and responses in Ajax
(Brett McLaughlin) In the last article in this series, I provided a solid introduction to the XMLHttpRequest object, the centerpiece of an Ajax application that handles requests to a server-side application or script, and also deals with return data from that server-side component. Every Ajax applic
SQL Server 2000 I/O Basics
(Bob Dorr) Because new devices and storage solutions continue to appear in the marketplace, the environments in which Microsoft SQL Server runs have become extremely diverse. To ensure data integrity for our customers who are running SQL Server, it is important that I/O environments provide appropri