The Basics of SQL Server Policy-Based Management

Get a brief overview how to use policy-based management to manage SQL Server in your organization. Follow our daily tips:• facebook.com/TechNetTips• twitter.com/TechNetTips• blogs.technet.com/tnmag

0

Specify which Built-In Account SQL Server Services Should Use

SQL Server and its components have specific rights and permissions from the startup service account.  You can configure services to use different types of built-in accounts (or you can configure services to use domain accounts). To specify a built-in account for a SQL Server service, here’s what you need to do. Follow our daily tips:•…

0

Use ALTER DATABASE to Move Databases

Here’s a look at how you can use the ALTER DATABASE function in SQL Server 2008 R2 to move database files and full-text catalogs. Follow our daily tips:• facebook.com/TechNetTips• twitter.com/TechNetTips• blogs.technet.com/tnmag

0

Play it Safe and Configure a Fail-Safe Operator

Using a fail-safe operator is a good best practice for monitoring SQL Server and ensuring it is running optimally. Here’s what you need to know. Follow our daily tips:• facebook.com/TechNetTips• twitter.com/TechNetTips• blogs.technet.com/tnmag

0

How to use Windows PowerShell to Manage SQL Server

Get an overview of how you can use Windows PowerShell to manage SQL Server 2008 and learn the basic syntax you’ll need to know. Follow our daily tips:• facebook.com/TechNetTips• twitter.com/TechNetTips• blogs.technet.com/tnmag

0

Create Server Groups to Manage SQL Server

Find out how you can use server groups in SQL Server 2008 to organize your servers and simplify server management. Follow our daily tips:• facebook.com/TechNetTips• twitter.com/TechNetTips• blogs.technet.com/tnmag

0