TSQL Script to Display Agent Job History
It can be a bit time consuming to work through the the SQL Server Management Studio (SSMS) user interface to check on the agent job… Read More »TSQL Script to Display Agent Job History
CTE to Split a String in a function SplitString
Back in 2012 when I was writing my Common Table Expressions book, I came up with the following CTE in a function to split a… Read More »CTE to Split a String in a function SplitString
SQL Server – sysmaintplan_logdetail
The check for excessive sysmaintplan_logdetail has be added to the Database Health Monitor – Quick Scan Report. If you haven’t had a maintenance plan to clean… Read More »SQL Server – sysmaintplan_logdetail
SQL Server – Cost Threshold For Parallelism
The check for Cost Threshold for Parallelism check has be added to the Database Health Monitor – Quick Scan Report. The Cost Threshold For Parallelism setting in… Read More »SQL Server – Cost Threshold For Parallelism
Database Health Monitor Quick Scan Report
With the updated release of Database Health Monitor yesterday, here is the updated list of documentation on the Quick Scan Report. All of the following… Read More »Database Health Monitor Quick Scan Report
SQL Server MAX DEGREE OF PARALLELISM
The check for MAX DEGREE OF PARALLELISM has be added to the Database Health Monitor – Quick Scan Report. The max degree of parallelism setting… Read More »SQL Server MAX DEGREE OF PARALLELISM
Database Health Monitor – Version 2.3 Released
With over 7500 downloads worldwide to date, I have just released the next installment of the FREE Database Health Monitor application.
Here what one person had to say about it “Excellent – It’s the first tool I open every morning to see what is going on in my production environment! Thanks for the great work!”
Download today:
Database Health Version 2.3 Release Notes
Released March 20th, 2016.
It has been about 3 months since the last release, and I have added several new features, and many bug fixes.
New Features
- Reducing the number of different database connections used by Database Health Monitor. Reusing existing connections where applicable.
- Backup Report
- Database restore script for the backups report now includes the “RESTORE HEADERONLY” option.
- Updated the restore script to include a FILELISTONLY option to check on file locations before restoring.
- Recent backups are now shown in green so it’s easy to see which databases have recent backups and which do not.
- Added column to show the size of the backup.
- CheckDB dialog: Added the instance name to the CheckDB dialog so that you can know which instance the CheckDB is being run against.
Beta release 1.2 of SchemaDrift – the database schema comparison tool
Today I released another beta release of SchemaDrift. Part of this release was some redesign of the main screen, as shown here. I had some great… Read More »Beta release 1.2 of SchemaDrift – the database schema comparison tool
Sync your database with source control
SchemaDrift is a tool that I have created to compare the schema between two databases. It can also compare (and save) the schema to a… Read More »Sync your database with source control
Recommendation
The video shown here is entirely unsolicited feedback from a client that I had the opportunity of working with recently on a SQL Server performance assessment.… Read More »Recommendation