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 …
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 …
Git failed with a fatal error “Authentication failed”
I recently opened Microsoft Visual Studio for the first time in a long while and attempted to clone a repo from an Azure Dev Ops. Only to be greeted by the message. Git failed with a fatal error “Authentication failed” …
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 …
SQL – The SELECT permission was denied [FIXED]
Recently I had to solve an issue with a users permissions to Microsoft SQL. When running a report from Microsoft Excel, they would get the message; Unable to connect We encounter an error while trying to connect. Details: “Microsoft SQL: …
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 …
