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 …
