SQL-IMDB is an ultra-fast, generic data management component based on a lightweight in-memory database (IMDB/MMDB) with SQL interface, transaction, UNICODE and multi-threading support. It radically simplifies inter/intra application-data-management by providing "global variables" in the form

Deploying merge replication is generally a simple process. You simply subscribe to a merge publication, allow the snapshot to transfer the schema and data, and you are up and running. What happens though when you have disconnected users, remote subscribers over slow links, unstable connections, or

By Dino Esposito – ADO provides the ability to automatically persist recordsets in XML. The Recordset object exposes the Save method, which can serialize to disk the in-memory representation of the recordset. The following Visual Basic (VB) code shows how to save a recordset to disk using XML as the

by Brad M. McGehee – I don’t yet have my ultimate SQL Server. Yea, I do have a couple of “larger” servers, but not the kind I can really brag about at the upcoming SQLPass conference. So what if I could choose my ultimate SQL Server, what would I choose? After a little thought (about 5 nanoseconds),

This article demonstrates how to programmatically control bcp to generate text files. It uses dynamic SQL and xp_cmdshell to execute a call to bcp from within Query Analyzer.

by Al Hetzel – It is somewhat ironic that the most confusing part of creating and executing a SQL statement from ASP is determining where to put the quotes. When is a single quote used? When is a double quote used? When are they used together? Which takes precedence? This article will answer these q

SQL Server comes in more editions than any other Microsoft .NET Enterprise Server. In fact, SQL Server 2000 comes in no fewer than seven varieties. Here's a quick guide to the differences among the SQL Server 2000 editions. (If you aren't sure which edition of SQL Server you're using, yo

In a follow up to the Introduction to Dynamic SQL we take you through some of the tricks and pitfalls of this technique. We'll cover Create Table, sp_executesql, permissions, scope and more.

By Michael R. Hotek – Backup and Restore is the function of a DBA. All other services are secondary to this. To this end, you will find all of the tools you will need to perform this vital aspect of your services within this section.

SQL Server MVP Brian Moran answers readers' questions about importing Microsoft Access tables into SQL Server 2000, encrypting a column, managing Windows-authenticated logins, and more.