by Marcin Gminski | Sep 7, 2021
This project has become so popular that I decided to give it its own home: SQLWATCH.IO. Thank you #SQLFamily! Introduction I often help improve the performance of a SQL Server or an application. Performance metrics in SQL Server are exposed via Dynamic Management... by Marcin Gminski | Jul 20, 2021
In my earlier post, I described different ways to read very large SQL Server Log (ERRORLOG) – 5GB – to be exact. However, this was a reaction to something that has already happened. In this post, I will show you how to prevent this from happening at... by Marcin Gminski | Jun 29, 2021
I often come across large ERRORLOG mainly because they are not being recycled frequent enough, or not at all. Sometimes, despite the frequent recycling, the ERRORLOG can grow to an unmanageable size. This has recently happened to me during a large transaction rollback... by Marcin Gminski | Jun 22, 2021
A lot of database administrators and developers like to use the SQL Server Management Studio to make changes to the database schema directly. As a production DBA, I can definitely say that there are situations where this is acceptable and even desired, however,... by Marcin Gminski | Jun 15, 2021
This is now part of dbatools.io and has more features! Go get the latest version and watch this space as there are more graphs to come! Concept Continuing from my previous post: SQL Server Performance Dashboard Using PowerBI, another important element of performance...