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 […]
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, […]
How to Restore a Database in SQL Server
Restoring databases in SQL Server is a routine task and is the responsibility of Database Administrators. The nature of a DBA job often means experiencing periods of calm with sudden spikes in demand, such as needing to restore numerous databases […]
Quick Performance Troubleshooting Script for SQL Server
When your SQL Server database starts experiencing performance issues, it’s crucial to have tools at your disposal to quickly diagnose and address the root causes. One such tool is a performance troubleshooting script that provides insights into SQL Server’s current […]
Get Most Frequently Executed Queries in SQL Server
As a SQL Server Database Administrator, troubleshooting query performance issues might unfortunately be a common task. Pinpointing the most frequently executed queries is akin to peering into the heartbeat of your system. Understanding which queries are running most often not […]
Get Database FileNames and Paths in SQL Server
This post shares a SQL Script to retrieve filenames, paths and other information for all databases on a SQL Server instance. As well as this, I share SQL for parsing filenames from paths which may be useful to you for […]