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.

A Look at SQL Log Rescue

by S. Srivathsani

SQLServerCentral.com

Product and Book Reviews

In another look at log tools, author S. Srivathsani looks at SQL Log Rescue from Red Gate Software. Read on about how to setup this tool in your environment and use it for a peek inside your transaction log.

SQLServerCentral.com Email Changes

by Press Release

SQLServerCentral.com

As we begin a migration to a new hosting facility, we'll keep you informed. The first step is an email migration.

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.

A Look at ApexSQL Log

by S. Srivathsani

SQLServerCentral.com

Product and Book Reviews

Reading the transaction log is challenging and one of the tools that enables you go get insight is ApexSQL Log. New author S. Srivathsani takes a look at this tool and how it worked in one environment.

Citrix MetaFrame, SQL Server, and the DBA

by Brian Kelley

SQLServerCentral.com

Administration

In this article, Brian looks at how Citrix MetaFrame can use SQL Server for its internal data repository. The basic operation of SQL Server in a Citrix MetaFrame installation is covered. In addition, Brian looks at how a DBA is an integral part of the support team for a successful Citrix MetaFrame farm.

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.

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.

SQL Server Spotlight on Santeri Voutilainen

by Steve Jones

SQLServerCentral.com

Interviews

The depths of the storage engine must be some interesting places and we dive a little into them with our look at Santeri Voutilainen, one of the very talented SQL Server engineers who worked on the lock manager.

Upcoming Meeting for Southern New England SQL Server User Group

by Press Release

SQLServerCentral.com

User Groups

If you are near Rhode Island, there's a new user group available with SQL Server Guru Grant Fritchey presenting.

Using SMS 2003 SQL Views to Create Custom Reports

A Look at SQL Log Rescue

SQLServerCentral.com Email Changes

SQL Server Error Handling Workbench

A Look at ApexSQL Log

Citrix MetaFrame, SQL Server, and the DBA

Preparing the SQL Server 2005 Clustering Infrastructure

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

SQL Server Spotlight on Santeri Voutilainen

Upcoming Meeting for Southern New England SQL Server User Group

Blogs

Advice I Like: Rewards from Work

Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption

Why your data still can’t answer a simple question

Forums

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

Creating a Simple and Flexible Random Password Generator in SQL Server

SQL Art, Part 3: Happy Easter Fun in SSMS

Question of the Day

Identities and Sequences IV