(David T. Anderson) Visual FoxPro 9.0 contains more functional enhancements to the data engine than any release since 3.0. From the new and extended functionality in SQL to new data types and a binary index, this release demonstrates the power of a mature development platform for data-centric soluti
Other News
SQL Server 2005 Part 1 Introduction
(Marcin Policht) SQL Server 2000 will be soon reaching its five-year mark, which in terms of software life-cycle translates into fairly advanced maturity. While this is still far from retirement age, the name of its successor, SQL Server 2005, suggests that it might be time for you to start looking
Develop a .NET Compact Framework app with DB2e Sync Client
The DB2 Everyplace Sync Client API allows you to develop applications to handle bi-directional synchronization of relational data between a DB2 Everyplace Server and your hand-held device. The Sync Client API supports a wide variety of platforms including Palm, Pocket PC, Windows, Linux, and more. I
Metadata and Reflection in .NET
(Scott) Metadata is the life blood of the .NET platform. Many of the features we use everyday during design time, during compile time, and during execution time, rely on the presence of metadata. Metadata allows an assembly, and the types inside an assembly, to be self-describing. In this article, w
Using the XML Features of the Access 2003 Object Model
(Frank Rice) Microsoft Office 2003 adds a number of significant features for working with XML data. This article explores the XML-related objects, methods, and properties for Microsoft Office Access 2003. Detailed information on these new members is provided as well as code samples illustrating thei
Issuing Queries and Retrieving Results
(Paul DuBois) Problem: You want your program to send a query to the MySQL server and retrieve the result. Solution: Some statements only return a status code, others return a result set (a set of rows). Most APIs provide different functions for each type of statement; if so, use the function t
Merits of DB2 for bank’s critical information system
(Craig Mullins) Our bank is one of the bigger in our country. We have an OS/390 platform, but we aren’t using any database with our critical information system. The IT management wants to change to Unix with Oracle. We, the IT Internal Audit, think that the implementation of DB2 would be better. Why
Model Behavior
(Dorian Pyle) Not all models are created equal. Given a choice between a model that makes fewer mistakes in predicting classes and one that makes more, which would you prefer? Which would be the best model: the one that has the higher hit rate (correct predictions), or the one that has the lower hit
Auditing with SQL Profiler
(Brian Kelley) The first time I touched SQL Profiler was to find out what long running queries were hammering a particular database. That was the moment I fell in love with this tool. I’ve used it to find stored procedure recompiles, infinite program loops on the client-side, and other performance n
Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005
(Arun Marathe) This paper explains how batches are cached and reused in SQL Server 2005, and suggests best practices on maximizing reuse of cached plans. It also explains scenarios in which batches are recompiled, and gives best practices for reducing or eliminating unnecessary recompilations.