Now that you know how to enable the DAC and how to use it, you might want to know what firewall port the DAC listens on and how to set it. With your SQL Server instances, you can easily set which firewall port you want it to listen on in SQL Server Configuration Manager. Unfortunately… Continue reading What Firewall Port does the DAC require
Category: Server Configuration
Enable the Dedicated Admin Connection (DAC) and How to Use it
If you ever find your SQL Server instance runs into some serious performance issues, you might find it's so bad, that you can't even connect to the instance. If only you could connect to run your usual troubleshooting queries to find out what's going wrong and hopefully fix it! This is where the Dedicated Admin… Continue reading Enable the Dedicated Admin Connection (DAC) and How to Use it
Configure Database Mail and Test it – All using T-SQL
When configuring a new SQL Server instance, you probably want to configure Database Mail. As with all your post install configuration changes, it's better to do it using a script to save yourself a whole heap of time while ensuring all your SQL Server instances are standardised and consistent. Unfortunately it's not as easy to… Continue reading Configure Database Mail and Test it – All using T-SQL
Default Directories
You decide to create a new database, or restore one for that matter, and you find that it creates or restores the database to a file location you didn't expect. Why did the data file end up on the C: drive? Why did the transaction log file end up in the same location as the… Continue reading Default Directories