Skip to content

DBASco

Database & System Engineering Blog

  • Home
  • SQL Server
    • MSSQL Scripts
  • PowerShell
    • PowerShell Scripts
  • DBA Cheat Sheet
  • Other Posts
  • About
How to Check if Query Store is Enabled in SQL Server
SQL ServerTagged MSSQL DBA Tips, SQL Server PerformanceLeave a Comment on How to Check if Query Store is Enabled in SQL Server

How to Check if Query Store is Enabled in SQL Server

March 4, 2024August 18, 2024

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
SQL ServerTagged MSSQL DBA Tips, NetworkingLeave a Comment on SQL Server Default Ports

SQL Server Default Ports

March 1, 2024March 3, 2024

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
SQL ServerTagged MSSQL DBA Tips, SQL Server High Availability, SQL Server MirroringLeave a Comment on Troubleshooting Database Mirroring Issues in SQL Server

Troubleshooting Database Mirroring Issues in SQL Server

February 28, 2024March 3, 2024

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
SQL ServerTagged MSSQL DBA Tips, MSSQL ScriptsLeave a Comment on Get SQL Server Services Info from Command

Get SQL Server Services Info from Command

February 26, 2024February 27, 2024

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
SQL ServerTagged MSSQL DBA Tips, SQL Server Database FilesLeave a Comment on Understanding Log Space Usage in SQL Server

Understanding Log Space Usage in SQL Server

February 25, 2024February 26, 2024

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 ServerTagged MSSQL DBA Tips, MSSQL Scripts, SQL Server PerformanceLeave a Comment on SQL Server Heap Fragmentation

SQL Server Heap Fragmentation

February 23, 2024February 23, 2024

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

Posts pagination

1 2 … 5 Next

Popular Posts

DBASco (SQL DBA Blog) - 2024