Aim: To capture SQL Agent job history to a table. Following on from the previous blog post about adjusting the size of the SQL Agent…
The Right Join
Aim: To adjust the size of the SQL Agent job history log to retain more or less history as required. On some SQL Servers with…
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 often find that Excel files contain special characters that must be cleansed before or during processing. In the cases where the data must be…
This is another trick gleaned from exploring data to be imported to a Data Warehouse from an Excel spreadsheet. Sometimes we are provided data in…
Recently I came across a situation where a view took an excessive amount of time to return results when “SELECT TOP …” was applied to…
There is a difference between shutting down an Azure VM from outside vs from within the VM. Stopping the VM from outside (e.g. from the…
I administer SQL Servers that have several log shipping jobs, enough that manually disabling & enabling them (e.g. for maintenance windows) is tedious & time…
As part of a data warehouse project that I’m working on, I need to be able to grant or deny access to users. I do…
Aim: In my last blog post, I recorded a sample query for processing JSON in SQL Server so that I can refer back to it…