Learn how to use the SQL Server Agent Alerting system to capture Availability Group related errors and to respond to them by running jobs.
(2017-2022)
Browsing Posts in SQL Server Central
As you already know, SQL Server runs as a service. And services require a service account to run under. While this service account is likely to be a domain service account, it could be an account on the local machine. To follow good security practices you would need to specify that this account: Has the […]
One of the most basic actions dealing with a SQL Server instance is connecting to that instance. In this post, we’ll cover the many possible ways of connecting to a SQL Server instance.
SQLSaturday SpeedPASSes I’ve been working with running SQLSaturdays in the Richmond, VA area for several years now. It seems that every year, I end up blogging something new. Frequently, this ends up being a script of some kind to help me out. This post follows this theme by introducing a script for working with SQLSaturday […]
