Oct 26

How to Hide, Replace, Empty, Format (blank) values with an empty field in an Excel Pivot Table without using filters –Step-By-Step

I have been struggling with this for a while.  Excel puts the word (blank) on  a pivot table field if it does not have any data.  I want the field displayed without data.  I see in Excel 2013 there is … Continue reading

Sep 23

How To Create Windows Server for Remote Desktop (RDP) To Be Used While Port 3389 is Blocked-Azure VM Step-By-Step PLUS Anywhere Access Configuration

You could of course manually configure RDP to listen on different ports to allow connection from other standard or non-standard ports.  In my case, I need to be able to RDP to an Azure Virtual Machine from a local school … Continue reading

Sep 23

How To Move or Migrate SQL Server Workload to Azure Cloud Services – All version of SQL Server – Step-By-Step

There are many options for migrating SQL databases to Azure. With the latest technology you can move just the database and log files, or you can move the entire system.  You could move to Azure SQL Database or you could … Continue reading

Sep 23

How to Fix Login Failed for User (Microsoft SQL Server, Error: 18456) Step-By-Step – Add SQL Administrator to SQL Management Studio

In this post, I will teach you how to determine what user has administrative rights on the server as well as walk you Step-By-Step how to configure SQL Server to allow other users to login as Administrators to SQL Server.  … Continue reading

Sep 19

Monitoring Hybrid Cloud – Step-By-Step

It is always important to understand how our server workloads are doing.  Getting visibility into our systems allows us to proactively deal with future issues.  As an example, monitoring can let us know that we are running out of disk … Continue reading