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 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 […]
SQL Server Heap Fragmentation
SQL Server heap fragmentation can significantly impact database performance and efficiency. In this blog post, we’ll dive into the causes of heap fragmentation, its effects on SQL Server performance, and effective strategies to mitigate and manage it. In SQL Server, […]