My answer to this month’s T-SQL Tuesday topic is rather dependent on my workplace. So long as the database code is covered by version control…
Tag: SQL Server
Last year I wrote about the formats of connection strings that can be stored in Azure Key Vault & then used by Data Factory, &…
Aim: To utilise Azure Data Factory’s “Auto create table” feature to temporarily store data as part of an ETL pipeline. There are some situations where…
As I explore Data Factory, I’ve started to compile a list of lessons learned. Some things that may trip up a new user of the…
Using Azure Data Factory & Azure Key Vault, I connect to a few core databases (usually Azure SQL Database & traditional SQL Server instances) &…
Following on from my last post, I had decided that automating the step to stop SQL Server would be a better option than relying on…
At home, my test environment for SQL Server runs on a Windows 10 PC. It’s the same PC that I use to do a bunch…
SQL Server Database Mail & Agent Alerts are a free, easy way to get notified of corruption, errors & job failures before users report problems.…
One thing that threw me the first time I connected to an Azure SQL Database in SSMS using a non-admin account was the requirement to…
I came across this error recently on a VM with multiple SQL Server instances installed. Initially a SQL 2016 instance had been installed & some…