Welcome to Part 2 in the series about SQL Server Agent Job Failures. In this part you are going to learn how to build an HTML report with Failed Agent Job information and send the report via e-mail to the interested team(s). Let’s get started putting the pieces together to build our report. First step: Read More …
This month’s T-SQL Tuesday is being hosted by Elizabeth Noble. The subject chosen “what have you automated to make your life easier?” For me the topic is near and dear to my heart. I was honored to host T-SQL Tuesday #110 and had a similar topic. It was awesome to see peoples automation stories. That Read More …
SQL Server Agent Jobs are one of the core features of SQL Server. Agent Jobs perform many actions, from maintenance tasks (server and database), data movement flows, replication, log shipping, data cleanup, health checks and many more. Since Agent Jobs are a critical component in a data organization, it is important to know when Agent Read More …
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 …
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 …
Do you frequently use the “log_reuse_wait_type_desc” column in the sys.databases view? Have you ever seen the type of OLDEST_PAGE? You are not the only one!! Recently I was troubleshooting an issue with a database where the log was growing and the virtual logs would not clear after executing a transaction log backup. So I took Read More …
Issue Recently, I was forwarded a request from our Product Support team to prepare the database for a third party application to be sent to the vendor for troubleshooting. This particular database has TDE enabled, so I figured that is easy, let me knock that out. So I proceeded to restore the database to one Read More …
For this week I am going to go through a process that I developed and am pretty proud of. We the DBA Team are responsible for getting data in to our Integration environments and higher. We do not trust the developers with this responsibility as they would probably break something. Issue Recently one of our Read More …
