Should IT charge other departments for the use of its resources? Is that good for the business? Steve Jones comments on what this could mean for SQL Server DBAs.

Database Mirroring FAQ: If the principal fails while running in high performance mode, what options do I have for bringing the mirror online?

by Robert Davis

SQLServerCentral.com

Blogs

Question: If the principal fails while running in high performance mode, what options do I have for bringing the mirror online? This question was sent to me via email. My reply follows. Quick question on DB mirroring client redirection after Principal fails

Restore Analysis Services database using Windows PowerShell and SQL Server 2008 AMO

by Additional Articles

Database Journal

PowerShell

Learn how to restore an Analysis Services database to the same or different location, from a database backup file with password protection.

The Data Loading Performance Guide

by Additional Articles

MSDN Communities

SQL Server 2008

This document described techniques for bulk loading large data sets into SQL Server. It covers both the available techniques as well as methodologies to performance tune and optimize the bulk loading process.

8 Clicks to What Changed

by Bill Wunder

SQLServerCentral.com

SQLClue

Finding out what happened on a SQL Server instance can be a challenge for even experienced DBAs. SQLClue, a new tool by longtime SQL Server expert Bill Wunder can help. We have a short case study that shows you how this tool can help.

Instrumenting Code - Database Weekly (Feb 23, 2009)

by Tony Davis

SQLServerCentral.com

Editorial

In the Oracle world, great importance is attached to "instrumenting" your application code. However, it seems not to be an issue that is much discussed in SQL Server. Tony Davis wonders why...