Latest Articles
-
Check if Query Store is Enabled in SQL Server
READ MORE →: Check if Query Store is Enabled in SQL ServerThe 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 is enabled for all…
-
SQL Server Management Studio (SSMS) v20.0 Preview
READ MORE →: SQL Server Management Studio (SSMS) v20.0 PreviewSQL 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 Azure Data Studio. Hmm.…
-
How to Install Firewalld on WSL Ubuntu
READ MORE →: How to Install Firewalld on WSL UbuntuThis 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 define rules to allow…
-
SQL Server Default Ports
READ MORE →: SQL Server Default PortsThe 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 example, you’ll see this…
-
Systemd is Available on WSL
READ MORE →: Systemd is Available on WSLWindows 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. In my opinion this…
-
Troubleshooting Database Mirroring Issues in SQL Server
READ MORE →: Troubleshooting Database Mirroring Issues in SQL ServerMaintaining 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 article, we’ll share the…
Peter Whyte
Hello, my name is Peter Whyte. I’m a skilled Database Administrator (DBA), maintaining High Availability SQL Server environments, troubleshooting issues, and optimizing database performance remotely from Edinburgh, Scotland.