SQL Server

More Topics

ITPro Today logo

Early Versions (SQL Server 2000 – 2008)

Protecting Your Application from Variations in Date/Time Format Protecting Your Application from Variations in Date/Time Format

Microsoft's SQL Server development team charts the recommended clauses that help you avoid errors in date/time format.

byMicrosoft's Sql Server Development Team

Feb 20, 2002

|

1 Min Read

ITPro Today logo

Early Versions (SQL Server 2000 – 2008)

Using XML Bulk Load to Load ADO-Generated XML Data Using XML Bulk Load to Load ADO-Generated XML Data

Feb 20, 2002

1 Min Read

ITPro Today logo

Early Versions (SQL Server 2000 – 2008)

What does ODBC Error Message Mean?What does ODBC Error Message Mean?

byMicrosoft's Sql Server Development Team

Feb 20, 2002

1 Min Read

ITPro Today logo

Early Versions (SQL Server 2000 – 2008)

Optimize Analysis Services Optimize Analysis Services

Feb 20, 2002

1 Min Read

ITPro Today logo

Early Versions (SQL Server 2000 – 2008)

When Not to Normalize Your Database When Not to Normalize Your Database

byMichelle A. Poolet

Feb 19, 2002

1 Min Read

ITPro Today logo

Early Versions (SQL Server 2000 – 2008)

SQL Server XML Technology Preview SQL Server XML Technology Preview

Feb 18, 2002

1 Min Read

Early Versions (SQL Server 2000 – 2008)

Inserting NULL Values

Inserting NULL Values

byUmachandar Jayachandran

Early Versions (SQL Server 2000 – 2008)

Breaking the Billion-Dollar Mark and Other Achievements

Breaking the Billion-Dollar Mark and Other Achievements

Q&As from William Vaughn's Feb. 5 ADO.NET Webinar

Q&As from William Vaughn's Feb. 5 ADO.NET Webinar

byWilliam Vaughn

Early Versions (SQL Server 2000 – 2008)

Aggregating Time Series Data

Aggregating Time Series Data

byMichael Arney

Early Versions (SQL Server 2000 – 2008)

Grouping Web Site Hits into Sessions

Grouping Web Site Hits into Sessions

byMichael Arney

Early Versions (SQL Server 2000 – 2008)

How to Return All Columns from a Table's Row When Calculating Aggregations

How to Return All Columns from a Table's Row When Calculating Aggregations

byItzik Ben-Gan

Early Versions (SQL Server 2000 – 2008)

byKimberly L. Tripp

Early Versions (SQL Server 2000 – 2008)

Using Information Schema Views

Using Information Schema Views

byKalen Delaney

Early Versions (SQL Server 2000 – 2008)

Changing MSDE's Security Mode

Changing MSDE's Security Mode

Early Versions (SQL Server 2000 – 2008)

Trash or Treasure?

Trash or Treasure?

Early Versions (SQL Server 2000 – 2008)

Using bcp to Copy a Result Set to a File

Using bcp to Copy a Result Set to a File

Early Versions (SQL Server 2000 – 2008)

Executing TRUNCATE TABLE Against a Table on a Remote Server

Executing TRUNCATE TABLE Against a Table on a Remote Server

Early Versions (SQL Server 2000 – 2008)

Iterating Through Member Sets

Iterating Through Member Sets

Early Versions (SQL Server 2000 – 2008)

Firing a Trigger for Each Inserted Row

Firing a Trigger for Each Inserted Row

byMicrosoft's Sql Server Development Team

Early Versions (SQL Server 2000 – 2008)

Running Virus-Scanning Software on the Same Server as SQL Server

Running Virus-Scanning Software on the Same Server as SQL Server

byMicrosoft's Sql Server Development Team

Early Versions (SQL Server 2000 – 2008)

Visual Studio .NET and the Microsoft .NET Framework SDK

Visual Studio .NET and the Microsoft .NET Framework SDK

Early Versions (SQL Server 2000 – 2008)

Move Up to SQL Server 2000

Move Up to SQL Server 2000

byMichelle A. Poolet, Michael D. Reilly

Early Versions (SQL Server 2000 – 2008)

Upgrading from SQL Server 7.0 to SQL Server 2000

Upgrading from SQL Server 7.0 to SQL Server 2000

byMichelle A. Poolet, Michael D. Reilly

Early Versions (SQL Server 2000 – 2008)

Make it Short and Sweet

Make it Short and Sweet

byMichelle A. Poolet

Early Versions (SQL Server 2000 – 2008)

Tuning Aggregations

Tuning Aggregations

byKalen Delaney

Early Versions (SQL Server 2000 – 2008)

Visual Studio .NET Database Features

Visual Studio .NET Database Features

Early Versions (SQL Server 2000 – 2008)

OLAP for Developers

OLAP for Developers

Early Versions (SQL Server 2000 – 2008)

Grouping Time Intervals

Grouping Time Intervals

byItzik Ben-Gan

Illlustration of a digital key

Early Versions (SQL Server 2000 – 2008)

Surrogate Key vs. Natural Key

Surrogate Key vs. Natural Key

byMichelle A. Poolet

Early Versions (SQL Server 2000 – 2008)

Multiple Vulnerabilities in Microsoft SQL Server 2000 and 7.0 - 10 Jan 2002

Multiple Vulnerabilities in Microsoft SQL Server 2000 and 7.0 - 10 Jan 2002

Early Versions (SQL Server 2000 – 2008)

Dumping the Duplicates

Dumping the Duplicates

byUmachandar Jayachandran

Early Versions (SQL Server 2000 – 2008)

Multiple Vulnerabilities in Microsoft SQL Server 2000 and 7.0 - 02 Jan 2002

Multiple Vulnerabilities in Microsoft SQL Server 2000 and 7.0 - 02 Jan 2002

Early Versions (SQL Server 2000 – 2008)

Working with Variables in T-SQL, Part 1

Working with Variables in T-SQL, Part 1

byItzik Ben-Gan

Early Versions (SQL Server 2000 – 2008)

Simplifying the Sequence Generator

Simplifying the Sequence Generator

Sign up for the ITPro Today newsletter

Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

Newsletter Sign-Up