The latest malware to make the headlines is really interesting to me. It’s a ransomware worm called Petya. Ransomware is particularly interesting to me as a DBA, because DBAs are responsible for keeping data safe, and ransomware is specifically designed to destroy your data. I’m … [Read More]
UPDATE: Unfortunately, due to a change in plans, I’m not going to be at PASS Summit this year, so I won’t be hosting this meetup in 2017. Check out details here. Last year, I organized an (unofficial) PASS Summit LGBT Meetup. It was a bit … [Read More]
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]
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]
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]
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 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]
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]
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]
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]
Copyright © 2018 | Andy Mallon | Content of this site is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. 