Did you know it is possible for SQL Server Agent to alert you of problems if something goes haywire with your Agent? Have you ever had an issue with Alerts not being sent after critical events? Then you might need to configure the SQL Server Agent Fail-Safe Operator to save the day. A Fail-Safe WHAT Read More …
Deja Vu, back in March I saw a Tweet about the beta Microsoft Certification Exam DP-300. I work with Azure and Databases, so I thought to myself why not take an exam for a discounted price and see where my knowledge lies. Win Win, right!! The beta exam offers 80% discount on the exam fee. Read More …
If you are like me, you inherited variously configured SQL Servers when you took over as the DBA for your company. After almost two years, I have gotten all the standards in place where I feel that the environment is clean. One of the last things I accomplished was to standardize SQL Server Error Log Read More …
Recently, I was alerted to a network file share that was running low on disk space. This interesting as there was only one process that used this particular location to store SQL Backups. We have a nightly job that runs full copy only backups of a couple critical databases that are scrubbed and restored to Read More …
Do you run SQL Agent Jobs in your environment? Do you know what is running at any given time? Most people do not know what is currently running if you ask them. There are several times I need to know what job(s) is running on which server. For instance, let’s say on the morning of Read More …
