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… Continue reading Select and Start a SQL Job without knowing the full job name or history
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… Continue reading How to fix my SSMS Help F1 problem
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… Continue reading How to create a DacPac
