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...