SearchSQLServer: Expert advice on database administration

Microsoft SQL Server 2008 Learning Guide

Thu, 16 Jul 2009 13:04:34 EDT

This guide provides an in-depth look at SQL Server 2008, with information on upgrading, overviews of the most important new features, and details on future releases.

How to 'do' SQL Server disaster recovery

Don Jones, Contributor — Wed, 15 Jul 2009 09:54:31 EDT

Understanding how backups really work in SQL Server can save you a lot of time and trouble. Learn where most SQL Server newbies get lost during the backup and recovery process.

Protect virtual databases through SQL Server database mirroring

Danielle Ruest and Nelson Ruest, Contributors — Mon, 13 Jul 2009 10:04:40 EDT

Learn how database mirroring provides cost-effective protection for critical databases running on virtual machines.

Setting up SQL Server Service Broker for secure communication

Denny Cherry, Contributor — Wed, 08 Jul 2009 10:22:54 EDT

Securely sending Service Broker messages from instance to instance requires a somewhat complex configuration. This tip walks you through the proper methods.

A first look at Microsoft SQL Server 2008 R2

Ross Mistry and Shirmattie Seenarine, Contributors — Wed, 01 Jul 2009 12:48:12 EDT

Get details on the new features and improvements that are expected to be apart of Microsoft's upcoming SQL Server release, set to launch in early 2010.

Top load balancing methods for SQL Server

Matthew Schroeder, Contributor — Mon, 29 Jun 2009 14:11:21 EDT

There are a number of way to achieve load distribution in SQL Server environments. Learn about some of the key methods, including merge replication, log shipping and SSAS server farm deployment.

Performance implications of transaction log autogrowth in SQL Server

Michelle Gutzait — Thu, 25 Jun 2009 10:01:55 EDT

Take a closer look at the performance implications of shrinking transaction log files in SQL Server.

The keys to database backup protection for SQL Server

Denny Cherry, Contributor — Mon, 22 Jun 2009 11:22:15 EDT

There is a lot more to database backup than simply saving your info to a disk. Learn the steps that must be taken after the backup process to ensure that you and your database are 100% protected.

Maintaining high availability of SQL Server virtual machines

Danielle Ruest and Nelson Ruest — Mon, 15 Jun 2009 16:11:44 EDT

Learn to take advantage of Hyper-V and Windows 2008 in order to achieve fault-tolerant and highly available SQL Server virtual machines.

The short course on how SQL Server really works

Don Jones — Wed, 10 Jun 2009 15:40:42 EDT

Have you found yourself in the uncomfortable role of DBA simply because there's no one else to do the job? This series is for you. In part one, learn the basics of how data moves from disk to memory in Microsoft SQL Server.