SQL Server

Removing SSMS Boost

ben himself's picture

SSMS Boost is an add-on for SQL Server Management Studio.  I used it for quite some time but I got tired of using it as freeware.  The reason SSMSBoost as freeware didn't work for me was because they require that you continually re-download the new version and re-register every 120 days, otherwise it renders your existing version useless.  That process gets tedious, at least I think it does.  I want my tools to server me, not the other way around.

Tags: 

SQL Server Maintenance Plan Backups Failing On Secondary Replica in High Availability Environment

ben himself's picture

When a High Availability (HA) environment failed over, on the node that became Secondary, the backup jobs did not gracefully handle the change. The Maintenance Plans are supposed to intelligently determine whether each database is Primary or Secondary in an HA environment, and skip the backup if it is not Primary.  This check actually fails (practically speaking) if you have "Verify backup integrity" checked.

Tags: 

TSQL - Make Excel Link In Output

ben himself's picture

Here is a situation I just came across (boiled down and simplified).  An end user was having to manually find a user id, navigate to an image folder, and then search through hundreds of images to find the one corresponding with that user.  Sure, they were in numerical order, but still, what a pain!  He wanted to generate an excel file with links to files to quickly access the corresponding image. 

Tags: 

Pages

Subscribe to RSS - SQL Server