SQL DBA Blog

  • Install Git on Windows

    This is a post on how to install Git (version control system) on a Windows computer. For more information have a look at the git-scm page, which is where we can download the client. There are a lot of configuration options throughout this wizard install, but there is…

    Read More

  • 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…

    Read More

  • Access Local Files from Windows Subsystem for Linux (WSL)

    Accessing local Windows files from a WSL distribution allows integration between workflows, our local Windows environment and (WSL) Linux environments. This is done by navigating to the /mnt/c/ directory within your WSL Linux terminal. Alternatively, you can enter WSL directly from any Windows directory using a terminal. Both…

    Read More

  • Reinstalling WSL Distributions

    This guide walks you through reinstalling a WSL (Windows Subsystem for Linux) distribution via command line. This can be useful if you want to reset your WSL environment for a fresh start. Before proceeding, ensure you back up any important work to Git or another storage solution. 1.…

    Read More

  • Enable Windows Subsystem for Linux (with Ubuntu 18.04)

    WSL allows Windows users to develop and run applications within a GNU/Linux environment. Previous to this feature release we needed VM’s or a dual boot setup. For more information, as always have a look at the Microsoft Docs. There’s a huge amount of tutorials and documentation on this…

    Read More

  • Removing Quotes from a CSV File with PowerShell

    This post explains how to remove quotes from a CSV file using PowerShell, a common requirement when working with CSVs that include unnecessary or problematic quotes. Whether you’re cleaning up data for easier processing or addressing formatting issues caused by quotes, this post will show you how to…

    Read More

  • “.ps1 cannot be loaded because running scripts is disabled on this system” PowerShell Error

    Encountering this error? It’s caused by restrictive execution policies that block scripts for security reasons. This guide explains the issue and provides actionable solutions. PowerShell restricts script execution by default. Running a script like my example cdk.ps1 may trigger the following error message: Script.ps1 cannot be loaded because…

    Read More

  • Creating a Linked Server with a MySQL Database

    This is my 3rd Linked Server demo post, and this time it’s to a MySQL database. Noteworthy weblinks: > My Linked Server Blog Posts > Microsoft Docs – Linked Servers Here is a simple diagram of the setup in this post. The above was setup similar to what’s…

    Read More

  • Check & Restart SQL Server Services on Linux

    As of the 2017 Edition of SQL Server we have been able to install SQL Server on Linux. Linux will likely be more of an unfamiliar environment for traditional Microsoft SQL DBAs. This guide will walk you through how to check the status of SQL Server services and…

    Read More

  • “Changing the Primary Domain DNS Name of this Computer Failed” – Server 2008 R2

    Within an AWS account I have a Windows Server 2016 Domain Controller, and I’m trying to join a Windows Server 2008 R2 to my Whyte.net Domain. I get this error: Changing the Primary Domain DNS name of this computer to “” failed. The name will remain “whyte.net”.The error…

    Read More

Useful SQL DBA Posts

Performance & High Availability
– 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 Always On Availability Group (AAG) Latency
– Get Mirroring Status & Latency
– Get Replication Latency
– 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

– Microsoft SQL Server
– Windows Server
– PowerShell
– Linux & WSL
– Other

Tags

Always On Availability Groups (AAG) (4) Certificates & Encryption (3) Change Data Capture (CDC) (2) Database Admin (76) Database Backups & Recovery (14) Database Mirroring (2) Deleting Data (1) Error Messages (5) Git Commands (5) Importing & Exporting Data (2) Linked Servers (3) Linux Admin (2) Logging & Monitoring (1) Measuring Databases (10) Microsoft Patching (2) PowerShell Scripts (1) SQL Server Agent (5) SQL Server Database Files (1) SQL Server Data Types (2) SQL Server Management Studio (SSMS) (15) SQL Server Network Connectivity (3) SQL Server on Linux (1) SQL Server Patching (2) SQL Server Performance (5) SQL Server Permissions (2) SQL Server Processes (5) SQL Server Replication (2) SQL Server Scripts (13) Windows Admin (21) Windows Authentication (2) Windows Automation (1) Windows Events (2) Windows Firewall (4) Windows Subsystem for Linux (WSL) (19)