Databases in Azure: Copy and Exports

Toady we are going to make a copy and export your DB to Azure Storage. Lets get started.

Spackle: Making sure you can connect to the DAC

The DAC is an important tool and several things can go wrong when trying to connect to it.

Dedicated Administrator Connection (DAC)

We all dread the scenario whereby SQL Server is under so much load and has a complete lack of resources...

SQL Server Browser & DAC

Enabling the Dedicated Administrator Connection (DAC) in SQL Server Express

SQL Server Express has the same code base as the rest of the versions of SQL Server, but there are some differences in how to set it up and configure various tasks. MVP Brian Kelley shows us how to enable the Dedicated Administrator Connection.

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.

DAC - What to Execute when Connected?

SQL Server Issues? Connect with Dedicated Administrator Connection (DAC), then what? Execute this stored procedure to get some understanding on what is going on in the SQL server.

RE: rewrite code to eliminate isnull

I can't believe that there is a general performance problem with ISNULL as it would have been spotted long ago.  I have never had any trouble with it and I have used it extensively for many years.If you have a performance problem then it must be related to your specific query or the database design […]

RE: Computer grabbing all IP Adresses - is SQL Server instance involved?

Okay, that's a bit different. You say it's choking all the network traffic and it's exposed to the Internet. When you get a chance, if you issue a @@VERISON on it, what is returned? Also, is there anything between the SQL Server and the Internet that provides any filtering... firewall, etc?

RE: SQL EM Lost my Server List

Something similar happened to me a while ago but with databases rather than servers.  In that case I was using SQL 2000 EM to take SQL 7 databases offline.  Somehow, SQL server managed to put a data value that was bigger than could be supported by the data type in the sysdatabases table.  I recall […]