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]
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]
Yesterday was SQL Saturday #437 or as we call it, SQL Saturday Boston BI Edition. It was my first time helping to organize a SQL Saturday (or any event like this). It was an honor to be asked to join the organizing team, knowing that … [Read More]
Question I have Native SSRS configured on a 2012 instance (11.0.2100). I have two reports with images that act as buttons to toggle between the chart report and the detail report. I want to configure the action URLs to dynamically pass in parameters when switching … [Read More]
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]
WARNING: Silent truncation ahead Have you ever tried to enter a really long description on a SQL Agent job? Maybe you were trying to put some sort of warning to people who might be trying to edit the job, or triage info for when the … [Read More]
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]
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 do as part of my daily work that … [Read More]
This evening, I did my first presentation at a user group at my local user group. Sure, it was just a lightning talk, but the New England SQL Server user group is a tough crowd. People ask tough questions. Nobody is timid about interrupting you … [Read More]
Question Imagine we have two nodes participating in SQL 2012 AO. This is a test instance. During one of the index rebuild operation the log was grown up really big (250 GB). We are unable to back it up due to space constraint. What if … [Read More]
Copyright © 2025 | Andy Mallon | am2.co