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 […]