Who's Using the DAC?

Learn how you can determine which connection is using the Dedicated Administrator Connection.

Using the DAC

Dedicated Administrator Connection - SQL School Video

If you have trouble connecting to a busy server, you'll want to watch this installment of SQL School. MVP Andy Warren shows how you can use the dedicated administrator connection (DAC) in SQL Server 2005 and above.

Windows Server 2003 SP1

You asked today if there were any issues with SP1. I sure had one!  I started to upgrade our portal server yesterday, and partway through the backup phase it barked that it couldn't find the "support.icw" file to back up. I checked; I didn't have that file. No big, I thought, since it's the Internet […]

RE: How to get the last day of the month

From somewhere on this site (don't have the URL to give credit) CREATE FUNCTION [dbo].[getMthEndDate] (@date datetime) RETURNS DATETIME AS BEGIN RETURN dateadd(month,1+datediff(month,0,@date),0) - 1 END

RE: Killing idle users

OK, bringing som ehumour to the forum... A couple days ago, in the QOD thread, a forum user remarked that really what the question was about was purely semantics. Brian Kelley responded that it was more than semantics: quote: To the DBA, that should all make sense. But even to a system administrator, some of […]