Redgate Streamed

April 9, 2020 Andy 0

Last week, I had the pleasure of participating in Redgate Streamed, a three-day virtual conference organized by my friends at Redgate. My session was Shortcuts from an impatient DBA–discussing a bunch of Management Studio tips & tricks for data professionals. The virtual conference was free … [Read More]

Using PowerShell to tidy up CSV files

December 28, 2018 Andy 0

I was recently fussing with a CSV file that had an inconsistent number of columns. UGH. There was a bunch of historical data that had 4 columns, and then more recent data had a new attribute added with 5 columns. I spent a few minutes … [Read More]

Backing up to NUL:

December 31, 2017 Andy 0

Linux folks have lots of jokes & fun t-shirts about /dev/null/. The null device is a handy location to dump output to, when you don’t actually care about the output. In PowerShell, you can use Out-Null to dump extra output into the ether, and keep … [Read More]

Keyboard shortcut to close a query tab in SSMS

January 27, 2017 Andy 1

Shortcuts & tips from an Impatient DBA 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 … [Read More]