A Month of SQL Server Tips - Week 2

 

A Month of SQL Server Tips - Week 2

This month, TechNet Magazine is bringing you A Month of SQL Server Tips.  We're posting a new tip every day, Monday through Friday. Here are the tips we posted this week.

Use New Cmdlets in SQL Server PowerShell to Mange SQL Server 2008
SQL Server PowerShell includes new cmdlets designed specially for working with SQL Server 2008. Here's a look at what's new, and what you can do.

How to Quickly Create a Copy of a Table using Transact-SQL
The easiest way to create a copy of a table is to use Transact-SQL. Find out how.

Monitor SQL Server Performance and Activity with Built-In Functions
SQL Server includes a number of built-in functions you can use to retrieve system information. Here's an overview of these functions.

Understand the Replication Models in SQL Server 2008
To make replication go smoothly, you need to do a bit of planning, which involves selecting a specific replication model. Here's an overview of the common replication models you will likely choose from.

Manage Access and Roles with Transact-SQL (T-SQL) Commands
You can use T-SQL commands to manage access and roles in SQL Server. Here's a summary of the commands you'll use.

TechNet Magazine Blog : A Month of SQL Server Tips - Week 2