Free download: Managing SQL Servers and Policy-Based Management

Get an excerpt from Microsoft SQL Server 2012 Pocket Consultant  (ISBN 9780735663763; 592 pages) selected by author William Stanek. Click here for your PDF.

imageHere’s what you’ll learn:

Chapter 1: Managing SQL Servers

Microsoft SQL Server Management Studio is the primary tool you use to manage databases and servers. Other tools available to manage local and remote servers include SQL Server PowerShell, SQL Server Configuration Manager, Database Engine Tuning Advisor, and SQL Server Profiler. You use SQL Server Configuration Manager to manage SQL Server services, networking, and client configurations. Database Engine Tuning Advisor is available to help optimize indexes, indexed views, and partitions, and SQL Server Profiler lets you examine events generated by SQL Server, which can provide helpful details for troubleshooting. In this chapter, you will learn how to use SQL Server Management Studio.

■ Using SQL Server Management Studio

■ Managing SQL Server Groups

■ Managing Servers

■ Using Windows PowerShell for SQL Server Management

■ Starting, Stopping, and Configuring SQL Server Agent

■ Starting, Stopping, and Configuring MSDTC

■ Managing SQL Server Startup

■ Managing Server Activity

Chapter 2: Implementing Policy-Based Management

Policy-Based Management is an extensible and scalable configuration framework that you can use to manage servers, databases, and other objects in your data environments. As an administrator, you need to be very familiar with how Policy-Based Management technology works, and that’s exactly what this chapter is about. If you haven’t worked with Policy-Based Management technology before, one thing you’ll notice immediately is that the technology is fairly advanced and has many features. To help you manage this complex technology, I’ll start with an overview of Policy-Based Management and then explore its components.

■ Introducing Policy-Based Management

■ Working with Policy-Based Management

■ Configuring Central Management Servers

■ Managing Policies Throughout the Enterprise