Tag: SQL Server

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

Posted in SQL Server 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.  

Posted in Database Health 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

Posted in 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

Posted in Performance 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

Posted in Companero Conference 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

Posted in Podcast Tagged with: , , , ,

Pre-con at SQL Saturday Richmond in March – Emergency Preparation for Database Disasters

On March 18th I will be attending SQL Saturday 610 in Richmond Virginia and the day before I will be presenting a pre conference session covering half a day on Database Corruption and half a day on Disaster Recovery Planning.

Posted in Corruption, SQL Saturday Tagged with: , , , ,

Podcast Episode – The Long Awaited Index Episode

For a couple of months we have had requests on the SQL Data Partners Podcast to do an episode on indexing. It is my pleasure to announce that the Indexing episode (episode 81) was released today, well at lease half

Posted in Podcast Tagged with: , , , , , ,

Bellingham SQL Server Users Group – January 25th

On Wednesday January 25th at 6:00pm we will be hosting the monthly meeting of the Bellingham SQL Server Users Group. January SQL Server Users Group In-Person @ 709 West Orchard Drive #4 Bellingham, Washington 18:00 – 20:00 (UTC-08:00) Pacific Time

Posted in PASS Chapter Tagged with: , , , , ,

The On Call DBA For Corruption

  One of those services that I offer is on call help for DBA’s who encounter database corruption. Call me anytime 24/7 and as long as you are an existing customer, or we can work out a billing arrangement to

Posted in Corruption Tagged with: ,