Earlier this week we released Version 994 release of Database Health Monitor with a number of new report formats that I have created and replaced several of the boring pie charts. Here are a few before and after comparisons between the pie chart and the tree view charts. Note how much better representation the size of tables are with the …
In the Version 994 release of Database Health Monitor this week there are a number of new report formats that I have created and replaced several of the boring pie charts. Here are a few before and after comparisons between the pie chart and the half-donut charts. One of the things I like is that on the new half donut …
February 2022 – Version 994 Release Notes The February 2022 release of Database Health Monitor includes bug fixes and feature enhancements. There is a massive amount of chart and visualization changes in this update. Here is an example of one of the new charts, the replaced a pie chart. My goal over the next several months will be to replace …
Database Health Monitor Version 994 Released Today Read more »
Click here to read Part 1 Click here to read Part 2 Incremental Method This method has a few names and is fairly simple to implement. It involves determining how long you wish to maintain a copy of your data and how many tapes you wish to use. It is based on labeling each backup with a number and then …
Here listed is the current percentages of SQL server versions running our Daily Check up with Database Health Monitor. Compare this month’s percentages to Last Month’s Percentages
Some typical corruption scenarios we see: SQL Server Won’t Start If you are in the situation where your SQL Server Won’t Start up, this can be a side effect of the database corruption, and we can help. DBCC CheckDB Errors Running CheckDB throws lots of errors in red text. This also applies to any of the DBCC checks like CHECKCATALOG, …
So you have a backup for your SQL Server but are you certain it’s good enough for your business needs? Are you 100% sure you’ve configured your backup and restore plan correctly? If you answered No or Maybe to either of these questions you should revisit your backup/plan or freshen up your resume. Yep, it can be dangerous operating a …
I was working with a client just the other day that has several SQL Server 2000 servers still in mission critical production environments, and a couple of newer versions of SQL Server 2005, 2016, 2019. Not often do I admit that I do still occasionally work on SQL Server 2000, and given that we are now in 2022, that makes …
SQL Server 2000 to SQL Server 2019 – What’s the difference? Read more »
25% OFF SQL Server Backup and Recovery Course Coupon Code: BACKUPFEB Expires: February 28th at 11:59pm This complete course will help you determine if you have a sufficient backup strategy and restore plan OR will help you build one from scratch.
If you have a SQL Server you must have a backup and restore plan. If you don’t you’re in for a rude awakening for sure. Backups are absolutely essential for your SQL Server protection from a dropped table to a ransomware attack. But building a backup strategy and restore plan can be daunting task if you’re new at it or …
Build a backup strategy and restore plan from scratch Read more »