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 …
Continuing on my PowerShell learning journey, this is part two of my series for the SQL DBA. This will focus on the DBATools utility that was originally built for SQL Migration by Chrissy LeMaire (t) and has evolved into an awesome tool that will help your average DBA automate tasks and be able to get Read More …
Have you ever racked your brain as to why a server looks busy, but the overall health of the server is fine? There is no obvious answer for what could be causing the issue you are experiencing. Server History This issue has plagued me for a month regarding one server. We have a server that Read More …
In years past I have attempted to learn PowerShell numerous times. Usually I just hack together a solution to a current problem I am trying to solve. I never really sat down and learned the fundamentals. As my SQL environment grows and interesting requests come in from management and other internal partners I see the Read More …
In this day and age of security breaches and data leaks, IT departments continue to find new ways to prevent these issues. I work for a company in the financial sector and we are always undergoing a security audit of some kind. Once these audits are complete there are always new procedures and policies around Read More …
After trying for years, in 2016, I was finally able to attend a SQLskills training class. I was sure this in-depth knowledge would take my SQL skills to the next level (no pun intended) and, man was I right! That was truly a week to remember and my brain has never absorbed so much awesome Read More …
