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 Install and Configure AWS CLI on Windows
This post is a how-to for installing & configuring AWS CLI (Version 2) on Windows. In this guide, we’re going to download the AWS Command Line Interface installation media and run through the simple installation. Once done we’ll configure AWS CLI, which you’ll need an AWS Account to…
-
How to Install Ubuntu 20.04 on WSL
This guide shows how to install Ubuntu 20.04 on WSL (Windows Subsystem for Linux). Before installing a WSL Linux distribution you should have already enabled WSL on your computer. All WSL Linux distributions are available for download in the Microsoft Store. This is the easiest way to install…
-
How to Set Default WSL Distribution
This guide contains a demo on how to set the default Windows Subsystem for Linux (WSL) distribution on a Windows computer. This is particularly useful if you have multiple WSL distributions installed and need to manage various Linux environments on Windows. Contents:> Check Installed WSL Distros. > Set…
-
How to Install Windows Terminal
Windows Terminal (WT) is a modern command-line application for Windows that supports various shells such as PowerShell, Command Prompt, and Windows Subsystem for Linux (WSL). It offers a rich user experience with features like tabs, panes, and a customizable interface. Other benefits of Windows Terminal include Unicode /…
-
How to Install Chocolatey on Windows
This blog post is here to help you for installing Chocolatey on Windows using command (PowerShell). Chocolatey allows you to manage software packages on your system with simple ‘choco‘ commands. It also comes with the optional Chocolatey GUI app which helps manage local software versions making it easy…
-
How to Change Git Remote URL to SSH from HTTPS
This guide walks you through changing your Git authentication method from HTTPS to SSH. Using SSH eliminates the need to enter a password each time you interact with a remote repository. Before proceeding, ensure you have SSH keys set up. If you haven’t done this yet, check out…
-
Setting up SSH Keys in WSL
Setting up SSH keys on Windows is generally done via OpenSSL or Putty. We can set this up and have quick authentication to places like GitHub or Bitbucket. But, we are also able to rely on a Linux distro in WSL for our SSH. If you are developing…
-
How to Install Git on Windows
This guide walks you through installing Git, the version control system, on a Windows computer. For the latest version, visit the official Git website to download the installer. Although the installation wizard offers numerous configuration options, don’t worry, most settings can be adjusted later. Even if something goes…
-
Create a Link Between Local Windows Files and WSL
Creating a link between local Windows files and WSL (Windows Subsystem for Linux) is a useful way to share files between the two environments. In this guide, I’ll show how to link a folder in Windows to your WSL instance using the ln command, and also explain how…
Categories
- Linux & WSL (26)
- Microsoft SQL Server (103)
- Other (13)
- PowerShell (50)
- Windows Server Admin (44)
Tags
Always On Availability Groups (AAG) (4) AWS (4) AWS Redshift (6) Database Admin (72) Database Backups & Recovery (14) Database Mirroring (2) Error Messages (5) Failover Cluster Instances (FCI) (1) Git Commands (6) Importing & Exporting Data (2) Linked Servers (3) Linux Administration (2) Logging & Monitoring (1) Microsoft Patching (2) MySQL (4) Postgres (6) PowerShell Scripts (2) SQL Certificates & Encryption (3) SQL Server Agent (5) SQL Server CDC (2) SQL Server Data Types (2) SQL Server Management Studio (SSMS) (17) SQL Server Networking (3) SQL Server on Linux (1) SQL Server Patching (2) SQL Server Performance Tuning (6) SQL Server Processes (SPIDs) (7) SQL Server Replication (2) SQL Server Scripts (13) SQL Server Security (4) SQL Server Storage (10) Windows Admin (20) Windows Authentication (2) Windows Automation (1) Windows Events (2) Windows Firewall (4) Windows Subsystem for Linux (WSL) (18)