Windows Subsystem for Linux (WSL) is a feature released by Microsoft in 2016 that allows us to install and manage multiple Linux distributions on our local Windows computer with ease. The latest versions of Windows comes with a set of […]
SQL Server Error: Database Cannot Be Opened. It Is in the Middle of a Restore.
Database [DatabaseName] Cannot Be Opened. It Is in the Middle of a Restore is a common error in SQL Server that can happen when you are trying to query, alter or drop a database while it’s still in the middle […]
SQL Server Script: User Permissions Audit
As a Database Administrator (DBA), managing and auditing user permissions is a crucial aspect of ensuring the security and integrity of a SQL Server environment. Having a script to check a user’s permissions quickly is key to day-to-day support as […]
Disabling Windows Firewall with PowerShell
In this blog post, we’ll dive into a specific scenario: disabling the Windows Firewall using PowerShell. It’s crucial to emphasize that this is a specific use case, as maintaining a robust level of security is paramount. The Windows Firewall serves […]
Installing and Configuring AWS CLI on Ubuntu
Ready to use Amazon Web Services (AWS) CLI on Ubuntu 20.04 or 22.04? Follow this guide for a quick walkthrough – from updating packages to running AWS CLI commands. Let’s dive in! Updating Local Packages on Ubuntu Before we begin, […]
Troubleshooting the “Index was out of range” Error in SSMS
This post is to share encounters with the “Index was out of range” error message while working in SQL Server Management Studio (SSMS), and to hopefully help you quickly resolve it error. If you get this error, your first troubleshooting […]