-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Database Superhero’s Blog

Tracy is the Database Superhero for ChannelAdvisor. She has spent over 20 years in IT and has used SQL Server since 1999. Tracy covers all aspects of administration and deals heavily with performance tuning and high availability and disaster recovery. Tracy is a co-organizer of a Special Interest Group (SIG) dedicated to advanced DBA topics in our local user group TriPass. She is also the founder of http://WeSpeakLinux.com. Before she worked full-time as a DBA she was formally a developer and network administrator. She also tinkered with databases in middle/high school to keep her sports card collection organized.

Things That Drive a DBA Crazy When Starting a New Job

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… Read more

7 comments, 2,779 reads

Posted in Database Superhero’s Blog on 26 November 2018

Exceeding My Own Expectations in Life!

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… Read more

0 comments, 195 reads

Posted in Database Superhero’s Blog on 24 October 2018

Database Superhero Adventures, July 2018

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 Read more

0 comments, 392 reads

Posted in Database Superhero’s Blog on 2 July 2018

Database Superhero Adventures, July 2018

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 Read more

0 comments, 24 reads

Posted in Database Superhero’s Blog on 2 July 2018

Query Store Error State

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… Read more

6 comments, 91 reads

Posted in Database Superhero’s Blog on 26 June 2018

Query Store Error State

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… Read more

6 comments, 307 reads

Posted in Database Superhero’s Blog on 26 June 2018

Query Store Usage and Adaptive Plan Tuning Usage

Recently, there are have been a few articles about the lack of adoption of Query Store. Note the following:

  1. Brent Ozar blogged about it in this article Building SQL ConstantCare®: Why People Aren’t Using Query Store.
  2. Erin Stellato blogged about it in this article Why Aren’t You Using Query…

Read more

0 comments, 2,245 reads

Posted in Database Superhero’s Blog on 17 June 2018

Query Store Usage and Adaptive Plan Tuning Usage

Recently, there are have been a few articles about the lack of adoption of Query Store. Note the following:

  1. Brent Ozar blogged about it in this article Building SQL ConstantCare®: Why People Aren’t Using Query Store.
  2. Erin Stellato blogged about it in this article Why Aren’t You Using Query…

Read more

0 comments, 24 reads

Posted in Database Superhero’s Blog on 17 June 2018

Spreading Job Run Times Out on an MSX/TSX Scheduled Job

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… Read more

2 comments, 94 reads

Posted in Database Superhero’s Blog on 29 May 2018

Spreading Job Run Times Out on an MSX/TSX Scheduled Job

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… Read more

2 comments, 1,536 reads

Posted in Database Superhero’s Blog on 29 May 2018

T-SQL Tuesday #102 – Giving Back

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… Read more

2 comments, 34 reads

Posted in Database Superhero’s Blog on 8 May 2018

T-SQL Tuesday #102 – Giving Back

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… Read more

2 comments, 228 reads

Posted in Database Superhero’s Blog on 8 May 2018

Database Superhero Adventures, May 2018 Edition

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… Read more

0 comments, 199 reads

Posted in Database Superhero’s Blog on 1 May 2018

Database Superhero Adventures, May 2018 Edition

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… Read more

0 comments, 28 reads

Posted in Database Superhero’s Blog on 1 May 2018

Guide for Setting up Telegraf to Monitor InfluxDB

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… Read more

0 comments, 101 reads

Posted in Database Superhero’s Blog on 30 April 2018

Guide for Setting up Telegraf to Monitor InfluxDB

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… Read more

0 comments, 351 reads

Posted in Database Superhero’s Blog on 30 April 2018

Guide for Set Up of Telegraf for Monitoring Windows

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… Read more

0 comments, 759 reads

Posted in Database Superhero’s Blog on 17 April 2018

Guide for Set Up of Telegraf for Monitoring Windows

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… Read more

0 comments, 38 reads

Posted in Database Superhero’s Blog on 17 April 2018

T-SQL Tuesday #101: My Essential SQL Server Tools

This T-SQL Tuesday is brought to us by Jens Vestergaard (b |  t), and we are asked to share our favorite SQL Server tools. Hint Profiler will not be on the list. But where do you start there are so many tools out there. In alphabetical order here… Read more

0 comments, 33 reads

Posted in Database Superhero’s Blog on 10 April 2018

T-SQL Tuesday #101: My Essential SQL Server Tools

This T-SQL Tuesday is brought to us by Jens Vestergaard (b |  t), and we are asked to share our favorite SQL Server tools. Hint Profiler will not be on the list. But where do you start there are so many tools out there. In alphabetical order here… Read more

0 comments, 574 reads

Posted in Database Superhero’s Blog on 10 April 2018

Older posts