SQL Server Tutorials, Whitepapers and Training

Download SQL Server DMV Client (Dynamic Management Views)

The SQL Server DMV client is a free, light-weight program that allows you to quickly browse through SQL...

Building a SQL Server 2005 Analysis Services cube tutorial

In this tutorial from Microsoft, you will learn how to build a SQL Server 2005 Analysis Services cube using...

SQL Server Licensing Explained

SQL Server is available under three different licensing models: per processor, per server plus user CALs, and...

Tuning the tempdb database for better SQL Server performance

One of the most important areas of SQL Server performance is the tempdb database. It maintains...

Release of SQL Server 2008 pushed back to 3Q 2008

Microsoft postponed the final release of SQL Server 2008 until the third quarter of 2008. The company had...

The 4 pillars of SQL Server performance tuning

The most important performance areas to watch when tuning SQL Server performance are CPU usage, memory...

The advent of SQL Server 2005 x64

64-bit computing is starting to dominate the server hardware market. The move towards the 64-bit platform...

New features in SQL Server 2005 SP2

New and improved features in Microsoft SQL Server 2005 Service Pack 2 (SP2) include database engine...

Understanding SQL Server memory internals

Like all database servers, Microsoft SQL Server thrives on memory. Each instance of Microsoft SQL Server...

SQL Server 2000 and SQL Server 2005 data types

The right SQL Server data type is crucial to the performance of a production server, especially when...

Complete, differential, and log backups in SQL Server

Database backups are at the core of any disaster recovery planning. Microsoft SQL Server provides...

Introducing database (DDL) triggers in SQL Server 2005

Much like regular DML triggers, DDL triggers fire in response to an event happening on the...

Understanding VARCHAR(MAX) in SQL Server 2005

In SQL Server 2000 and SQL Server 7, a row cannot exceed 8000 bytes in size. This means that a...

Comparing databases and migrating changes SQL Server production databases

Almost all developers use a dedicated development server where they make changes to data and schemas...

SQL Server 2005 and SQL Server Express connection and port troubleshooting

Protocol configuration and firewalls play an important role when you are trying to establish a connection...

SQL Server 2005 Express limitations and Express Manager

SQL Server 2005 Express Edition is a scaled down version of Microsoft SQL Server 2005. Although the database server is limited in enterprise features, most of the limitations do not...