(James F. Koopmann) Is a 24X7 database system a myth? Let me just say for the record, YES it is. At the root of the question is the definition availability which has the notion of being ready for use, at hand, and accessible. With 24X7 that means 100% availability and completely accessible. I offe
Other News
Error message when you use XML functionalities against an instance of SQL Server 2000 after you upgrade an instance of SQL Server 2000 to SQL Server 2005: ‘Failed to load msxmlsql.dll’
Consider the following scenario. A computer is running multiple instances of Microsoft SQL Server 2000. You update one of the instances to Microsoft SQL Server 2005. You use XML functionalities against one of the instances of SQL Server 2000. In this scenario, you receive an error message that resem
New capabilities for migrating to DB2 and Informix in IBM Migration Toolkit 1.4.9
(Hemant Bhatia and Nicholas Geib) January is a time of celebrating change, and there has been much change in the IBM Migration Toolkit (MTK) that deserves celebration, too! The latest release of IBM’s free migration toolkit, MTK 1.4.9, includes many new features that make migrating to your favorite
Working XML: Understand the various approaches to XML parsing
(Benoit Marchal) Even developers who are very knowledgeable on advanced XML matters can lack a firm understanding of the fundamentals. To ensure a solid foundation, this article covers the most basic XML service: parsing. It introduces the various approaches to parsing and highlights their pros and
Multiple BindingNavigators on Same Windows Form VB 2005
(Mike McIntyre) Visual Studio 2005 sometimes automatically adds a BindingNavigator for a BindingSource to a Windows form.
MySQL Optimization Hints
(Pete Freitag) Every programmer loves to optimize, even when we know we shouldn’t. To satisfy your cravings MySQL has several keywords that can be placed in your SQL statement to give the database server an explicit optimization instruction.
Data-Oriented Application Engineering: An Idea Whose Time had Returned
(Bill Lewis) Surveys of software development organizations relentlessly deliver the message that an acceptable project success rate still eludes us. Model-driven methods such as the Object Management Group’s Model Driven Architecture (MDA) promise improvements in this state of affairs, but have yet
Data cleansing techniques in SQL Server
(Jeremy Kadlec) When it comes to decision making, the value of data is in its accuracy. If the data is inaccurate, decision makers can make flawed assumptions, which could have disastrous consequences. In this tip, I will outline techniques to ensure data accuracy, including: –Collection validat
Introduction to Microsoft SQL Server 2005
(Mike Chapple) After a long gap in the release of SQL Server databases, Microsoft recently released SQL Server 2005 (formerly code-named Yukon). In this substantial upgrade, they’ve packed the new database engine full of features. Probably the most significant one that will catch your attention is t
Calling APIs, The .Net Way!
(Thiagarajan Alagarsamy) The Windows API is the name given by Microsoft to the core set of application programming interfaces available in the Microsoft Windows operating systems. It is designed for usage by C/C++ programs and is the most direct way to interact with a Windows system for software app