While doing a recent server move, I came across the need to script all agent jobs and save them to a file so that if we needed to reference what was there after the move we could get at the agent jobs without having to restart the old SQL Server. It made me realize that sometimes what you want to …
Script all Agent Jobs Using SQL Server Management Studio Read more »
Yesterday I had the opportunity to practice one of my sessions on Backup and Restore that I will be presenting at PASS Summit this year. I presented it at two different SQL Server Users Group meetings, one in Bellingham WA, and one in Hartford CT. The one in Hartford was a remote presentation. This is an introductory level presentation targeted …
This is an update to Visualizing VLFs – A while back a wrote a blog post with a query to Visualize the VLF’s in your database. Today I have an update to that script. The previously updated script added another column called “TextStatus” to the output to give you a better idea of what the different statuses mean. You now …
SQL Server 2017 introduces a new column in the sys.dm_db_file_space_usage system table. The column is modified_extent_page_count, which tells how many pages have been modified in your data file since the last full backup. What is really interesting about this is that with a little math you can calculate the percentage of your data file that has been modified. This would be useful …
Determining how much of your data file has been modified Read more »
It appears to be my lucky day. Who would have thought that someone I don’t even know would want me to invest $48,000,000 for them. Wow it is so exciting. ok… now that I am through the sarcasm, I am just logging this to share some of the crazy scams that we come across every day. Sorry Anthony Martinez, …
In a perfect world, your SQL Server would be so secure that you would not need antivirus software, you would have behind layers of firewalls, nobody would ever connect with remote desktop to install anything, and it would always have all of the latest security patches… But that is not the real world. Given that your SQL Server often times …
Over the years developing Database Health Monitor I have added a number of keyboard shortcuts to make life easier when working in the application. Some of these are listed here to share since they are not all completely obvious. Backspace Key – Jump to the last report viewed The Backspace key can be used to jump to the previous …
I am excited to announce that 2 of the sessions that I proposed for PASS Summit 2017 have been accepted. This is the first year that I have had 2 sessions accepted for Summit, and I am looking forward to it. The two sessions are: Basics of Database Corruption Repair Your database is running fine month after month with no …
Today I released the June 2017 version of Database Health Monitor, you can get it on the download page at http://DatabaseHealth.com. Here is what it included. Version 2.5.5 Release Notes Version 2.5.5 is the June, 2017 release of Database Health Monitor New Features in 2.5.5 Added a Recovery Model column to the Backup Status Report based on a customer request. …
Database Health Monitor June 2017 Version Released Today Read more »
Today I had the opportunity to release the May 2017 update of Database Health Monitor. This release is version 2.5.4. There are some new cross-instance reports available to allow you to check on your backup and CheckDB work on all of the instances that you are connected to with Database Health Monitor. Version 2.5.4 Release Notes – May, 2017. Version …
Database Health Monitor – May 2017 version released today Read more »