Service Pack 2 CTP

Service Pack 2 for SQL Server 2005 has been released as a CTP. Steve Jones installed it and has a few thoughts on this pre-release product.

Step-by-Step Guide: Installing SQL Server 2005 Reporting Services

Working with a new piece of technology can be intimidating. Not having the technology installed correctly can only lead to more difficultly. This guide outlines steps to properly install SQL Server 2005 Reporting Services and the current service pack to get you going in the right direction.

Toying with template parameters in SQL Server 2005

If you create functions or stored procedures from SQL Server 2005 Management Studio, you will notice that the new window is filled with a template. In general, you get a skeleton interspersed with markers. This article discusses how you can use templates.

Using Report Builder, which of the following statements...

If you absolutely need a report to look...

After you've completed a backup for your Sales...

Data partitioning in SQL Server 2005 - Part I

Learn how to make life easier by dividing large tables and indexes into smaller parts.

SQL Server Backup Crib Sheet

It's small and neat but it might just save your data...Robyn Page's crib sheet tells you everything you wanted to know about SQL Server backup but were afraid to ask.

Low-Cost High Availability: Simple Database Monitoring in a Windows En

The .NET Framework 2.0 and Visual Studio 2005 make it easy to create a basic but extensible database-monitoring solution without a lot of complexity or coding.

SQL Server 2005 Large Value Data Types

Microsoft has come to the rescue for managing large text fields in SQL Server 2005, by creating a few new large value data types. This article explores these new data types.