by Marcin Gminski | Apr 15, 2021
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...
by Marcin Gminski | Apr 8, 2021
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...
by Marcin Gminski | Apr 1, 2021
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...
by Marcin Gminski | Mar 25, 2021
I get a lot of emails with concerns that some of you have very strict security and locked-down environments which prevent you from installing SQLWATCH. At the same time, some of you would have preferred the central repository to connect directly to the remote instance...
by Marcin Gminski | Mar 18, 2021
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,...
by Marcin Gminski | Mar 11, 2021
I recently came across a tweet by Brent Ozar who touched on a very important aspect of performance monitoring. A subject that is not always well understood and can lead to misleading results. The impact of aggregation on granularity and thus observability....