Keep a good eye on your backup and maintenance; they’re kind of important to the health and well-being of your job wait I mean SQL Server instances. So how do we go about this? Well, there’s the easiest way – you knew I’d be mentioning Minion Enterprise, right? – and then there’s the hard way. The easiest way If you have Minion […]
Category: sql server
Management Studio Shortcut – Change Connection
One of the most common things I do within SSMS is to change connection for the current query editor window, from one SQL Server instance to another: I’m a huge fan of keyboard shortcuts (see exhibit 1, exhibit 2, and exhibit 3). So let’s create a shortcut for “Change Connection” today. The basic method for creating keyboard shortcuts is: […]
How to make a Database Request
You need something from the database admin. Maybe it’s permissions, maybe it’s code troubleshooting, or maybe it’s just that the database is slow. I’m going to let you in on the secret of the best method to get what you want out of your DBA. Ready? Here’s the secret… Ask clearly. Include all details. In the sections below, […]