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]

No Picture

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]

No Picture

Common SSMS keyboard shortcuts

June 2, 2015 Andy 0

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

Tip: Never disable a job temporarily

June 1, 2015 Andy 1

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

Tip: Windows Explorer address bar hack

May 29, 2015 Andy 0

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

SSMS Query Shortcuts

May 28, 2015 Andy 0

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

Shortcut: SQL Template Parameters

May 27, 2015 Andy 0

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

Shortcut: CTRL + ]

May 26, 2015 Andy 0

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

Shortcut: CTRL + SHIFT + V

May 25, 2015 Andy 2

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]

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]