Development and Test Solution for Microsoft SQL Server

Date Added: Mar 2010
Format: PDF

From midsize businesses to global corporations, Microsoft SQL Server provides the foundation for mission-critical applications such as Online Transaction Processing (OLTP), Decision Support Systems (DSS), Enterprise Resource Planning (ERP), and Customer Relationship Management (CRM). Today's SQL Server databases are more distributed, generate more transactions, and include new data types compared to those of just five years ago. In addition, many databases are distributed on heterogeneous, multivendor storage environments, encompassing multiple architectures: DAS, SAN, and NAS. As a result, Database Administrators (DBAs) engage in daily management, development, testing, and maintenance tasks that involve copying production databases for patch and upgrade testing, reports, and application development.