Setting Up Delegation for Linked Servers

Learn how to set up delegation on your SQL Server instances, so you can use the impersonate options when setting up the security properties of linked server definitions.

Finding Column Dependencies

Most experienced DBAs know that sysdepends is not very reliable, so how can you find the dependencies inside your database? New author Christian Buettner brings us his technique for finding those hidden dependencies based on your query plans.

Getting SQLAgent to Respond Faster

One limitation of SQLAgent is that granularity to which you can schedule jobs: every minute. Sometimes there are things that you would like to happen more frequently, like alerting. Johan Bijnens brings us a technique for getting your SQL Agent to respond to alerts in as little as every 10 seconds.

You have just purchased a brand new 32-bit...

Avoiding Microsoft SQL Server 2005 deployment pitfalls

This tutorial shows you how to properly install Microsoft's SQL Server 2005, avoiding the pitfalls of an unsuccessful deployment.

Where can you see the actual SQL code...

Which file groups can be placed on an...

You have a default SQL Server 2005 server...

Server Farm Reporting - Part 2

Building on his first article examining management of a large server farm, Mark Tierney brings us part 2 in which he examines the data gathering process.

Using Non-Standard Port for SQL Server

Greg Larsen examines setting up SQL Server to listen on a different port number than 1433.