RegEx Replace in SSMS

Refactoring Transact-SQL code can be a time-consuming and frustrating affair for the trusty code-reviewing Database Developer. This post shows several techniques I use to refactor code via the little-understood RegEx Replace functionality found in SQL…

Cleanup WSUS Synchronization Events

Cleanup Windows Server Update Services Synchronization History with this script. Windows Server Update Services provides a great way to cleanup things like old computers, unneeded updates, and update files from the Windows Server Update Services…