In the past 5 months I have started two different jobs, so that leaves it up in the air as to which job or jobs (plus a previous job did some of these) are practicing these bad habits but these are the top 10 things that drive DBAs crazy when
Wow! The last five years of my career have been amazing. I went from attending a SQLSaturday a couple of times a year to being a coauthor of a book. Given all the obstacles I’ve had to overcome in life this truly is an amazing accomplishment. It’s on the list
Sorry readers, I was having some many adventures there was no June edition. In May, I had SQLSaturday Dallas where I got to drive a pickup truck because what else would you drive in Texas. I presented my newest and most popular related series of blog posts Collecting Performance Metrics the
We recently discovered some of our databases in an Error State for SQL Server. Microsoft has indicated this is a race condition when failover/restart happens on QDS cleanup. They are working on a bug fix for it. For now, it suggested you set up something that checks your databases to see
Recently, there are have been a few articles about the lack of adoption of Query Store. Note the following: Brent Ozar blogged about it in this article Building SQL ConstantCare®: Why People Aren’t Using Query Store. Erin Stellato blogged about it in this article Why Aren’t You Using Query Store?
Problem My company heavily uses MSX/TSX jobs for everything. But our SAN doesn’t necessarily like if we run all our index maintenance, backups, and integrity checks at the same time. So here is a quick little post on how you can schedule the workload to spread out across all your servers across
This month Rily Major (b | t) ask us to talk about how we are giving back to the community if we are or how we would if we aren’t, to lay out a plan. I’m already heavily involved in the community and haphazardly landed that way with no plan,
Well, three SQL Saturdays down for April. Raleigh which was local for me and I helped organize, Philadelphia where I got to give two talks, and Wheeling which made the news. At least this month we had spring weather for all of them. On the way to Philadelphia, the crew
Problem If you been reading this series you are used to looking at Windows and SQL Server but who knows what InfluxDB is and what to look at there especially if installed it on Linux. Lucky for us there is a dashboard to use to watch InfluxDB as well so
Problem As good DBAs, we sometimes have the need to monitor stats or just want to be nice to our system admins and share our new shiny toys and watch Windows using the same tools as SQL Server. Install and Configure Telegraf for on Windows The solution for this is fairly simple