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 […]
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 […]
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 […]
Get SQL Server Services Info from Command
As a SQL Server database administrator (DBA), one of your primary responsibilities is ensuring the smooth operation of SQL Server services. Whether it’s monitoring service status, managing startup configurations, or tracking service accounts, having quick access to this information can […]
Understanding Log Space Usage in SQL Server
In a SQL Server environment, monitoring database log space usage is crucial for maintaining database performance and ensuring data integrity. Insufficient log space can lead to transactional failures, database downtime, and even data loss. In this blog post, we’ll share […]