Additional Articles

Using SMS 2003 SQL Views to Create Custom Reports

by Additional Articles

TechNet Blogs

Miscellaneous

Microsoft Systems Management Server (SMS) 2003 Reporting uses Microsoft SQL Server views to provide access to data from the tables in the SMS site SQL database and to offer an efficient reporting option. The SMS site SQL database contains a large collection of information about the network, computers, users, user groups, and many other components of the computing environment. This database also contains objects that represent SMS items such as advertisements, packages, queries, reports, and status messages.

2007-03-08

1,706 reads

Discuss

SQL Server Error Handling Workbench

by Additional Articles

SimpleTalk

Stored Procedures

Grant Fritchey steps into the workbench arena, with an example-fuelled examination of catching and gracefully handling errors in SQL 2000 and 2005, including worked examples of the new TRY..CATCH capabilities.

2007-03-06

3,580 reads

Discuss

Preparing the SQL Server 2005 Clustering Infrastructure

by Additional Articles

SQL Server Performance

Administration

Before you even begin building a SQL Server 2005 cluster, you must ensure that your network infrastructure is in place. Here's a checklist of everything that is required before you begin installing a SQL Server 2005 cluster.

2007-03-02

2,443 reads

Discuss

Should You Upgrade Your Current SQL Server Cluster to a SQL Server 200

by Additional Articles

SQL Server Performance

Administration

If your organization is like many organizations, it may have some older version SQL Server clusters in production. If so, at some point you will have to make a choice about how to upgrade them to SQL Server 2005.

2007-03-01

1,739 reads

Discuss

Database Design: A Point in Time Architecture

by Additional Articles

SimpleTalk

Advanced

In most relational database implementations. Update and Delete commands destroy the data that was there prior to their issue. However, some systems require that no information is ever physically deleted from or updated in the database. In this article, Arthur Fuller presents a solution to this requirement in the form of a Point-in-Time architecture: a database design which allows a user to recreate an image of the database as it existed at any previous point in time, without destroying the current image.

2007-02-28

3,723 reads

Discuss

Using BACKUP and RESTORE in SQL Server

by Additional Articles

SQLTeam.com

Administration

This article covers the basics of full backup backups and restores in SQL Server. The examples are from SQL Server 2005 however it applies to SQL Server 2000 and SQL Server 2005. This is a very basic article covering full database backups, database restores and the simple and full recovery models.

2007-02-27

5,180 reads

Discuss

Using Plan Guides in SQL Server 2005

by Additional Articles

SQL Server Performance

Performance Tuning

In SQL Server 2005, there is a new feature called Plan Guides that can help out in some cases where you discover poorly performing queries that you don't have direct control over. Essentially, a Plan Guide allows you to add or modify query hints to queries on the fly, just before they are executed.

2007-02-26

2,178 reads

Discuss

Retrieving Data as XML from SQL Server

by Additional Articles

Other

Basics

All the hype that once surrounded XML is finally starting to die down, and developers are really beginning to harness the power and flexibility of the language. XML is a data descriptive language that uses a set of user-defined tags to describe data in a hierarchically-structured format.

2007-02-23

3,672 reads

Discuss

Turn XML into relational data with OPENXML

by Additional Articles

Builder.com

OpenXML

XML support has been significantly extended for SQL Server 2005. In this article, Tim Chapman takes a look at how you can shred XML data into a relational format with SQL Server's OPENXML function.

2007-02-22

4,779 reads