Add colours to the ERRORLOG

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

Ransomware and SQL Server – how to protect data

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

How to read large SQL Server ERRORLOG (the 5GB test)

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

Database Development in Visual Studio

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

SQL Agent Jobs Timeline with dbatools.io (download)

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

Move data to Azure Archive Storage using PowerShell

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

TSQL Tuesday #127 – Non SQL Tips and tricks

This month’s T-SQL Tuesday is hosted by Kenneth Fisher and is quite interesting as it has nothing to do with T-SQL. Here’s my very short contribution Multi-line typing with Alt Mind blowing hack that works in majority of text and code editors. Press Alt...

T-SQL Tuesday #126 – [email protected]

This is my first T-SQL Tuesday contribution! If you are new to this concept, as I was, you can read more about it on the T-SQL Tuesday homepage. This month’s invitation is from Glenn Berry. You can read more about the invitation by clicking on the logo below:...