Tag: MSSQL DBA Tips
-
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…
-
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…
-
Moving Temp DB in SQL Server
A common best practice in SQL Server, is to have your Temp TB files stored on a separate…
-
List all SQL Agent Jobs in SQL Server
Listing SQL Agent jobs on a SQL Server instance is occasioanlly needed for DBAs or ETL Experts to…
-
Using PowerShell to Get Last SQL Failover Time
For SQL Server Database Administrators, tracking the timing of cluster failovers is crucial for maintaining database availability and…
-
How to Check SQL Server Versions
As Database Administrators (DBAs), safeguarding the security of our SQL Server instances is paramount. Regular monthly patching is…
Most Viewed
Blog Categories
- Other (7)
- PowerShell (29)
- SQL Server (62)
- WSL (11)