Tag: Always On Availability Groups (AAG)
Always On Availability Groups (AAG) Blog Post Archives: Includes SQL Scripts & detailed guides to help manage Highly Available (HA) SQL Servers.
-
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…
-
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.
Start with a guide
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 havingLooking for SQL Server?
This 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, SSMSLatest posts
Browse by topic
- Linux & WSL (28)
- Microsoft SQL Server (51)
- Other (13)
- PowerShell (53)
- Windows Server Admin (38)