Occasionally I have to process data from Excel spreadsheets as part of my data warehouse work & usually these files require a bit of a…
Tag: Productivity
I was told about a cool feature in SSMS recently: the ability to copy multiple strings to the clipboard & then cycle back through that…
I administer SQL Servers that have several log shipping jobs, enough that manually disabling & enabling them (e.g. for maintenance windows) is tedious & time…
Aim: Rename objects in SQL Server Data Tools (SSDT) without breaking dependencies. You can rename SSDT objects in their definition (.sql) files however this does…