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 […]
SQL Server: Get Current Date
In this blog post, we’ll explore various methods to retrieve the current date using SQL Server commands. Get Current Date & Time in SQL Server GETDATE(): Get Precise Date & Time in SQL Server SYSDATETIME(): if you require a higher […]