Database Management

New extensions in SQL Server Management Studio increase control over applications and SQL Server instances.

Gain quick insights into assets

• Quickly set up a central management point by using SQL Server Utility Control Point.

• Enroll instances and data-tier applications into centralized, policy-based evaluation.

• Get utilization insights in about 45 minutes.

• Enroll instances one at a time, or use integration with Windows PowerShell to enroll in batches.

Manage by intent

• Deliver default utilization policies with extensions to Policy-Based Management.

• Change utilization thresholds easily by fine-tuning slider bars.

New tools in SQL Server Management Studio help improve consolidation management, maximize investments, and maintain healthier, more cost-effective systems.

Consolidation management

• Benefit from the new utility explorer and dashboard viewpoints in SQL Server Management Studio.

• Access multi-instance management and at-a-glance dashboard views.

• Observe database instance and data-tier application utilization.

• Identify consolidation opportunities or resources at risk.

• Consistently evaluate SQL Server resources for maximum cost control.

Improve service levels

• Easily set policies within the new central management point.

• Set customized, detailed views of resource properties.

• Define desired utilization thresholds across target instances or data-tier applications.

• View data and log-file utilization data across databases and volumes.

Troubleshoot efficiently

• Spot policy violations.

• Promptly identify and resolve potential end-user issues.

• Quickly learn which apps are running on potential problem servers.

SQL Server 2008 R2 introduces a single unit of deployment for data-tier applications, bringing faster development and better collaboration with IT staff.

Enable a single unit of deployment

• Capture database application schema, such as tables and stored procedures.

• Package schema with application deployment requirements.

• Define application deployment requirements within the new project type.

• Outline deployment requirements as simple as “VersionMajor is greater than or equal to 10.”

• Prevent information from getting lost in translation from development to IT.

Accelerate deployments and upgrades

• Make needed changes and hand off updated versions from development to IT by relying on Visual Studio 2010.

• Perform redeployment upgrades by defining requirements and locating application objects.

• Save upgrade and deployment steps through the streamlined process.

• Improve time-to-market.

Deploy on-premises or off-premises

• Deploy data-tier application packages directly to Microsoft SQL Azure, a self-managed, highly available cloud service.

• Optimize resources, based on application needs and IT bandwidth.

Take advantage of tools for fast, quality development

• Guide and enforce coding standards out-of-the-box by using Transact-SQL Static Code Analysis.

• Use warnings to help identify issues before code is handed off for deployment.

• Debug erring stored procedures or functions from the project.

• Insert Transact-SQL code snippets during coding.

• Create on-the-fly lists of available objects and properties.