Question: Where is the Default Settings for Backup Compression?
SQL SERVER – Setting ARITHABORT ON for All Connecting .Net Applications
Readers of this blog post are aware of SQL Server Expert Tim Cartwright, who has previously written an enhanced version of How to Generate Random Password script. Here is another very interesting find by Tim on the subject of ARITHABORT ON setting. It is one of the most interesting blog post I have read in a while.
SQL SERVER – How to Listen on Multiple TCP Ports in SQL Server?
During my recent engagement of Comprehensive Database Performance Health Check, Sr. DBA asked if it is possible to run SQL Server on multiple TCP Ports. The answer is Yes, it is very much possible.
SQL SERVER – FIX: Error 14001: The Application Has Failed to Start Because its Side-by-side Configuration is Not Correct
There are so many ways to break things in the operating system. In this blog, we would learn about fixing error “The application has failed to start because its side-by-side configuration is not correct”.
SQL SERVER – What is Change Pending State of in SQL Server Configuration Manager?
Recently, one of my clients contacted me for an issue about Change Pending State where they were having issues where SQL Server. As soon as I joined the call with them, they showed me below.
SQL SERVER – What Does SET NOEXEC Do?
Just the other day I received an email with a question – What Does SET NOEXEC Do?
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.