[2003-05-20] Introduction to Relational Database Systems
If you collect and use any kind of data you probably have some kind of organizing system. Whether you use index cards, a filing cabinet, Excel spreadsheets, or some kind of database program, your system should let you add and change data, delete data, and retrieve data, and it should work faster and more efficiently than if you had to do it by hand.
[2003-05-20] Transact-SQL Programming - Sample Chapter 1
Transact-SQL, an extension to the SQL database programming language, is a powerful language offering many features--a wide variety of datatypes, temporary objects, system and extended stored procedures, scrollable cursors, conditional processing, transaction control, exception and error handling, and much more. We'll introduce those features later in this chapter in the section "What is Transact-SQL?" Before getting to Transact-SQL specifics, however, we'll provide some background information that will help you get a feel for the overall database environment in which Transact-SQL operates. After we explain the basic differences between ANSI SQL and Transact-SQL, we'll jump back to more generalized topics. We'll cover the genesis of the relational database model and its impact on SQL programming languages. We'll talk a bit about normalizing data and introduce you to the idea of row-processing and set-processing information technology. We'll spend a little time talking about the history of SQL Server in general. Finally, we'll introduce many of the features of the Transact-SQL programming language itself.
[2003-05-19] SQL Errors 101
Many programmers hit a brick wall in their SQL queries, slowing development to a crawl and causing an over abundance of hair loss and coffee consumption. If you have been staring at the screen with a blank look and a pounding heart, wondering what you did to deserve this mess, you have come to the right place. In this article I will unveil the six most common SQL query errors and give you tips on stress prevention.
[2003-05-01] Apache Shared Modules in Delphi
Back in Issue 69 (May, 2001) of The Delphi Magazine in Apache Shared Modules, I looked at the Apache Web server running on Linux and how Kylix could be used to write CGI applications and also Apache shared modules or DSOs (the main thrust of the article). That was shortly after Kylix had been released, and discussed how to overcome a variety of problems, including the fact that the standard Apache binary distribution is not suitable for using shared modules.