Tag: Database Admin
Database Admin Blog Archives: Includes practical guides, troubleshooting strategies, and best practices, written by an experienced Microsoft SQL Server DBA.
-
Log and Filter sp_who2 Results in SQL Server
When managing SQL Server performance, the built-in sp_who2 procedure is a commonly used tool for quickly checking active processes and their resource usage…
-
SQL Server Script: Enable or Disable All SQL Agent Jobs
SQL Server Agent jobs automate tasks within SQL Server, but there are times when you need to enable or disable multiple jobs, such as during maintenance…
-
How to View the Definition of a Stored Procedure
In this post, I’m sharing some SQL Scripts that will help you view the definition text of Stored Procedures and other objects in SQL Server.
-
SQL Script to Show Exclusive Locks on Tables
In this post I’m sharing a SQL script that will show exclusive locks for all tables in a database, with added info to help you understand what we’re looking at.
-
SQL Server Performance Tuning: Index Fragmentation Scripts
In this post I’m sharing more scripts to help with SQL Server performance tuning. This time, we’re looking at index and heap fragmentation which are useful for…
-
SQL to SQL: A Practical Guide from a DBA
If you’re looking to connect, migrate, or convert between SQL databases, this post is aimed at you.
-
How to Check and Manage SQL Server Services
As a SQL Server DBA, it’s important that we have quick and efficient ways to check SQL Services. We need to ensure our SQL Services are always available, and…
-
Checking SQL Server Mirroring Health & Latency
In this blog post I’m sharing info on how to check the health and latency of your Database Mirroring in SQL Server.
-
SQL Script to Get AAG Latency
In this post, I’m sharing a script that I use frequently as a Production SQL DBA to check Always On Availability Group (AAG) latency.
Three guides collect the posts by the job you are doing rather than by date.
PowerShellFiles, CSVs, the firewall, scheduled tasks WSLInstalling it, distros, files across both worlds Windows AdministrationServers, domains, DNS, the tools worth havingThis site started as a SQL Server blog in 2017 and the archive is still here. The new SQL Server writing, and all the scripts, moved to a site of their own.
sqldba.blogScripts, error library, wait types, SSMS- Linux & WSL (28)
- Microsoft SQL Server (50)
- Other (13)
- PowerShell (53)
- Windows Server Admin (38)