MSSQL - Fixing Transaction Log backups failing with error "@@SERVERNAME does not match SERVERPROPERTY('ServerName')"

To Fix Transaction Log backups failing with error "@@SERVERNAME does not match SERVERPROPERTY('ServerName')" you can simply run the following to verify that the machine name and server name property are the same:


If not, you must fix it manually and RESTART SQL - replace oldname and newname with the new name of the SQL server.

sp_dropserver 'OLDNAME;
sp_addserver 'NEWNAME', local;

What is a DPOR (Designated Partner of Record) - Azure Knowledge

The DPOR stands for designated partner of record. This is a delegation you can add to your Azure subscription that I partner may request. This request allows the VAR, MSP, or consulting group to get benefits for assisting their partner in Azure.

By entering in the partner information when requested your really help your partner out :)

More information here:

Tip 0001: Invoke-Webrequest for a specific hostname without a host entry

My imposter "Ah-ha" moment of the day is finally realizing that you can invoke-webrequest for a specific hostname without setting a host entry by using the invoke-webrequest cmdlet with the host header.

Ie: invoke-webrequest -Headers @{Host = ""}

Blogs for Azure Information

Here are some of the blogs that I follow for information around new features in Azure, OMS, Log Analytics, Azure Monitor, etc.

Azure Monitoring Services Health Status
Microsoft Azure Roadmap
System Center Me
Quae Nocent Docent (Great weekly OMS, SCOM, and Azure Info)
Operations Management Suite Blog

AWS - Basic EC2 / Snapshot Cleanup

As you migrate from AWS to Azure ;) you may find that you need to clear up resources to save costs.

For example, you may continue to incur costs for snapshots after you de-provision your EC2 instances (virtual machines, for the lamen).

To clear out the snapshots you can use the AWS Powershell commands to clear out any snapshot older then 90 days.

See the example below - by default Get-EC2Snapshot will show all public snapshots, so the -owner self switch is required.
Get-EC2Snapshot -Owner self | ? { $_.StartTime -lt $(get-date).adddays(-90)} | Remove-EC2Snapshot  This command may show an error indicating that a Snapshot is still in use.
Remove-EC2Snapshot : The snapshot snap-xxxxxx is currently in use by ami-xxxxxxx

Configuration Management with Salt Stack on Windows - Part 3 - Basic Configuration Management of Windows with Salt

In part 3 we're going to just scratch the surface of remote execution in Salt. We're going to accept the keys for the master server and  run basic tasks using the built in modules.

The minion automatically tries to contact the Master server. The master server must approve the minions "keys" before it can be managed.

On the master server you can view the keys by using the command
sudo salt-key -L
As you can see we need to accept the "keys"

You can accept the key by using the command
sudo salt-key -a WIN-R7RQM4ENMHS

Configuration Management with Salt Stack on Windows - Part 2 - Configuring Salt Minion with Vagrant

This is part two of a series of basic configuration management for Saltstack for use in an Windows environment. In this guide we'll be covering the basics of setting up Salt Stack Windows minion on a test machine on Vagrant. Part 3 we will be diving into the meat and pushing some buttons automatically with the Salt Master.

In order to create a test minion, we'll be using a Windows Server 2012 R2 vagrant image.

vagrant init mwrock/Windows2012R2 vagrant up  Once the machine is online you can login with vagrant / vagrant.

The download for the salt minion can be found on

Or the direct link:

The Windows installer is straightforward - just enter the Master IP or Hostname for the Salt server. We're not going over the internet, so I entered the Private IP. If you use the default "hostname" option, it will…