Troubleshooting properties

I recently had an issue where I had updated configuration values, but I was not seeing the changes implemented in the user interface. I opened the code and navigated to the screen where the values were being manipulated. Running debug showed me that the specific…

Update statistics for multiple databases

Updating statistics can be a repeated task , required to be run across your entire environment. So, the above script can update the statistics of all databases (excluding system databases). As a hint, it would be best to set up a SQL Agent Job. Here…