Today, we’re going to talk about one of the most important reports you can run in SQL Server Management Studio (SSMS) – the Disk Usage by Top Tables report. This report provides valuable insights into the size and usage of […]
Show Line Numbers in SSMS for Debugging and Coding Ease
If you’re a frequent user of SQL Server Management Studio (SSMS), you may have noticed that the query window doesn’t show line numbers by default. While this may not be a dealbreaker for some, having line numbers can be a […]
What is the USE Command in SQL Server?
This post is intended to help explain the USE command in SQL Server. In short, the USE command allows you to change the context or scope of the database you are currently working on for a SQL query. When working […]
PowerShell Guide: Creating Files and Folders
While the Windows graphical user interface (GUI) makes creating files and folders a simple task, PowerShell offers an efficient alternative for scripting and administrative needs. In this guide, we’ll explore essential commands in your PowerShell Terminal to streamline the process. […]
Restarting WSL Linux Distributions
While using Windows Subsystem for Linux (WSL), you may need to restart your WSL Linux distribution to make changes to the WSL config, or due to another random issues. To do this, we can simply run the wsl –shutdown -d […]
PowerShell Script: Create Multiple Test CSV Files
In this post we share a PowerShell script that generates multiple CSV files in the current directory, each containing a random number of rows with sample data. Please note that this script uses basic random data for illustration purposes, and […]