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 …
Two weeks ago I was on-call and at 4:45AM Saturday morning my phone rang and the dreaded contact “NOC” was on the screen. After finding my phone and answering, the NOC technician explained that we had a Tier 2 server that had the log drive out of space. After letting them know I would check Read More …
I know it is a weird time to be putting out a blog post. But I have 28 hours to keep my goal of 52 blogs in 52 weeks going. You say it is only week two and you are this far behind. This week was hectic since I was on-call at work. So I Read More …
It is no secret that I have become a Fan-Boy of the open source community project dbatools. I have been in IT for over 20 years and have worked with different scripting languages for performing tasks. In recent years, I have “hacked” together PowerShell scripts I found online to accomplish specific tasks. dbatools takes DBA Read More …
Recently I had the opportunity to attend my second SQL Skills training course. I was honored that my company felt it was worth while for my career growth to send me to such a top notch training class. This was my second time to attend a SQL Skills training event. The first one was hosted Read More …
Here is a continuation blog on things I learned to do with PowerShell to fix an issue in my day-to-day task list. This one may not be daily, but I think it might help someone out there. Previous Posts: Part 1 of 4 Part 2 of 4 Issue: A couple weeks ago we had a Read More …
