Category Archives: Technology

Strange Clicking Noise In Headphones

Strange clicking noises can sometimes be heard in headphones while sitting at your computer.  It often is fast clicking that slows over the course of five seconds or so, then stops, and then restarts in a few seconds.  This annoying noise wrecks a nice song experience. The solution?  Move your cell phone away from your… Read More »

Removing SSMS Boost

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… Read More »

Flickr Searching

Launch Flickr Searchr! Now you can search your own Flickr photos by camera model.  Strangely, Flickr has had the ability to search public photos by camera model, but not your own private photos by camera model. So, I have created a little tool that does the work for you at: http://benjf.com/flickr_searchr/.  Simply fill out the form… Read More »

TempDB Reporting Incorrect File Size

So what happens when you run a query to check TempDB file sizes and SQL tells you that each file is 101 MB, but when you look in the file system, they’re actually a 45 GB each? Also, when you try to shrink the file, the shrink file dialog window shows free space as a… Read More »

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

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… Read More »

TSQL – Make Excel Link In Output

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… Read More »