Around a year ago I put together this free Ransomware Awareness course. It is one of those things that I felt so strong about because I had seen so many small (and large) business being impacted by ransomware. If I can give this course away and prevent just one ransomware course, it has bene worth it. In the last couple …

Free Ransomware Course – Everyday Value Read more »

It has been a long day, but I was able to get the latest Beta release of Database Health Monitor out. If you haven’t heard of Database Health Monitor monitor before, here is the quick rundown. It is a set of performance monitoring reports and tools to help you get more performance out of your SQL Server. Database Health Monitor is a project that …

Database Health Monitor Beta 10.2 Released Today Read more »

The following DBCC commands are all hidden in the word search.  Be aware, some of the DBCC commands are undocumented. CACHESTATS CHECKCATALOG CHECKCONSTRAINTS CHECKDB CHECKFILEGROUP CHECKIDENT CLEANTABLE DROPCLEANBUFFERS FLUSHPROCINDB FREE FREEPROCCACHE FREESESSIONCACHE FREESYSTEMCACHE INDEXDEFRAG OPENTRAN OUTPUTBUFFER PAGE PROCCACHE SHOWCONTIG SHRINKDATABASE TRACEON TRACESTATUS UNPINTABLE UPDATEUSAGE USEROPTIONS END OF PUZZLE ————————- See also: For more information on DBCC Commands: DBCC CheckAlloc DBCC …

SQL Sunday Fun – Word Search with SQL Server DBCC Commands Read more »

Today, the Database Health Reports had its 400th download.  I would like to say thank you to everyone who is using the product, and an extra thank you to those who have provided me with feedback. Here is a history of the Database Health Report project, http://databasehealth.com/about. My Goal:  I would like to provide the Database Health Reports project for free to as many people …

Over 400 downloads of the database health reports. Read more »

Today, the Database Health Reports had its 300th dowload.  I would like to say thank you to everyone who is using the product, and an extra thank you to those who have provided me with feedback. Since I started  planning the Database Health Reports a year and a half ago, until the latest download release on January 10th, 2013, it …

Over 300 Dowloads of the Database Health Reports Read more »

In preparation for an upcoming SQL Saturday presentation I have created another report to add to the FREE SQL Server Health reports project. This report has been replaced with the Backup Report in the Database Health Project. The Backup Set Report has been added to the SQL Health Reports.  The Backup Set Report  is the 7th report to be added to the Database …

Backup Set Report added to FREE Server Health Reports Read more »

In preparation for a SQL Saturday presentation I have created another report to add to the FREE SQL Server Health reports project.   The Database Size Report has been added to the SQL Health Reports.  The Database Size Report  is the 6th report to be added to the Database Health Reports package. The Database Health reports package is a FREE …

Database Size report added to SQL Health Reports Read more »