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…
The Right Join
Aim: To remove unnecessary information from SSMS query tabs, to make them more useful & easier to read. I was reminded of this very useful…
Aim: To script multiple database objects using the Object Explorer Details window in SQL Server Management Studio (SSMS). It’s not possible to script multiple objects…
Aim: Schedule daily backups of an on-premises SQL Server database & copy it to an Azure virtual machine as part of a Disaster Recovery process. In…
I recently encountered this error when attempting to run Add-AzureAccount using Azure PowerShell on a Windows 8.1 machine. The error occurred regardless of whether I…
Aim: Create a virtual network & machine in Azure to which on-premises SQL Server databases can be backed up as part of a Disaster Recovery process.…
Some time ago, I encountered an apparently failing backup job on a SQL Server 2008 R2 instance. The job used the Back Up Database Task…
Aim: To allow remote connections to a SQL Server named instance. These steps are useful as a basic troubleshooting guide when you are experiencing problems connecting…
As of early 2016, I find the new Azure portal very unintuitive to navigate & unfortunately the Microsoft documentation seems to be work-in-progress, so I’m starting…
Aim: To use an SSIS Script Task to import csv files where the metadata is different for each file. Recently I had a task to…