As I wrote back in 2020, Microsoft provide a really easy way to allow you to connect Azure Services to Azure SQL Database that, in…
The Right Join
This is going to be a quick post as it’s mainly a reminder to myself about how to deal with this error if I ever…
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…
Writing this the week after SQLBits 2023, I’m realising that it’s the type of thing that I probably should have done at the start of…
Identifying the permissions required for this was a case of trial & error, & some Googling until I came across a couple of Microsoft Developer…
Applying a Lock to an Azure SQL Server can protect the databases in that SQL Server because child resources inherit locks from their parent, but…
SQL Server Database Mail & Agent Alerts are a free, easy way to get notified of corruption, errors & job failures before users report problems.…
When adding existing items to a Visual Studio database project, it is sometimes necessary to adjust the item’s properties. This particularly applies when adding pre-…
Per Microsoft documentation for SSRS, it’s possible to add an action to an object that will allow you to jump (drillthrough) from one report to…