Today, a need came-up where a bunch of stored procedures had to be altered based on certain criteria. Easy way: Obviously, the easiest way would be to script out the stored procedures to a file/editor and do Find/Replace with the UI dialog. However, this does not work if there are lots of stored procedures and … Continue reading PowerShell: Find & Replace SQL Server Stored Procedure Code En Masse Based On Custom Criteria
This is one of those fresh ideas I wish I had but in reality it did not occur to me until it came down to me for execution from above me. Good job managers! Kudos. Sorry, I did not come-up with this! Execution: "I can do really well and you have got the best". I … Continue reading PowerShell: Save Millions By Downgrading Your SQL Server Edition & Partially Automate It!