Problem Recently I had a situation where I was looking at a SQL Instance due to a contractor who controls the system wanting to drop some indexes and they couldn’t because they couldn’t get a lock request. Sadly, they were using the GUI to try to accomplish this. Always makes
Trigger warning: suicidal ideation, depression, bipolar, mania If you would prefer to stick to all the positives skip to the numbered list at the bottom. I started the year as I did well the last 10 years oh so with my life plan up to date and goals all set.
So, we made it through our first 90 days, things start getting tougher now as now we really got to start looking at getting projects set up to get major things done. I believe that is what the six-month plan should entail besides solidifying relationships with other departments, professional development,
I blogged a few years ago about my configuration tables for Ola Hallengren’s maintenance solution that allows me to pull the configuration parameters from tables so I don’t have to edit SQL Agent jobs and allows me to query tables to see how all my jobs are configured with Ola’s
This month the fine folks behind New Stars of Data and the DataGrillen Newcomer Track bring us the Tell Your Story blog party. Where we are asked to tell one of the following: What got you into speaking? What was your first speaking experience like? How could it have been
Purpose This blog and bullet journal was specially created to help me with my tendency to have suicidal ideation, depressive, and manic episodes related to my bipolar. If you are currently in a crisis, please seek help from a mental health professional or find a hotline to call on this
Kevin Kline (b | t) is hosting T-SQL Tuesday this month and it is to “Tell us the story of how attending an IT conference or event resulted in an amazing career or life opportunity.” I have previously blogged on the topic of mentoring the community and how much I’ve gotten out
Back in 2018, wow four years ago, I presented at all five stops of Data Relay and rode the bus. For those that don’t know Data Relay is a conference in the UK that goes between five cities in five days. They take bus for the speakers between cities. The
As part of starting a new job, you need a way to get a good inventory of basic information about SQL Server instances. Once you have done what I outlined in this blog post. I find it helpful to run Glenn Alan Berry’s Diagnostic Notebooks against all the instances to
I mentioned in my New Database Job – The 90 Day Plan blog how I have a trick for storing index usage stats up until close to the next reboot of the SQL Server. You really can do this for any DMV-related query that you get reset at the reboot of