Microsoft SQL – How to use variables
In this post we are going to cover how to declare, set the value and use a variable in a Microsoft SQL. What is a variable? Before we get into how to use them, it is best if we define …
Tips
Microsoft Teams – Channel name is already taken [Fixed]
I mistakenly created a Teams Channel as a standard channel when I needed it to be a private channel. At the time of writing Microsoft do not let you convert a channel form one type to another. No worries I …
Azure Data Factory – How to backup and restore a pipeline
I think we can all agree that backups are only a good thing, they form the bread and butter of any IT administrators’ tasks. In this post I will cover how to export and import an Azure Data Factory Pipeline …
Setup a Laravel Valet Development Environment on MacOS
In this post I will cover how to setup a Laravel Valet development environment on MacOS. At the end of this post, we will have performed a basic setup of Laravel Valet and created a new Laravel site that we …
Microsoft SQL – Saving changes is not permitted (SSMS Design Mode)
Have you ever attempted to alter the design on a Microsoft SQL table using the Microsoft SQL Server Management Studio (SSMS) tool. Maybe, to add an additional column, or change an existing columns data type, only to be greeted by …
SPF, DKIM and DMARC Confused?
When it comes to securing your outgoing email domains from those who want to impersonate you or your business. There are various technologies you can implement to add protection and build customer trust. In this post we will cover SFP, …
Azure Data Factory – Getting start or end of week dates
In this post I will cover methods to get the start and end for the current, previous and next week using an Azure Data Factory Pipeline expression. I have a few pipelines which only run once a week that need …
Azure AD – Storing custom user data for Enterprise Applications
I recently had the requirement to create a new Enterprise Application in my Azure Active Directory tenant. This was to get a third-party SaaS application to work with Single Sign-on for my users. The provider of the SaaS application also …
Azure Data Factory – Get and Use Key Vault Secrets
I have occasionally found that I need to use keys, passwords, or other sensitive strings as part of my ADF Pipelines. While it is completely possible to store this data in parameters against the Pipeline, it is not the best …
Microsoft Graph and Invoke-RestMethod [PowerShell]
While the PowerShell Microsoft.Graph modules are great, Microsoft Graph is an API opening many different methods for reading and writing data, including via the PowerShell Invoke-RestMethod command. But why use Invoke-RestMethod instead of one of the many Microsoft.Graph module commands? …
