Select and Start a SQL Job without knowing the full job name or history

So I was trying to figure out how to get the TLog backup job's name based on Back History because in this case, the job name happens to vary between SQL Server Instances. Sounds simple enough (well...not quite), then I realized for new SQL Server instances this job might not have even ever ran...so there went…

Advertisements

How to fix my SSMS Help F1 problem

While using SSMS2012 my coworker had an issue that when he hit F1 it would launch the local copy of help but wouldn't direct him to the specific help section for the selected keyword. ie. New Query window, type Highlight DISTINCT and hit F1. Well SSMS would simply open the local MSDN Books he had installed…

How to create a DacPac

Over coffee with friends we got talking about dacpacs and other stuff. Later, Friend1 still had questions over skype about how to install it and such. I replied but he was gone. So I figured, I better send him some instructions and screenshots by email. From: Fleitas, Hiram Sent: Tuesday, January 10, 2017 5:52 PM…