Data Protection for SQL Servers: MS-SQL is used to power some of your most critical information applications. Complete protection of MS-SQL requires a high-availability solution as well as a disaster recovery plan. View this white paper to understand data protection strategies using Double-Take for

(Jeremy Kadlec) Don’t just release new software and hope for the best. This article explains the importance of establishing a performance baseline in this three-part series. In part one, below, the author explains how to validate a baseline. In upcoming tips he’ll cover top 10 performance monitor co

(Cory Cundy) It’s been about five years since the last major upgrade to SQL Server–time enough for Microsoft to update just about every component of the database platform and incorporate many new features.

(Serdar Yegulalp) What makes a database scalable, growing and working well for years to come for 10 to 1,000 or more users? (R)

Fourteen new webcasts are scheduled for August, covering such topics as Heterogeneous Data Integration, Creating a Recoverable Database, Building Reporting Applications with SQL Server 2005 Analysis Services and more.

(Thiru Thangarathinam) In the first part of this article, we looked at the application architecture of a N-tier Web application using ASP.NET 2.0 and SQL Server 2005. We have also understood the creation of CLR managed procedures and data access components. In this installment, we will look at t

(Grant Szabo) I’ve been developing ColdFusion applications since the early days of version 1.5. While a lot has changed for the better with the product since then, not a lot has changed – unfortunately – in terms of the lousy quality of the CFML code that I’m often asked to review or fix.

(Marcin Policht) In the previous article of this series, we started reviewing two new types of containers introduced in the SQL Server 2005 Integration Services – For Loop and Foreach Loop. We also provided a simple example illustrating the use of Foreach File enumerator. We will continue our re

A linked server configuration allows Microsoft SQL Server to execute commands against OLE DB data sources on different servers. Linked servers offer these advantages: –Remote server access. –The ability to issue distributed queries, updates, commands, and transactions on heterogeneous data so

(Jeffrey Juday) Have you ever developed a custom data feed that populates employee information in one of your systems? Do you struggle with account management in your Active Directory? If you answered yes to either of these questions, rest assured because identity management can ease your pain.