Your transaction log is full. Both Microsoft, and about 100 articles and blogs have covered this topic, but let’s take a quick look anyway. Because, you know, it comes up all the time.
Category: Tips
Generate RESTORE LOG statements
Today, we’re going to take a specific, simple example of generating RESTORE LOG statements from a directory list of files, using Powershell and find-and-replace.
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: […]