Year over year we have had an increase in the number of people regularly using Database Health Monitor as shown in the chart below. I would like to see this grow at a faster rate, but it does show that the people who use Database Health Monitor continue to use it. Also I have received several feature requests lately from …
You may be configuring SQL Mail for the first time or the thousandth time and you come across the following cryptic message. Date 8/xxxxxx03 AM Log Database Mail (Database Mail Log) Log ID 40 Process ID 56316 Mail Item ID 14 Last Modified 8/ xxxxx 03 AM Last Modified By sa Message The mail could not be sent to the …
Now through the end of August, at Stedman Solutions, we are offering a discount to the our Prepaid Mentoring package. 20% off the normal rates when you sign up and pay by August 31st, 2019. One of the popular service packages that we offer at Stedman Solutions is the SQL Server Mentoring package. The mentoring package is great for the …
Today I released the August 2019 release of Database Health Monitor. This is version 2.9. My favorite new report is the Blocking By Hour of Day report which uses the existing data that is collected by the historic monitoring feature. Below is a list of some of the things that have been fixed or added in this version and the …
I received a contact message from the “Contact us” form, asking about how to go about repairing corruption in TempDB. The error message was something like this: SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:118576; actual 0:0). It occurred during a read of page (1:118576) in database ID 2 at offset 0xxxxxxx in file ‘xxxxx\tempdb.mdf’. Additional …
Most of us are familiar with the quick and easy right clicking on an agent job an select “Start job at Step…”, but what if you need to run a job on many servers how can you kick it off manually. But what if you want to just run a TSQL command to start a job rather than right clicking …
At Stedman Solutions, LLC, we recently had the opportunity to help out another client with a corrupt database, to completely recover all their data and remove all the corruption. In this specific scenario Microsoft had told them that their only options was to restore from a backup, but because the corruption had been there for a while before they noticed …
Yesterday I released the first update to Database Health Monitor in a couple of months. There were some new features and some fixed saved up that were released yesterday. I did however run into 2 small bugs that were quickly dealt with in version 2.8.0 and 2.8.1. With some quick bug reporting for a couple of super users, and some …
Here is a quick script that I find myself using frequently to find the largest tables on an entire SQL Server instance.
For years I have struggled to find a good way to do TSQL formatting. Here is a short video of how to simple TSQL cleanup and formatting using just SQL Server Management Studio (SSMS). This works on SSMS from SQL Server 2005, all the way up to the latest release of SQL Server Management Studio. It is not as nice …