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]

Speaking at SQL Saturday #465 in Providence, RI

November 10, 2015 Andy 0

On December 5, I’m speaking at QL 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]

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]