Do you know what to do when corruption hits? You should watch this quick 10 min video first if you plan on fixing it yourself? Steve Stedman and Derrick Bovenkamp wants to save you from making a big mistake. In this video they will share the Do’s and Do Nots when faced with a database corruption. And we are always …
Your Database is Corrupt – Here’s Your “Now What?” Video Read more »
I added a new report to the daily monitoring email, showing the error log over time. What is interesting about this is that it is tracked by hour, so if there is something that changes on your system that suddenly caused many more error log entries to be written, it will show up here. This enhancement came from me trying …
On the SQL Daily Checkup report I have added a new report section called news which we can use to show new features related to the daily checkup email. We provide monitoring tools that alert us when there is an issue so that we can recommend fixes before the issue becomes a bigger problem. The notification runs every hour and …
Anyone who’s experienced database corruption knows they do not want it to happen again. Corruption repair is stressful and could require money and downtime you can’t afford. In some cases, there is no “repair” just rebuild. Unfortunately, no database is immune from server corruption, but there are certain alerts and specific practices that when implemented will greatly lessen the impact …
Occasionally you need to take inventory of how much free space each database has. You can find this quickly and easily in Database Health Monitor, but if you want to get it programmatically you can do it with the following query. This query has been tested on SQL Server 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017, and 2019. This …
The following is chapter 7 from my Common Table Expressions book in its entirety. I can remember the first time that I worked on data paging code. I had to page through web site search results 20 at a time on a given web page. My task was to understand how it had been written and to do some bug fixing. After reviewing …
Steve Stedman and the Stedman Solutions Team celebrate the 10 year anniversary of Database Health Monitor. Kiana talks to Steve about this tool he built, how it’s evolved, why its useful and its plans for it in the future. Go to http://www.Databasehealth.com to download this free tool today! STEVE: This is the 10-year anniversary of database health monitor and it …
Here’s a quick and easy link to review all blog posts written by Steve Stedman in February 2021. Enjoy! SQL Server – Backing up a database Sat, 27 Feb 2021 If you are a pro at SQL server I am sure you already know how to backup a database, but for someone who is new to it, things can be …
The following is chapter 6 from my Common Table Expressions book in its entirety. READER NOTE: Please run the CTEBookSetup.sql script in order to follow along with the examples in this chapter. The script mentioned in this chapter is available at http://SteveStedman.com. Thinking of the proverb “two heads are better than one” makes me think, it really depends on the people. Two people working together are …
If you are a pro at SQL server I am sure you already know how to backup a database, but for someone who is new to it, things can be a bit overwhelming and confusing. This is especially confusing with the number of options that Microsoft has added into SQL Server Management Studio over time. We get called in quite …