Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management.

Presenting a high performance SQL engine ported to C# from Java.

This section contains a list of performance tips for the SQL Server and for ASP.NET.

As a developer, I find that an incredible amount of my time is spent dealing with databases in some form or another - be it displaying, manipulating or analyzing data; creating client or server applications. The advent of the .NET Framework has brought with it some major changes, and database access is certainly no exception. Although ADO has been around since 1996, with the arrival of ASP, its latest incarnation present in the .NET Framework - ADO.NET - really does represent its coming-of-age.

This unique introductory SQL tutorial not only provides easy-to-understand SQL instructions, but it allows you to practice what you learn using the on-line SQL interpreter. You will receive immediate results after submitting your SQL commands. You will be able to create your own unique tables as well as perform selects, inserts, updates, deletes, and drops on your tables.

This tutorial is aimed at those of you with some experience with SQL and who want to discover the capabilities offered by some of its more advanced implementations.

SQL Server database best practices

Most enterprise applications today use databases to keep track of their content, and since SQL is supported by every modern relational database, you can apply your SQL knowledge to MS Access, SQL Server, Oracle, and DB2, to name just a few. This compilation of resources will get you on your way.

Pervasive Software makes the claim that Pervasive.SQL 2000 is backward compatible for all older applications, especially those running Btrieve 6.15. This paper examines this claim in more detail, showing the highlights (and the lowlights) of the compatibility issues. The information provided herein is the result of our own experiences. Since every application and network is different, we urge proper testing of your application in your environment!

This users guide will go through some of the basic steps that one might take in order send an HTTP request to a SQL Server. The request will instruct the SQL server to return XML, which we will parse and display neatly in a grid.

In my earlier article on configuring web queries in SQL Server, we saw the various steps that need to be configured in the IIS configuration tool for SQL Server. As a continuation to that, in this article we will see how to enable SQL Server to accept SOAP requests.