Tag: SQL Server

Microsoft SQL Operations Studio

Today at PASS Summit Microsoft announced a new SQL “Tool” for running queries against SQL Server, called the Microsoft SQL Operations Studio. So what is the Microsoft SQL Operations Studio This appears to be a new cross platform (Mac, Linux,

Tagged with: ,

Database Health Monitor October 2017 Version Released Today

With over 2000 downloads since the last updated to Database Health Monitor, I figured it was time to get another release of the product out. New Features in 2.6 Added a Job Schedule instance level report. Added an option on

Tagged with: , , , , , , ,

Script all Agent Jobs Using SQL Server Management Studio

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

Tagged with: , , ,

Backup and Restore – Pass Chapter Presentation

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,

Tagged with: , , , , ,

Using Antivirus with SQL Server

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

Tagged with: , , ,

Database Health Monitor Keyboard Shortcuts

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.  

Tagged with: , , ,

Database Health Monitor June 2017 Version Released Today

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

Tagged with: , , , , , , ,

DBCC FREEPROCCACHE – What is the impact.

Here is a question that I received from a friend today and I thought it would be a good post explaining the details: Steve, I have a question on DBCC FREEPROCCACHE.  I used sp_blitzcache from Brent and it shows that

Tagged with: , ,

I’m Presenting at the Compañero Conference In October

I am excited to announce that I will be speaking at (and helping organize) the SQL Conference called Companero Conference in Norfolk VA on October 4th and 5th 2017.   SQL Server Conference for the Accidental, Lone or New DBA The

Tagged with:

Podcast Episode 91: DBA Tools – Listen and find out what you are missing.

Today Episode 91 released and it is our pleasure to present this episode on DBA Tools.  DBA Tools is an open source project (http://DBATools.io) that provides a number of powershell scripts to better help the DBA perform common SQL Server

Tagged with: , , , ,
Top