Where are the default settings for backup compression? The Back Up dialog shows three options. Here is where the server default lives and how to set it.
SQL SERVER – Setting ARITHABORT ON for All Connecting .Net Applications
SQL Server expert Tim Cartwright shares a way to set ARITHABORT ON for all connecting .Net applications, so they avoid the bad plans ARITHABORT OFF can cause.
SQL SERVER – How to Listen on Multiple TCP Ports in SQL Server?
Can SQL Server listen on multiple TCP Ports? Yes, and here are the Configuration Manager steps I shared when a senior DBA asked me during a Health Check.
SQL SERVER – FIX: Error 14001: The Application Has Failed to Start Because its Side-by-side Configuration is Not Correct
A Jr. DBA’s SQL Server service would not start: Error 14001, the application’s side-by-side configuration is not correct. Here is how we found the cause.
SQL SERVER – What is Change Pending State of in SQL Server Configuration Manager?
During a rushed release, a client stopped SQL Server and the service got stuck. Here is what Change Pending State in Configuration Manager means and what to do.
SQL SERVER – What Does SET NOEXEC Do?
What does SET NOEXEC do? With SET NOEXEC ON, SQL Server compiles your query but does not run it. Here is how the compile and execute phases work.
SQL SERVER – Error: 17300 – SQL Server Was Unable to Run a New System Task
They noticed that application jobs are failing with the below error message about running a new system task. Let us learn more about this.