Click here to Skip to main content

Database

Great Reads

by Jonathan de Halleux
A helper framework for generation of SQL queries in C++ and Lua
by Michael N. Haephrati
The DataTune system was one of the earliest data cleansing systems.
by Alexey
The alxBase classes for work with dbf files.
by Brad Kremer
A CRecordSet like interface for a SQLite database table.

Latest Articles

by Brad Joss
SQL CLR Functions for Zip Compression and Regular Expression evaluations
by John Atten
If you are new to SQLite, you may well run across one of the most confounding of its implementation details the moment you attempt to do some sort of bulk or batch processing of inserts or updates. What you will discover is that unless properly implemented, inserting or updating multiple records
by PIEBALDconsult
A stored procedure I use to find duplicate records in tables and views.
by Mika Wendelius
Some simple scenarios to calculate running totals in SQL Server.

Research Library

Dell Toad DBA Suite for Oracle complements Oracle Enterprise Manager by...
Toad for IBM DB2 is a powerful tool for the database administrator. But...
Database administrators, developers, QA analysts and performance...
Toad for Oracle is the database management tool of choice for both...

Discussions

by PIEBALDconsult on article "Simplified Database Access via...
by Bruno Sprecher on article "Simplified Database Access via...
by Mika Wendelius on Article "Calculating simple running totals in...
by db7uk on Article "Calculating simple running totals in...
by Marla Sukesh on article "Learn Microsoft Business intelligence...

All Articles