How to use variables with Microsoft SQL
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 …
SQL
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: …
MS SQL – Copying a Linked Server Table
I recently used the following TSQL on a Microsoft SQL server to create and populate a table from a table on a linked servers. In my case my linked server connection was linking to a MySQL database but the same …
Azure SQL Creating a User
The following steps detail how to use SQL Management Studio to add a user to an Azure SQL database. How to give that user permissions and additional steps for the mirror server if you are Geo replicating the database This …
SQL – Use of WITH CREDENTIAL syntax is not valid for credentials containing a Shared Access Signature
Overview Recently I wanted to create a SQL Backup Maintenance plan that would backup to an Azure storage blob container. After completing the GUI the backup step would not complete, instead I got the error “Use of WITH CREDENTIAL syntax …
PowerShell – How to save an SQL query results to an CSV file
The following is an example PowerShell script to connect to a Microsoft SQL Database and dump the results of a query into a CSV file. You will need to change the connections variables at the top of the script along …
Unable to manually failover a SQL Availability Group
Problem After recently setting up a SQL Availability Group my automatic and manual failovers were not working. When I attempted a manual failover I received the error “Failed to perform a manual failover of the availability group“…..“Failed to bring availability group …
SQL Availability Group Setup – The local node is not part of quorum
Problem While trying to set up a couple of SQL Enterprise servers in an Availability Group I kept getting the message “The local node is not part of quorum and is therefore unable to process this operation” I had already …
My Manage Engine Service Desk Plus SQL Queries
The company I work for uses Manage Engines Service Desk Plus for it’s ticketing system. It is great product and has some good inbuilt reporting features, however for my needs I use a suite of SQL queries to pull data …