If you have a Self-Hosted Integration Runtime (SHIR, or IR for short here) on an Azure Virtual Machine (VM), there’s a cost to keep it online. When used intermittently – for example during batch processes – this is inefficient for costs as you’re paying for the compute you don’t need. One way to alleviate this […]
The standard SharePoint connectors in Logic Apps authenticate with Entra accounts. When you want to use an App Registration instead, it’s a little trickier. In this post, we’ll show how to interface with the SharePoint REST API using an App Registration authenticated with a certificate securely stored in a Key Vault. Configure app registration First […]
One of the benefits which comes with a Managed Instance is having backups taken care of for you. That also includes restores. Particularly useful is a one-click (ish) restore for a specific point in time. Restoring a database is as easy as creating a new database, as its part of the same workflow. From the […]
Its the time of year where things may winding down for the new year and we can get a bit of breathing room. With that free time you might want to try something new, let’s say some SQL Server in the cloud? It could be a good time to start brushing up on new skills, […]
Connecting different versions of SQL Server can allow us to combine or transfer data between environments. This can become a challenge when the versions are really different. Have you tried to connect SQL Server 2008 to a SQL database in Azure? – it can throw up a few curve balls. In this post we’ll look at how […]
SQL Agent jobs allow us to schedule and automate tasks on a SQL Server instance. Crucially, when things go wrong we need to know about them. That’s why we use notifications. Setting up Operators and job Notifications is as expected on a Managed Instance. However, when it comes to sending the notifications we may have […]
A hierarchy of directories which contain files. That’s how we typically think about file storage. That’s not quite the same everywhere. In Blob Storage a file can appear to be in a directory, but when it’s removed so is the directory. This can occur when using Lifecycle Management to help purge legacy blobs, which can […]
A consumption based App Service Plan in Azure provides us with a pay-as-you-go model for Function usage. This can help reduce spend from Premium plans where those plans exceed the requirements of the function, for example low volume or intermittent work. Unfortunately you can’t move a Premium plan to Consumption based via the portal. Instead […]
In a Managed Instance, the SQL Agent job history is fixed at 1000 records or 100 records per job. This isn’t configurable like a regular SQL Server install. So how can we maintain a history of these if we want to retain those records? There are 3 approaches which could be worth considering. Two of […]
Shifting from handling data on premises to Azure has been a real change of mindset. Whilst what I want to build may be similar, the how part is completely different. There’s a learning curve not just to the tooling but how you use it too. This is one of those instances. I had a storage container with files which […]
Andy Brownsword 