In several recent articles we explored the fundamental concepts of SQL, the process of creating databases and database tables and the art of retrieving data from a database using simple queries. This article expands on these topics and looks at using join techniques to retrieve data from multiple t

The Unisys e-@ction Enterprise Server ES7000 running Windows 2000 Datacenter Server and SQL Server 2000 Enterprise Edition set the record for e-commerce performance by a margin of 38 percent, according to the Transaction Processing Performance Council's (TPC's) new TPC-W benchmark for e-comm

Welcome to Event Wizard, a tool that allows you to easily explore the PASS educational program. It enables you to search sessions in multiple categories including speaker name, company, topic area and keywords. This useful tool allows you to find exactly the program content that you need to get your

SQL provides several aggregate functions to assist with data summarization. In this article we explore the usage of SUM, AVG, COUNT, MIN and MAX.

By Tony Bain – We have all heard it at one stage or another. “SQL Server is fine for small database applications but it just isn’t as reliable or scalable as other platforms”. This is rubbish. Before you dismiss me as just another Microsoft zealot (jamz) lets review some facts.

This article focuses on the security mechanisms common to all databases that implement the Structured Query Language (or SQL). Together, we'll walk through the process of strengthening data access controls and ensuring the safety of your data.

Author Robin Dewson – Beginning SQL Server 2000 Programming develops an example database, at every point providing clear and practical demonstrations of the relevant ideas. Once you have mastered the basics of SQL Server, this book will take you on to more advanced techniques to enable a firm grasp

By Joe Lumbley – The typical way to handle external data is to create a data file from the outside source and then massage the file with various methods until it meets the requirements to load into the database. This most often results in an ASCII file delimited with UNIX pipe symbols (|). This data

This article focuses on the security mechanisms common to all databases that implement the Structured Query Language (or SQL). Together, we'll walk through the process of strengthening data access controls and ensuring the safety of your data.

FMS, Inc. announced the immediate availability of Total SQL Analyzer™, the first comprehensive documentation and analysis solution for Microsoft SQL Server. Providing comprehensive documentation of all objects, properties, and settings available in SQL Server, Total SQL Analyzer allows developers an