Category: Windows Server Admin
Windows Server Admin blog which includes guides to boost performance and efficiency, written by an experienced Microsoft SQL DBA, Peter Whyte.
-
How to Enable Windows Firewall using PowerShell
Windows Firewall is an essential security feature that protects your system from unauthorized access and threats. If it has been disabled for testing or mistakenly turned off, you can quickly re-enable it using PowerShell. This guide provides a straightforward process to restore your firewall settings and ensure a…
-
How to Disable Windows Firewall with PowerShell
This post provides a demo on how to disable Windows Firewall with PowerShell on a Windows computer. ⚠ Important: Disabling the Windows Firewall is not recommended as it reduces your system’s security. However, there are scenarios, such as troubleshooting, where temporarily disabling the firewall may help identify if…
-
The Best Terminal for Windows
This is a post to share an opinion on the best Terminal for Windows, which is Windows Terminal. The easiest way to install Windows Terminal is by following this link which takes you to the Microsoft Store, we can one click download/install from there. Windows Terminal is installed…
-
How to Reboot WSL (Windows Subsystem for Linux)
To restart WSL simply, run wsl –shutdown to stop your WSL distros, then enter back into WSL distro as normal to start it back up again. This post contains a guide to help explain the process. A WSL reboot might be needed if your WSL instance or app…
-
How to Restart Windows Subsystem for Linux (WSL)
If your Windows Subsystem for Linux (WSL) instance encounters errors or you’ve updated the .wslconfig file (e.g., to modify memory limits), restarting your WSL distributions may be necessary. This guide demonstrates two effective methods for restarting WSL distributions: > (Preferred Approach) Run the WSL –Shutdown Command > (Old…
-
How to Upgrade WSL from Version 1 to Version 2
This guide explains how to upgrade your Windows Subsystem for Linux (WSL) distribution from Version 1 (WSL 1) to Version 2 (WSL 2). WSL supports two versions: the original WSL 1 and the more advanced WSL 2. You can install multiple Linux distributions on your system and easily…
-
How to Downgrade from WSL Version 2 to WSL Version 1
In certain development or system administration scenarios, you may need to downgrade your Windows Subsystem for Linux (WSL) distribution from WSL version 2 (WSL 2) to version 1 (WSL 1). While WSL 2 brings many enhancements, such as a real Linux kernel and better performance, there are times…
-
How to Open WSL Projects in Windows File Explorer
If you work with Windows Subsystem for Linux (WSL), you may need to open WSL files in Windows File Explorer for easier file management. This post gives some tips, providing two simple methods to achieve this. Best Practices for Managing WSL Project Files For optimal performance, always store…
-
How to Change Your Default Distro in WSL
Changing the default Windows Subsystem for Linux (WSL) distribution is simple. This guide shows you how to list your installed distros and set a new default using just a couple of commands. 1. Listing Installed WSL Distributions Before setting a new default, check which distributions are installed on…
Useful SQL DBA Posts
SQL Server Performance
– Get Full SQL Server System Info Fast
– Quick Performance Troubleshooting Scripts
– Identify Missing & Unused Indexes
– Get Wait Stats & Top Consuming Queries
– Get Exclusive Locks on Tables
– Get Last Node Blip in SQL Server FCI
Security & Maintenance
– Get Estimated Database Backup/Restore Time
– Get Last Database Backup Dates/Times
– Get Database Sizes & Space Used
– How to Get Table Sizes
– Get Index & Heap Fragmentation Levels
– Get SQL User Permissions and Roles
– Creating SQL Users on Availability Groups
– Audit Failed Login Attempts
Categories
Tags
Always On Availability Groups (AAG) AWS AWS Redshift Certificates & Encryption Change Data Capture (CDC) Database Admin Database Backups & Recovery Database Mirroring Deleting Data Error Messages Git Commands Importing & Exporting Data Linked Servers Linux Admin Logging & Monitoring Measuring Databases Microsoft Patching MySQL Postgres PowerShell Scripts SQL Server Agent SQL Server Database Files SQL Server Data Types SQL Server Management Studio (SSMS) SQL Server Network Connectivity SQL Server on Linux SQL Server Patching SQL Server Performance SQL Server Permissions SQL Server Processes (SPIDs) SQL Server Replication SQL Server Scripts Windows Admin Windows Authentication Windows Automation Windows Events Windows Firewall Windows Subsystem for Linux (WSL)