I lot of you have asked me to expand on the automated SQL Server installation I mentioned in my previous article: dbatools is a free PowerShell module with over 500 SQL Server best practice, administration, development and migration commands included https://dbatools.io/ The dbatools team have spent long hours making sure
Being able to run virtual machines on our local computers, whether for testing or development is very convenient and almost natural. Hyper-V is part of Windows and is an obvious choice for many. The main advantage is that it’s free. And that’s about it. This post is based on recent
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, time-consuming tasks as I either have to build a new SQL
In my previous 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 all.
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. Remote ISE Even though we need physical
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 of scrambling original data using an
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: What you
Mental health is now important more than ever. Join one of the 42 virtual sessions on the May 2nd, 2020 and listen to Tracy Boggiano speak about mental health and wellness in IT. One in four Americans suffers from a mental health challenge each year. In the tech community, this