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 […]
PowerShell: ForEach Loop Examples
Looping is a foundational concept in PowerShell, integral to the very essence of programming. It becomes essential in various scenarios where we need to process one object at a time within an array or collection of objects. According to Microsoft’s […]
PS1 cannot be loaded because running scripts is disabled on this system
Encountering the error message “PS1 cannot be loaded because running scripts is disabled on this system” in PowerShell can be a roadblock in your scripting or development. It’s a common error in PowerShell while attempting to run a command. This […]
RAND() vs. NEWID() in SQL Server
The quest for randomness in SQL Server leads us to two prominent players: RAND() and NEWID(). This blog post shows examples of both functions, exploring their capabilities, use cases, and the subtle distinctions that set them apart when generating random […]