TSQL Tuesday #104: dbo.Check_FileSize

July 9, 2018 Andy 2

It’s been a little bit since the last T-SQL Tuesday I joined, when I blogged about religion & politics. This month, I answer Bert Wagner’s call to blog about code I would hate to live without

What’s wrong with DELETE EXISTS?

June 30, 2017 Andy 1

This morning, when I logged into Twitter, the tweet at the top of my timeline was from Shane O’Neill (blog|twitter). It was to his blog post, Shane, What’s wrong with DELETE EXISTS?.  It’s not that unusual that Shane would talk to himself in the third … [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]

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

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]

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]

Watch your step! Don’t become a DBA-hole

July 14, 2015 Andy 1

No, I’m not discouraging anyone from being a DBA. I’m just discouraging DBAs from being A-holes. DBAs (and IT folk in general) have a terrible reputation for being curmudgeons, jerks, and a-holes. These guys exist, and working with them is a miserable experience–but they’re a … [Read More]