No Picture

SSMS Vertical block highlighting & editing

November 24, 2015 Andy 0

Shortcuts & tips from an Impatient DBA #11 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 … [Read More]

No Picture

#sqlcares, #sqlwish, and #sqlfamily

November 19, 2015 Andy 0

I’ve been using SQL Server for a dozen years now, but I’ve only been starting to make friendships and build relationships within the SQL Server community in the last couple of years. More importantly, it has only been in the last year that I would … [Read More]

No Picture

RECONFIGURE—When to use WITH OVERRIDE?

November 17, 2015 Andy 2

When you’re using sp_configure to change a system configuration, you have to run a RECONFIGURE to finalize your change. You even get the helpful output that reminds you to run RECONFIGURE: Configuration option ‘max degree of parallelism’ changed from 0 to 1. Run the RECONFIGURE … [Read More]

No Picture

Speaking at SQL Saturday #465 in Providence, RI

November 10, 2015 Andy 0

On December 5, I’m speaking at SQL Saturday #465 in Providence, RI. My session is called “Shortcuts from an Impatient DBA.” This is an expanded version of my lightning talk from the New England SQL Server User Group earlier this year. It went over so well, I … [Read More]

No Picture

Speaking at SQL Saturday #470 in DC

November 9, 2015 Andy 0

On December 5, I’m speaking at SQL Saturday #470 in Washington DC. My session is called “Wheaton’s Law for Technology Pros” and is based on my post “Watch your step! Don’t become a DBA-hole.”   I’m really looking forward to it for lots of reasons, but … [Read More]

No Picture

Thank you #sqlsatbostonbi 2015

October 18, 2015 Andy 1

Yesterday was SQL Saturday #437 or as we call it, SQL Saturday Boston BI Edition. It was my first time helping to organize a SQL Saturday (or any event like this). It was an honor to be asked to join the organizing team, knowing that … [Read More]

No Picture

Dumplings, Databases and Corporate Espionage

October 8, 2015 Andy 0

This blog post takes a tangent from my usual technology-specific ramblings, but I’ll make the connection eventually. Just bear with me. Dumplings Today, I was craving some mapo tofu, so I went to one of my favorite lunch joints, Dumpling Daughter (website|twitter). As I walked in, … [Read More]

Planning for an outage: Phone numbers

September 15, 2015 Andy 0

Who ya gonna call? If there’s somethin’ strange in your neighborhood Who ya gonna call? If it’s something weird and it won’t look good Who ya gonna call?   This summer, they’ve been taping the new Ghostbusters movie in Boston. It’s pretty cool to see the Ghostbusters … [Read More]

No Picture

Embedded video demos in PowerPoint

September 11, 2015 Andy 0

Shortcuts & tips from an Impatient DBA #10 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 … [Read More]