by Marcin Gminski | Apr 6, 2021
As a DBA, developer, and more importantly the creator of SQLWATCH.IO, I need the ability to rapidly deploy and test different SQL Server configurations or test different upgrade variations from one version of SQLWATCH to another. This is quite laborious,... by Marcin Gminski | Mar 30, 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 | Mar 23, 2021
When dealing with large logs I often find it difficult to find the information we are looking for. To make it easier, we can use PowerShell to add colours the ERRORLOG based on string patterns Note this will only work when using the Select-String command.... by Marcin Gminski | Mar 16, 2021
What is ransomware Ransomware is a type of malicious software that locks access to user files until a ransom is paid. Quite common “locking mechanism” is by encrypting all files on a user computer, server or even the entire network. Encryption is a process... by Marcin Gminski | Mar 9, 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 | Mar 2, 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 | Feb 23, 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... by Marcin Gminski | Feb 16, 2021
Concept You may have come across a term multi-tiered storage. This means, that the storage solution has multiple arrays, fast and expensive and slow but cheap. Files accessed very frequently are stored on very fast SSD disks, files accessed less frequently are stored... by Marcin Gminski | Feb 9, 2021
Abstract PowerBI Desktop is a data analytics and presentation tool. Defining data sets is very easy and usually involves creating connection string to the source data and defining objects to pull data from. Alternatively, for SQL databases we can write custom SQL... by Marcin Gminski | Feb 2, 2021
As data professionals, we often need test data, whether for functional testing, to satisfy business logic criteria or for non-functional, to satisfy performance requirements. We must also not store any sensitive or personal information in non-production systems and...