SQL Server DBA Blog posts, organised with information on Database Admin, SSMS, PowerShell and Windows Admin tips. This page will be updated frequently.

All blog posts linked below are internal links created by myself, a SQL DBA living the dream of being able to combine a love for database software and blogging.

My high-level blog categories include the following:
– MS SQL DBA
– SSMS Tips
– PowerShell Tips
– Windows Admin
– WSL
– Linux Tips
– Git Tips
– AWS Tips

MS SQL Blog

MS SQL DBA

Move Temp DB SQL Server
October 20, 2022
How to Check SQL Server Version
October 6, 2022
Adding Columns to a Table in SQL Server
September 6, 2022
Add a Filegroup to a Database in SQL Server
September 1, 2022
Disable Change Data Capture (CDC) in SQL Server
August 30, 2022
How to Enable CDC in SQL Server
August 29, 2022
SQL Server Default Port
August 26, 2022
How to Rename a Computer that Hosts SQL Server
August 23, 2022
Get All Database Sizes in SQL Server
August 20, 2022
How to Backup a SQL Server Database
August 19, 2022
Get Estimated Backup Restore Time in SQL Server
August 18, 2022
Drop Table if Exists in SQL Server
July 26, 2022
Get Last Database Restore DateTimes in SQL Server
July 23, 2022
List All SQL Agent Jobs on a SQL Server Instance
July 21, 2022
How to Restore a Database in SQL Server
July 19, 2022
What’s New in the SQL Server 2022 Install
May 29, 2022
Why Use WHERE 1=2 in a SQL Query
May 5, 2022
Why Use WHERE 1=1 in a SQL Query
September 21, 2020
Check & Restart SQL Server Services On Linux
July 14, 2020
Installing SQL Server On Linux
April 27, 2020

SSMS Tips

SSMS Maximum Characters Displayed
September 12, 2022
SSMS Show Line Numbers
September 3, 2022
How to Connect to SQL Server with a Different Domain User Account
August 25, 2022
USE Command in SQL Server
November 25, 2020
Change Default Database in SQL Server
November 23, 2020
Disk Usage by Top Tables Report in SQL Server
October 4, 2020
Include Execution Trace Messages in SQL Server Error Logs
May 5, 2020
“Index was out of range” SQL Server Management Studio
April 15, 2019
The (SSMS) Import Flat File Feature
January 24, 2019
Using Custom Connection Colours in SSMS
October 22, 2018
Exporting SQL Server Query Results to CSV
October 2, 2018

PowerShell Tips

How to Delete Files in PowerShell
September 11, 2022
Create a New Firewall Rule with PowerShell
September 5, 2022
How to Check PowerShell Version on Windows
August 31, 2022
How to Automate PowerShell Scripts with Task Scheduler
August 28, 2022
SQL Server Default Port: Add New Firewall Rule with PowerShell
August 26, 2022
PowerShell Restart Services on Multiple Hosts
August 24, 2022
PowerShell ForEach Loop Examples
August 22, 2022
How to Check Windows Firewall Status with PowerShell
August 16, 2022
How to Enable Windows Firewall with PowerShell
August 15, 2022
How to Disable Windows Firewall with PowerShell
August 14, 2022
Best Terminal for Windows 2022
August 13, 2022
PowerShell Create Folder If Not Exists
August 12, 2022
Get-EventLog in PowerShell
October 30, 2021,
Get-Command in PowerShell
October 29, 2021,

Windows Admin

How to Automate PowerShell Scripts with Task Scheduler
August 28, 2022
SQL Server Default Port: Add a New Firewall Rule in Windows
August 26, 2022
How to Find Which Process is Listening on a Port in Windows
August 21, 2022
How to Check Windows Firewall Status with PowerShell
August 16, 2022
How to Enable Windows Firewall with PowerShell
August 15, 2022
How to Disable Windows Firewall with PowerShell
August 14, 2022
Best Terminal for Windows 2022
August 13, 2022

WSL (Windows Subsystem for Linux)

How to Reboot WSL (Windows Subsystem for Linux)
August 12, 2022
How to Upgrade WSL from Version 1 to Version 2
August 2, 2022
How to Downgrade from WSL Version 2 to WSL Version 1
August 2, 2022
How to Open WSL Projects in Windows File Explorer
July 27, 2022
How to Change Default Linux Distro in WSL
July 25, 2022
How to Install Postgres on Ubuntu 20.04 in WSL
July 22, 2022
How to Check WSL Versions
July 20, 2022
How To Install Windows Subsystem for Linux (WSL)
July 18, 2022
How To Change From WSL2 to WSL1
May 8, 2022
How to Reboot a WSL Distribution/Instance
May 4, 2022
How to Check WSL Versions
May 3, 2022
How To Install Ubuntu 20.04 On WSL
April 6, 2021
How To Unregister A Linux Distro In WSL
April 5, 2021
How To Set A Default Linux Distro In WSL
April 4, 2021
Setup SSH Keys In WSL
September 8, 2020
Create A Link Between Local Windows Files And WSL
September 6, 2020
Access Local Files From Windows Subsystem For Linux (WSL)
September 5, 2020
Reinstall A WSL Disto
September 4, 2020

Linux Tips

How to Check Linux Version in Ubuntu
July 29, 2022
How to Install Postgres on Ubuntu 20.04
May 2, 2022
How To Install & Configure AWS CLI On Ubuntu
April 8, 2021
Check & Restart SQL Server Services On Linux
July 14, 2020
Installing Firewalld On Linux
April 27, 2020

Git Tips

Git Log Show in One Line (–oneline)
May 17, 2022
Change Git Remote URL To SSH From HTTPS
September 28, 2020
“Config Lock Failed Operation Not Permitted” – Git
September 7, 2020