This post is a curated collection of top-notch interview questions tailored for Database Reliability Engineer (DBRE) applicants. Whether you’re a seasoned DBA refining your expertise, an interviewer on the quest for valuable questions, or a hopeful candidate gearing up for […]
PowerShell Script: Count Rows in CSV Files
Are you dealing with CSV files and in need of a quick row count using PowerShell? Look no further! In this post, we’ll guide you through a script that effortlessly counts rows within multiple CSV files. Count Rows in Multiple […]
Open SSMS With a Different User
When dealing with SQL Server within a corporate setting, there might be instances where connecting to the server requires the use of a different Domain User account. This scenario is common, especially when testing access and permissions for newly created […]
PowerShell Guide: Deleting Files and Folders
If you find yourself needing to delete files in PowerShell, especially as part of a Windows script, this post is for you. Below, we cover various aspects of file deletion using PowerShell, ranging from deleting individual files to removing entire […]
How to Increase Maximum Characters Displayed in SSMS
In SQL Server Management Studio (SSMS), the default maximum number of characters retrieved in a column when using Results to Text is 256 characters. This means if you have a column containing more than 256 chars the output will be […]
Removing Quotes from CSV Files in PowerShell
In this blog post, we are going to share a script that will help you remove quotes from CSV files using PowerShell. First, we are going to create a new test CSV File in our PowerShell Terminal for the demo, […]