The Query Store feature was introduced in SQL Server 2016 (13.x), which helps DBAs & Developers identify and resolve performance issues related to queries. In this blog post, we’ll share a simple SQL query that will show if Query Store […]
SQL Server Management Studio (SSMS) v20.0 Preview
SQL Server Management Studio (SSMS) Version 20.0 is now in preview release. Lets check it out! Microsoft Docs: Release Notes for SSMS 20 Preview 1 (Release date: February 29, 2024). Release Notes: Highlights: – Installation of SSMS also automatically installs […]
How to Install Firewalld on WSL Ubuntu
This post contains installation notes for installing firewalld on Ubuntu Linux running within Windows Subsystem for Linux (WSL). What is Firewalld? Firewalld is a tool that helps users to manage the firewall on their Linux machine. With firewalld, users can […]
SQL Server Default Ports
The SQL Server default ports that the SQL Engine runs on is 1433. This is a useful thing to know if managing SQL Server databases, however SQL Server can be configured to run on a variety of port numbers. For […]
Systemd is Available on WSL
Windows Subsystem for Linux (WSL) can now run systemd inside our installed WSL distributions. This is old news, announced September 2022, but I only found out about this today! I might need to update some of my WSL blog posts. […]
Troubleshooting Database Mirroring Issues in SQL Server
Maintaining high availability and data integrity in a SQL Server environment is one of the main priorities as a SQL DBA. One issue we may encounter is Mirrored databases being left in a Disconnected or In Recovery state. In this […]