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

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, 124 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, 1,348 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, 161 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, 130 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, 180 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, 317 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, 478 reads

Posted in Database Superhero’s Blog on 10 April 2018

Procedure to Create New Filegroups and Files

Problem

For good database design, it is not idea to have everything in your PRIMARY filegroup so you can do partial backups, piecemeal restores, and for performance to separate your tables and indexes. You need different filegroups when looking at separating your indexes and tables and partitioning. Creating all these… Read more

0 comments, 156 reads

Posted in Database Superhero’s Blog on 3 April 2018

Database Superhero Adventures, April 2018 Edition

Chicago O’Hare Airport

I had two SQL Saturdays this month SQLSaturday Chicago and SQLSaturday Rochester both of which were very cold. Hopefully, the winter SQLSaturdays are over, for now, I want it to be spring and see no more snow for awhile. I know I’m a baby, but I’m used… Read more

0 comments, 178 reads

Posted in Database Superhero’s Blog on 1 April 2018

Setting up Telegraf to Startup on Windows

Problem

I’ve noticed on demo machines that sometimes Telegraf doesn’t start on the first try, and this seems to not happen on most of my production servers, but they have a lot more memory and CPU power. So I figured I would write a quick blog post and provide a… Read more

0 comments, 171 reads

Posted in Database Superhero’s Blog on 12 March 2018

Database Superhero Adventures, March 2018 Edition

I had two SQL Saturdays this month SQLSaturday Cleveland (which was very cold) and SQLSaturday Tampa (which had very nice weather). Now for the adventurous parts of both trips. Well besides worrying about snow, Cleveland was in Hyland Software and there was the really cool slide that I may or… Read more

0 comments, 102 reads

Posted in Database Superhero’s Blog on 1 March 2018

Guide for Set Up of Telegraf for Monitoring SQL Server xPlat

Problem

We need a way to collect performance metrics for all our SQL Servers (Windows and Linux) into one system and display that information in a way our DBAs can read it. Also, we would like to keep cost down.

Solution

The complete solution for Telgraf involves having InfluxDB and Grafana… Read more

7 comments, 198 reads

Posted in Database Superhero’s Blog on 24 February 2018

T-SQL Tuesday #99 : Dealer’s Choice – Being a Voice for a Foster Child in Court

This month Aaron Bertrand (b | t) has given us a Dealer’s Choice on the T-SQL Tuesday topic. I’m of course going to take the chance to talk about something I’m passionate about.  It’s not something people would consider fun but it’s what I enjoy spending my spare… Read more

4 comments, 45 reads

Posted in Database Superhero’s Blog on 13 February 2018

Exciting New Projects

We Speak Linux

I am super excited to be to have launched this website. We Speak Linux is a place for Windows Administrators and SQL Server DBAs to learn more about the Linux operating system. There are plenty of good sources for information about Linux on the internet, but with… Read more

0 comments, 44 reads

Posted in Database Superhero’s Blog on 7 February 2018

Database Superhero Adventures, February 2018 Edition

vs.

The week of SQLSaturday Nashville would prove to be a most eventful week. Monday I would be on my work to work riding on a two-lane road a dump truck would decide to turn into the passenger side of the car. Thankfully no one was hurt. But it did… Read more

0 comments, 40 reads

Posted in Database Superhero’s Blog on 1 February 2018

Speaking at PASS Summit 2017 – Gaining Confidence

Earlier this week the folks at PASS reached out to last year’s speakers asking us to share a story of how speaking at PASS impacted us professionally or personally. At first we I received the email saying I had been selected I was at a speaker’s dinner for a SQL… Read more

0 comments, 50 reads

Posted in Database Superhero’s Blog on 27 January 2018

Implementing Smart Differential Backups Using Ola Hallengren’s Backup Scripts in SQL Server 2017

This is part 2 of 2 on taking smart backups. I wrote a previous blog on how to use configuration tables to set up smart backups for transaction log backups.  This post we will see how to set up differential backups using the same configuration tables.

SQL Server 2017 introduced a… Read more

0 comments, 51 reads

Posted in Database Superhero’s Blog on 23 January 2018

T-SQL Tuesday #98 – Your Technical Challenges Conquered – Corrupt Database in System Table

This T-SQL Tuesday is brought to us by Arun Sirpal (b | t) and wants to write about a technical challenge we have conquered.  Having been a DBA for 18 years now it’s hard to pick on a technical challenge but I will stick to the more recent… Read more

0 comments, 50 reads

Posted in Database Superhero’s Blog on 9 January 2018

Implementing Smart Transaction Log Backups Using Ola Hallengren’s Backup Scripts in SQL Server 2017

This is part 1 of 2 part series on taking smart backups.  Part 1 will be taking smart transaction logs in SQL Server 2017, then we will take smart differential/full backups on 2017, and finally, we will take smart differential/full backups on SQL Server 2005 through 2016.

SQL Server 2017… Read more

0 comments, 45 reads

Posted in Database Superhero’s Blog on 2 January 2018

Database Superhero Adventures, January 2018 Edition

Just in case you missed it I wrote a blog post for Idera on creating PowerShell module using Plaster you can find it here.  It simplifies an earlier blog post I wrote and the same subject with some information I learned from Rob Sewell.

This month I have one… Read more

0 comments, 40 reads

Posted in Database Superhero’s Blog on 1 January 2018