Version 4.1 is now available

Contributors @marcingminski and @tarmstrong24 Features Change to parse job name and replace binary value with Job Name (#313 by @marcingminski)Added default ERRORLOG keywords that are worth monitoring. (#319 by @marcingminski)Improvements...

What’s new in version 3

Version 3 of SQLWATCH brings several, long-awaited features that should make your SQL Server monitoring easier and better. Grafana Dashboard The history of SQLWATCH goes back to around 2010, when it was just a bunch of scripts and agent jobs for ad-hoc performance...

Negative identities

The identity value in relational databases is a field that increases automatically. It is often used to create surrogate primary keys. Surrogate keys Surrogate keys are meaningless and are only used to uniquely identify the row, not the data itself. For example,...

How does monitoring affect your server?

The observer effect is a term used in physics and it means that observing a phenomenon changes that phenomenon. Therefore, an object that is being observed, is looking different to the same, not observed object. How is this possible? In physics, this is to do with...

SQLWATCH needs your help #SQLFamily

Hey SQLWatchers, First of all, thank you for the growing community and for using SQLWATCH. SQLWATCH has reached over 10000 downloads. This does not include source code downloads and offline installations. I am myself aware of many places that download the release or...

How to send notifications to Slack

Some time ago we discussed how to send notifications to Microsoft Teams: How to send notification to Microsoft Teams In this post, we are going to look at doing the same with Slack. The only difference between these two platforms is in the payload they expect. Beyond...

Deploy SQLWATCH with dbatools

I am happy to announce that thanks to our fantastic SQL Server Community it is now possible to deploy SQLWATCH using dbatools. If you work with SQL Server and are not familiar with dbatools you should check it out now, it will change your DBA life forever. With...

How to send notification to Microsoft Teams

I have been meaning to write how to integrate SQLWATCH with different platforms for a long time. Recently a very kind person bought me a coffee and said they have implemented Microsoft Teams integration which motivated me to finalise it. Hi Marcin,  love your...