Starting in 1996, Alexa Internet has been donating their crawl data to the Internet Archive. Flowing in every day, these data are added to the Wayback Machine after an embargo period.
Using ADO from C++
Rating: Prasun Paul - 03/25/2004 Provides an easy technique to access ADO objects from C++. C++ programmers can enjoy
VB like easy ADO programming model by applying this technique.
Doing Database Operations In Batches
Rating: Tom Archer - MSFT - 02/26/2004 There are times when it is advantageous to perform certain database operations in batch. This excerpt from Extending Applications with the .NET Framework details how and when.
Basic Database Operations with ADO.NET
Rating: Tom Archer - MSFT - 02/17/2004 Learn about basic ADO.NET operations with this excerpt from Extending MFC Applications with the .NET Framework.
CMyADO'—Making Life Easy for the ADO Coder
Rating: Nathan Davies - 08/04/2003 This ADO wrapper class can be used to call stored procedures and provides a simple, consistent way to add and retrieve parameters and recordset fields.
An ADO Based Data Copying Utility
Rating: none L. Shyamal - 04/15/2002 This is a simple utility that helps in copying data from one data source to another.
ADOX in Detail
Rating: Michael Kolechkin - 02/22/2002 This article is about database creation and structure modification using MS ADOX library in a program.
Database Programming ATL
Rating: none Alboaie Sinicc - 12/21/2001 How to use ATL OLE/DB code with an ADO connection
Creating Database Objects Using ADOX
Rating: none J. Smits - 10/15/2001 ADOX stands for 'Extended ADO'. It extends ADO in that you can create tables, databases, columns etc. without the use of 'Create Table'-like SQL statements. This code creates an MDB database using ADOX.
ADO Wrapper Classes
Rating: Dogu Tumerdem - 03/21/2001 Based on Bob Place's ADO tutorial, this set of classes provides a very nice, yet simple wrapper to the ADO interface.
ADO Data Bound Class Wizard
Rating: none Ly Nguyen - 09/20/2000 ADO-based class that binds member variables to database columns
ADO.NET Basics
Rating: Tom Archer - MSFT - 02/12/2004 Logic dictates that we take a minute to familiarize ourselves with the terms and classes that implement this technology. This book excerpt is a primer for the terminology and main classes associated with disconnected data.
Multi-Threaded DAO
Rating: none Jeffrey T. Miller - 10/01/2002 Multi-Threaded DAO
File I/O, Complete Control the Old-Fashioned Way
Rating: none Lance Jepsen - 08/19/2002 Although using MFC's built-in serialization capabilities is a handy way to save and load data, sometimes you need more control over the file-handling process.
AccessLog -
Rating: none Luca Piergentili - 11/07/2001 How to give an XBase fashion to the Berkeley DB library
CDataFile Class
Rating: none LiQintao - 10/02/2001 The CDataFile class is used to create and modify data files such as *.ini and *.cfg.
Accessing Your Database with C++ Is as Easy as DTL
Rating: Victor Volkman - 09/23/2005 Go one step beyond the Standard Template Library (STL) with the Database Template Library (DTL), which offers many advantages over the traditional procedural approach to database access.
Compact an Access Database Programmatically
Rating: none jibesh - 08/18/2003 Compact an Access database and change the password of the compacted database programmatically. This can be done without installing Microsoft Access.
Mix the MFC Document/View and MS Access Database Applications
Rating: none Vladimir Zubov - 12/11/2001 The combination of MS Access/VBA and Visual C++/MFC allows developers to effectively resolve tasks of any complexity. This alliance is especially effective for development of data mapping system, such as graphics, multimedia, GIS, CAD etc.
System DSN to Access DB
Rating: J. Smits - 11/21/2001 Creating a system DSN to an Access database at runtime in Visual C++.
[Updated] Microsoft Excel Automation Class
Rating: Val Golovlev - 04/25/2006 Learn to implement and OLE and IDispatch interface to access basic Excel functions from a C++ application.
MySQL UDFs
Rating: DarkLizener - 09/19/2006 Learn how to extend MySQL with your own functions in C/C++.
Identity Management with Microsoft Identity Integration Server
Rating: none Jeffrey Juday - 07/22/2005 Identity management with Microsoft Identity Integration Server (MIIS) not only saves time and money; it also eases the burden on end-users and enhances security. Learn how to create an MIIS solution.
[Updated] Delaunay Triangles
Rating: Sjaak Priester - 07/19/2005 Learn about an algorithm to calculate this intriguing and important data structure in
computer graphics.
MySQLWrapp: MFC-Extension Library for MySQL
Rating: Ovidiu Cucu - 06/28/2005 A collection of C++ classes for working with MySQL databases, easy to integrate in an MFC application.
The Longhorn Speech API, an Initial Glance
Rating: none Jason Nadal - 04/26/2004 The Longhorn speech API offers baked-in functionality for voice commands inside the operating system.
Adding Records to an Open Database in Windows CE
Rating: none Nancy Nicolaisen - 03/29/2004 What would a database be without some data? Discover how to add records in a CE database application.
Comparing Recordsets in a Database
Rating: none Thomas Aust - 09/19/2002 Compare and verify the results of changes in a database structure. You can define a set of queries that can dump their results to a file. These files then can be easily compared.
Creating a Custom Database Class That Uses IStorage
Rating: none Vyatcheslav Archibasov - 09/05/2002 If the possibilities of using the usual wrappers DAO or ADO do not satisfy your requirements, a solution can be the organization of your own database...
Portable File Class
Rating: none Dmitry Khudorozhkov - 08/12/2002 A file class that can be used on non-Windows machines as well as Windows machines.
Ultra Simple DB Class Interface for ODBC
Rating: none Mark Henri - 09/12/2003 The ODBC API has a lot of power and flexibility, but sometimes you just want to get the data without all the effort. Hence, these simple class wrappers. (The article, demo project, and source code were updated.)
A Simple and Smart ODBC Wrapper Library
Rating: none Nick E. Geht - 10/02/2002 Direct usage of ODBC is very complex. Anybody who tries to work with ODBC will agree with this statement. This small and smart ODBC wrapper makes working with ODBC much simpler.
Executing Multiple Firect ODBC SQL Calls
Rating: none Dale Harkness - 03/01/2002 Have you ever tried to issue multiple direct ODBC calls only to have some of the calls after the first fail?
Database Template Library
Rating: none Corwin Joy & Michael Gradman - 03/14/2001 The authors of this library have combined the flexibility of templates with the power of ODBC to create a truly unique and robust library for database access!!
EXPRESS OLE DB Library for C++
Rating: Ghanshyam Naik - 03/19/2002 A complete library that is feature-rich, light-weight, lightening fast, and most easy to use. Library download added to site.
Extended OLEDB library : Ease of ADO, power of OLEDB
Rating: none Ghanshyam Naik - 12/04/2001 This article presents a set of classes that are extended from ATL consumer template classes for OLEDB. While these classes provide added flexibility and functionality like ADO, they still retain the power and performance of consumer template classes.
Using Pipelined Table Functions (Oracle 9i)
Rating: none Toji Mammen George - 03/12/2003 An overview of the usage of Pipelined Table Functions, introduced in Oracle 9i, which enable accepting and returning multiple rows using Table Functions in PL/SQL.
A Lightweight C++ Wrapper over Oracle's OCI Library - OraLib
Rating: none Bobi B. - 07/26/2002 A C++ library, wrapper over Oracle's OCI library. OraLib saves you low-level function (API) calls and takes care of the low-level knowledge you should otherwise possess.
Designing a SQL Service Broker Control Bus
Rating: none Jeffrey Juday - 10/02/2006 SQL Server Management Studio just doesn't cut it for complicated configuration and monitoring implementations. Learn how to implement your own SQL Service Broker (SSB) control bus solution to serve the needs of complex SQL Server-based messaging solutions.
SQL Server 2005 Service Broker Plays Well with Older Relatives
Rating: none Jeffrey Juday - 09/08/2006 You can leverage SQL 2005 Server Service Broker with existing technologies such as SQL Server 2000 and MSMQ. BizTalk and SSB external activation are viable options, but a simple polling solution is easier.
Using SQL Server to Implement the Publish-Subscribe Integration Pattern
Rating: none Jeffrey Juday - 07/31/2006 Utilizing design patterns with SQL Server 2005 Service Broker enables you to assess and select appropriate solutions for all of your SQL Server 2005 asynchronous messaging needs.
Incorporate Data Warehouse QA Checks into MOM 2005
Rating: none Jeffrey Juday - 06/12/2006 Microsoft Operations Manager 2005 (MOM) is a very capable monitoring tool, but it's limited when it comes to quality assurance. Learn how to use WMI and MOM's rules and notification capabilities to run automated data warehouse QA checks.
Database Visualization
Rating: none VGirish - 06/07/2006 When handling a project with hundreds of tables, it takes some time to understand the flows. Learn how to create a simple tool for Visualizing database tables and relations.
SQL Server 2005 Programmability Enhancements — Common Table Expressions
Rating: none Scott Klein - 05/16/2006 There is a plethora of new T-SQL features and enhancements in SQL Server 2005. Learn about one of them — specifically, Common Table Expressions (CTE), because they often come in handy.
User-Defined Functions: Powerful Alternatives to Views and Stored Procedures
Rating: Jeffrey Juday - 04/14/2006 Table-valued user-defined functions (UDFs) are functionally similar to views but structurally similar to stored procedures, giving them all the important features of views and stored procedures and some additional functionality that they lack.
Storing Session State in a SQL Server Database
Rating: none Bipin Joshi - 04/05/2006 In ASP.NET 2.0, you can customize the session state store as per your requirement. Explore one of the scalable and reliable approaches for storing session variables—SQL Server.
Put Some "BAM" in Your Next BizTalk 2004 Project
Rating: none Jeffrey Juday - 02/24/2006 Need to gather some metrics on the steps within your BizTalk 2004 Orchestration? Check out Business Activity Monitoring (BAM).
Using the SQL Server 2005 Integration Services Class Library
Rating: Jeffrey Juday - 12/02/2005 Learn how to extend SQL Server 2005 Integration Services (SSIS), the new ETL tool that ships with SQL Server 2005, to perform operations that aren't already bundled with the product.
Solving the Mysteries of SQLCLR and System.Transactions
Rating: none Sahil Malik - 10/17/2005 When you write to an underlying table via a CLR database object, a number of questions come up. Get the answers—along with a breakdown of how System.Transactions, a new .NET namespace, can help.
Writing Database Objects in CLR: Advanced Scenarios
Rating: none Sahil Malik - 09/21/2005 When you write code to be run inside SQL Server 2005, you usually want to deal with other database objects. Learn how to write a CLR-stored procedure that uses a simple table valued function to handle that scenario in a couple of ways.
Writing Database Objects in CLR
Rating: Sahil Malik - 09/14/2005 You can use CRL to author a number of database objects. Follow a canonical example that explains the main steps involved in using and creating a CLR object inside SQL Server 2005.
An Intro to CLR Integration in SQL Server 2005
Rating: Sahil Malik - 08/19/2005 Learn all you need to know about the CLR integration available in SQL Server 2005. Get a high-level introduction, followed by a discussion of the implications of writing database objects in CLR code and a comparison with existing alternatives such as T-SQL or extended stored procedures.
Introduction to SQL Server Report Builder
Rating: none Mike Gunderloy - 07/15/2005 SQL Server 2005 is the first version to include end user reporting capabilities. See how the new Report Builder makes it easy for analysts to generate reports while avoiding the performance pitfalls of completely ad hoc reporting.
Understanding Hibernate ORM for Java/J2EE
Rating: Saritha S.V - 07/12/2005 Hibernate is the most popular and most complete open source object/relational mapping solution for Java environments. Learn Hibernate by using a simple Java application.
Explore SQL Server 2000 DTS Packages Using .NET and the DTS Class Library
Rating: none Jeffrey Juday - 05/03/2005 Before embarking a major database change such as upgrading to SQL Server 2005, how do you assess the scope of the change on your DTS packages? Use the DTS class library and .NET Interop.
SQL Server Integration Services: SQL Server 2005's New ETL Platform
Rating: none Thiru Thangarathinam - 04/14/2005 Learn how to create and execute packages using SQL Server 2005's new ETL platform SQL Server Integration Services and its integrated development environment, Business Intelligent Development Studio.
What's New in ADO.NET 2.0 for SQL Developers
Rating: none Dino Esposito - 04/04/2005 ADO.NET 2.0 introduces enhancements to the .NET provider model and SQL Server managed provider, which go a long way towards getting better support for specific database features within the boundaries of a common object model.
Implement User-Defined Functions in SQL Server 2005 with Managed Code
Rating: Thiru Thangarathinam - 08/26/2004 SQL Server 2005's integration with the .NET common language runtime enables developers to create database objects such as user-defined functions using languages such as VB.NET and C#.
New HTTP Endpoints Create SQL Server 2005 Web Services
Rating: none Peter DeBetta - 08/05/2004 SQL Server 2005 supports native HTTP SOAP via a feature known as HTTP Endpoints. Find out how this new feature makes the creation of Web services a snap.
Accessing The Registry From SQL Server
Rating: none dinesh123 - 07/02/2004 Learn how to find the country list from a computer's registry. You see how to read and write to the directory from SQLServer.
Generate Complex Next Numbers with SQL Server
Rating: dinesh123 - 07/01/2004 Generating 'next numbers' numbers in SQLServer should not be a problem. But problema arise when a customer asks for different types of next numbers that you cannot generate directly from SQL Server. Learn how to tackle this problem in different scenarios.
Cursors
Rating: Ali Sufyan - 05/14/2004 An explanatory article on cursors in SQL Server.
Sample Chapter: Efficient PL/SQL 02/05/2004 When used intelligently, PL/SQL can build applications that perform well, are resilient to change over time, and scale to large user populations.
SQLServer Search Dialog Class
Rating: none Marcos Lima - 02/11/2001 You simply add your search fields to a dialog resource and this class does the rest to give your users a great SQL Server search dialog!
WinFS Basics: Working with a Data Store
Rating: none Sahil Malik - 01/30/2006 Introducing the next step in information storage on the Windows platform: WinFS, an active storage platform. Learn the basic operations that you can perform on a WinFS data store.
The Anatomy of a CE Database Record
Rating: none Nancy Nicolaisen - 12/17/2004 Discover how to interpret retrieved records from a remote database and format them for display.
A Kick-Start to SAX with C++, Part 1
Rating: Marius Bancila - 03/10/2006 Learn how to process XML documents' content with the Microsoft COM implementation of Simple API for XML (SAX).
Using DDL Triggers to Manage SQL Server 2005
Rating: none Jeffrey Juday - 09/28/2005 Get an introduction to the extended SQL Server 2005 trigger functionality that Data Definition Language (DDL) triggers provide for both databases and servers.
The Fundamentals of the SQL Server 2005 XML Datatype
Rating: none Jeffrey Juday - 08/31/2005 SQL Server 2000 developers and DBAs who've been yearning for better XML support in SQL Server will be pleased with the new XML datatype in SQL Server 2005. If you're one of them, learn the fundamentals of the datatype so you can get going.
Loading Blowfish-Encrypted Data Into an MSXML2 DOM Object
Rating: Tom Archer - MSFT - 06/15/2005 Learn how to use helper functions that (by utilizing a popular Blowfish class) open and decrypt an XML file in memory and then load that memory—without writing it to disk—into a DOM object.
.NET and XML: Part 1—XPath Queries
Rating: Klaus Salchner - 07/19/2004 This is the first of a series of articles that evaluates how well .NET supports XML and its surrounding standards. This article provides a good overview of the power of XPath queries.
Enterprise Application Integration (EAI) Using XML
Rating: Syed Hameed - 03/26/2004 Best Practices and Standards in EAI must be practiced for reducing costs and increasing the effeciency for any EAI application.
All
