-->
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.

T-SQL Tuesday #111 – What is My “Why?”

This month for T-SQL Tuesday we are asked to describe our “Why”.  I have a couple of Whys not related to my day job, but we will start with my day job.

Since I was six years old, I wanted to be a computer programmer because I thought video games… Read more

0 comments, 374 reads

Posted in Database Superhero’s Blog on 12 February 2019

Year in Review 2018 – The Year of Making a Difference – Up to 50

Rough Year, But 50 Kids, Can’t Beat That!

Last year was a pretty rough year personally.  I totaled two cars, not my fault big trucks like to make turns into little cars, a crisis with a friend, and a mental health crisis still ongoing from June.  But I’ve stuck out… Read more

0 comments, 119 reads

Posted in Database Superhero’s Blog on 4 January 2019

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, 3,000 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, 216 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, 420 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, 41 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, 137 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, 379 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,279 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, 40 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, 136 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,599 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, 51 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, 257 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, 222 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, 45 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, 150 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, 424 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, 953 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, 58 reads

Posted in Database Superhero’s Blog on 17 April 2018

Older posts