A black dog sits outside on a blue bed. Her golden eyes are looking directly at the camera. She wears a rainbow kerchief around her neck, with the words "I bark at bigots" emblazoned on it

Publishing a Code of Conduct isn’t enough

July 13, 2022 Andy 1

I’ve seen more and more events & communities adopt Codes of Conduct. Even local events, local user groups, and smaller online communities are adopting Codes of Conduct. That’s GREAT! …but it’s just a great start. It’s not that easy. Discoverability The issue of discoverability is … [Read More]

How to create date buckets in T-SQL

October 28, 2019 Andy 0

I was fiddling around with some data, looking at making a quick aging report. I probably should have reached for Power BI Desktop, but sometimes I can be stubborn, and I wanted to get my T-SQL to work–if nothing else to figure out how to … [Read More]

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

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]