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]

No Picture

Big security loophole with SQL Logins

April 30, 2015 Andy 0

Aaron Bertrand (twitter|blog) recently blogged asking for help to fix a big security loophole. I read the post then, but it was only this morning that I finally got around to REALLY looking at it, thinking about it, and testing it out for myself. Aaron … [Read More]