Blog Posts
-
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…
-
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…
-
Reinstalling a WSL Disto
This post is a guide on how to reinstall WSL (Windows Subsystem for Linux) via command. This may be useful if you are looking to clear down and start a up fresh WSL instance, treating it as a throw-away environment. You should have any WIP code backed up…
-
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…
-
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…
-
“.ps1 cannot be loaded because running scripts is disabled on this system” PowerShell Error
When attempting to run a PowerShell script you may receive the following error: cdk.ps1 cannot be loaded because running scripts is disabled on this system. For more information, see about_Execution_Policies at https://go.microsoft.com/fwlink/?LinkID=135170 This post is here to help you resolve this issue. The reason this is happening is…
-
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…
-
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 should hopefully help you when you need to check the status of SQL Services…
-
Testing Connectivity to Remote Server Ports with PowerShell
All admins need a tool to test connectivity to remote servers on TCP ports. In Windows, this is commonly done using PuTTy or PowerShell. This post is a note on my favourite way of testing remote TCP connections in Windows, which is using PowerShell:> Check a Port is…
Useful SQL DBA Scripts
Performance
– Quick Performance Troubleshooting Scripts
– Get Current User Activity & Blocking
– Get Wait Stats & Top Consuming Queries
– Get Database Sizes & Space Used
– Identify Missing & Unused Indexes
High Availability
– Get Always On Availability Group (AAG) Latency
– Get Mirroring Status & Latency
– Get Replication Latency
– Get Last Node Blip in SQL Server FCI
Maintenance
– Get Estimated Database Backup/Restore Time
– Get Last Database Backup Dates/Times
– Get Index & Heap Fragmentation Levels
– Get Table Sizes in SQL
Security & Auditing
– Get SQL User Permissions and Roles
– Creating SQL Users on Availability Groups
– Audit Failed Login Attempts
Categories
– AWS
– DBA Stories
– Linux
– MySQL
– Other
– Postgres
– PowerShell
– Redshift
– SQL Server
– Windows Server
Tags
Always On Availability Groups (AAG) (3) Certificates & Encryption (3) Change Data Capture (CDC) (2) Database Admin (71) Database Backups & Recovery (12) Database Mirroring (2) Deleting Data (1) Error Messages (4) 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 (4) SQL Server Database Files (1) SQL Server Data Types (2) SQL Server Management Studio (SSMS) (14) SQL Server Network Connectivity (2) SQL Server on Linux (1) SQL Server Patching (2) SQL Server Performance (5) SQL Server Permissions (1) SQL Server Processes (5) SQL Server Replication (1) SQL Server Scripts (12) Windows Admin (21) Windows Authentication (2) Windows Automation (1) Windows Events (2) Windows Firewall (4) Windows Subsystem for Linux (WSL) (20)