Browse the archive
Elphie wearing her "I bark at bigots" pawkerchief 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 …
Continue readingI 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 make it work.
Continue readingOn October 2, 2018 at 11PM EDT, I’ll be joined by John Q. Martin (blog|twitter) for a webinar on Azure SQL Database Managed Instance. To sign up, register here. You can access the recording of the session here. Follow-up Q & A from the live session can be …
Continue readingIt’s T-SQL Tuesday, the blog party that SQL Server expert Adam Machanic (blog|twitter) started. This month’s episode is hosted by Bert Wagner (blog | vlog| twitter). The topic: Code You Would Hate To Live Without It’s been a little bit since the last T-SQL …
Continue readingThe latest malware to make the headlines is really interesting to me. It’s a ransomware worm called Petya. Ransomware is particularly interesting to me as a DBA, because DBAs are responsible for keeping data safe, and ransomware is specifically designed to …
Continue readingI’m really excited to be speaking in Chicago this year. I’m going to be giving my “Shortcuts From an Impatient DBA” session. I love this presentation, and I’m excited to share it in Chicago. How’d you do that?!? This presentation is a series of keyboard …
Continue readingShortcuts & 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 …
Continue readingWhen 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. …
Continue readingThis blog post takes a tangent from my usual technology-specific ramblings, but I’ll make the connection eventually. Just bear with me. Dumplings Dan dan mien, mango bubble tea, and petite chicken dumplings in Sichuan sauce Today, I was craving some mapo tofu, …
Continue readingWho 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 …
Continue reading
