Home > Articles > Data > SQL Server

SQL Server Reference Guide

Hosted by

Toggle Open Guide Table of ContentsGuide Contents

Close Table of ContentsGuide Contents

Close Table of Contents

Database Services

Last updated Mar 28, 2003.

At times, you'll want to program not only the data in SQL Server, but the architecture itself. backups, replication, Data Transformation Services (DTS), the Analysis Services, Metadata Services, and English Query all expose methods and APIs to the developer.

Before I get to the programming code, though, I need to cover some basics. If you're new to programming a database, then Data Modeling 101 is where you should start. Here you'll learn about the database objects and structures you'll need to design your application. It's beyond the scope of this introduction to properly cover data modeling, but the basics are to determine the function of the data and how it will be accessed. There are some rules for designing a database, but these rules cannot be pressed into service blindly, since the answers to the question of use and function will dictate deviations from the rules.

Transact-SQL (T-SQL) is Microsoft's extension to the Structured Query Language (SQL). SQL is the language you use to access and program relational databases. Microsoft fully implements the ANSI SQL-92 SQL standards, and extends those commands to help simplify accessing, adding, and editing data.