Transaction log growth during BACKUP

April 10, 2017 Andy 1

Over on Stack Exchange, someone asked why their transaction log was growing very fast during a full backup. An interesting tidbit to this question is that the database is in SIMPLE recovery — so the log should stay tiny, right? Wrong. While taking a full backup of … [Read More]

What the heck is a DTU?

March 30, 2017 Andy 0

In this post on SQLPerformance.com, I explain DTUs (Database Transaction Units) and the differences you might see between the documentation and practical usage. When you’re deploying any application, one of the first questions that comes up is “What will this cost?” Most of us have gone … [Read More]

Blogging at SQLPerformance.com

March 30, 2017 Andy 0

As part of my role on the SentryOne Product Advisory Council (PAC), I’m going to occasionally be contributing posts over at SQLPerformance.com. Today, my first post was published: What the heck is a DTU? SQLPerformance.com focuses on providing innovative and practical solutions for improving SQL … [Read More]

Congratulations 2017 Microsoft MVP!

March 19, 2017 Andy 0

Earlier this month, I got an email with the subject line “Congratulations 2017 Microsoft MVP!” I immediately commenced doing a Snoopy happy dance (my dog, Callie, picked up on the excitement and joined in). If you aren’t familiar with the MVP Program, you might be … [Read More]

SQLSaturday Boston 2017 Roundup

February 28, 2017 Andy 7

SQLSaturday Boston was February 25. I was invited into the organizing team in 2015, and this was my third time helping to put together the event. But this time was different. This time, I was running the show. I wanted to do a quick round-up of some … [Read More]

Customizing SSRS Sender Address

February 6, 2017 Andy 0

In SQL Server Reporting Services (SSRS), you can configure the sender address for email subscriptions at the instance level. This means that every email sent from your SSRS server will come from the same address. (On each subscription, you can optionally supply a Reply-To address, which allows … [Read More]

Keyboard shortcut to close a query tab in SSMS

January 27, 2017 Andy 1

Shortcuts & tips from an Impatient DBA This series of short posts will demonstrate some lesser-known features, keyboard shortcuts, and other tips that make my day as a DBA more productive. None of these are groundbreaking super-secret features–they are the little things that I do … [Read More]

Building a Twitter-bot RSS Aggregator

January 11, 2017 Andy 1

I hate RSS readers For some reason, about once a year, I go hunting for a new RSS reader so I can keep track of blogs that I like to read.  It’s always the same process: Dig through reviews to find an app that I think … [Read More]

2017 Community Event Calendar (Q1)

January 5, 2017 Andy 0

2017 is off to a busy start! It’s only the first week of the year, and my calendar is already looking pretty busy–4 events in 44 days. Here’s my calendar for the first few months of the year. January January 12, 2017 – Speaking at Fairfield PASS – Shortcuts from … [Read More]

Community Influencer of the Year

December 31, 2016 Andy 1

Last night, I was sitting at home with my husband, when I got an ominous message from Aaron Bertrand (blog|twitter): You up? I’m about to blog about you. You’ve been warned. ~ Aaron Bertrand Uhhh…. OK? It was 10:30 on a Friday night. I was … [Read More]

1 2 3 7