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]

Add-Equals operator

May 24, 2016 Andy 9

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]

SSMS Template Replacement

May 19, 2016 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]

Shortcuts Cheat Sheet – SSMS & Windows

March 7, 2016 Andy 22

I’ve presented my Shortcuts from an Impatient DBA talk a few times now, and I really love it. Everyone learns something, whether you’re a Junior Developer, or a multi-decade veteran, or a Data Platform MVP. This past weekend, after presenting at SQLSaturday Chicago, Brent Ozar (blog|twitter) suggested that as an … [Read More]

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]

Embedded video demos in PowerPoint

September 11, 2015 Andy 0

Shortcuts & tips from an Impatient DBA #10 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]

Thanks for being awesome NE SQL!

September 10, 2015 Andy 2

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]

Tip: Master Control Panel

August 18, 2015 Andy 0

Shortcuts & tips from an Impatient DBA #9 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]

How to find the SQL Server Service Account

June 18, 2015 Andy 2

What is the service account running your instance of SQL Server? A lot of DBAs probably know right off the top of their head–maybe because they’re using the same account for every instance. Have you ever had to audit every service account on every instance? … [Read More]

Tip: Go [count]

June 3, 2015 Andy 0

Shortcuts & tips from an Impatient DBA #8 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]

1 2