by Marcin Gminski | Jul 29, 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 | Jul 22, 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 | Jul 15, 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....
by Marcin Gminski | Jul 8, 2021
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...
by Marcin Gminski | Jul 1, 2021
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...
by Marcin Gminski | Jun 24, 2021
In the previous post, I have explained how to configure SQLWATCH To send simple, plain text notifications to Microsoft Teams. How to send notification to Microsoft Teams Today, we are going to look at how to send formatted cards: Microsoft Teams Cards Action templates...
