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 3

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]

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]

TSQL Tuesday #85: Backup + Recovery + ☁️

December 13, 2016 Andy 0

It’s T-SQL Tuesday,  the blog party that SQL Server expert Adam Machanic (blog|twitter) started. This month’s episode is hosted by Kenneth Fisher (blog| twitter). The topic: Backup & Recovery Your backups are my bread & butter Backup & recovery are a DBA’s bread & butter. I always tell people that … [Read More]

December SQLSaturdays–DC & Providence, RI

November 4, 2016 Andy 0

Next month, I’ll be speaking at two SQLSaturday events. Washington, DC – #SqlSat574 – December 3, 2016 The DC SQL Saturday was the first SQL Saturday I spoke at–so this one will always be a special event for me. Hopefully, I’ll be able to speak at … [Read More]

T-SQL Tuesday #83: Roundup

October 16, 2016 Andy 2

For this month’s T-SQL Tuesday, I asked people to blog about the same old problems we’ve been dealing with for years. There were some great posts, including a batch of first-time contributors. You’ll notice some overlapping themes as you read through these responses–I think those themes represent some … [Read More]

(Unofficial) PASS Summit 2016 LGBT Meetup

October 12, 2016 Andy 5

PASS Summit has tons of opportunities to meet like-minded folks, in addition to seeing old friends. There are the Women In Tech and Birds of a Feather Luncheons. There is the Community Zone. Friends catch up over coffee and meals. There are vendor parties. There … [Read More]

We’re still dealing with the same problems

October 8, 2016 Andy 1

Back in August, Allan Hirt (blog|twitter) tweeted: In the roughly 25 years of I have been in IT, we're still dealing with the same problems. — Allan Hirt (@SQLHA) August 30, 2016 I had a slow day, so I generated a storm of responses. This month’s T-SQL … [Read More]