Get a full script and explanations on how to monitor Always On stays always on and its synchronization process

The issue I played today with my local SQL Server 2019 instance, and by mistake, set a MAX Server memory to 128MB. Actually, I have set...

In today's post, we'll create a solution to automatically alert us when a SQL Server monitored by SentryOne becomes outdated.

Here is a script that searches for a certain string inside the code of all programmatic objects in the current database...

Download the session materials from my presentation at the Data Platform Summit 2020.

Here is a procedure that can print a text of any size, even greater than 8,000 bytes, which is the limit of the regular PRINT statement.

What happens in SQL Server when you concatenate strings? You might be surprised...

The purpose of unit testing in software development is to validate that each unit of the software performs as designed. It is usually...

Last week I presented a session as part of the GroupBy event about Working with Very Large Tables Like a Pro in SQL Server 2019.

Data compression can save storage space and improve performance. But in some cases, it may cause more harm than good. Read to learn more.