For those of you still using SQL Server 2000, learn how to use SQL-DMO to create DML scripts to deploy new records or data changes to other servers. From Oscar Garcia.

Why Is It Complicated?

by Steve Jones

SQLServerCentral.com

Editorial

One of the very common things that is needed in SQL Server is performing a restore of a database. It's also one of the most important things that needs to take place. So why isn't this a simpler process? Steve Jones wonders why we can't make this a simpler process.

Electronic Health Records – What’s the Big Deal? (Part 2)

by Tim Mitchell

SQLServerCentral.com

Blogs

In the first installment of this discussion, I talked about the challenges facing database professionals and others with respect to...

SQL Server Reporting Services Disaster Recovery Case Study

by Additional Articles

SQLCAT

Reporting Services (SSRS)

There are many ways to perform disaster recovery with Microsoft SQL Server Reporting Services (SSRS). Based upon customer experience and internal testing, this technical note provides guidance around best practices to design and manage robust end-to-end disaster recovery (DR). This DR method will involve both automatic and manual failover in the form of content switches, SQL Server failover clustering, and database mirroring. This case study focuses on the lessons learned from CareGroup Healthcare System.

Using SQL Server 2008 Reporting Services with SAP NetWeaver Business Intelligence

by Additional Articles

Microsoft MSDN

SQL Server 2008

This paper discusses the integration of SAP NetWeaver BI ® with Microsoft ® SQL Server ® 2008 Reporting Services (SSRS). The paper provides an overview of using the Reporting Services SAP Netweaver BI data provider and related query designer, to build high quality reports against SAP NetWeaver BI sources. For Reporting Services users who are new to working with SAP NetWeaver BI, this paper will help you connect and build datasets. For users already familiar with SAP NetWeaver, the paper will show how some of that system’s notable features can be leveraged in Reporting Services reports. It also presents some tips and tricks that can help you make the most of the integration between the two products.