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 02

How To Allow Remote Desktop Services RDP and Ping ICMP Through Windows Firewall–Step-By-Step

Create Firewall Rules in Windows 7 thru Windows Server 2012 R2  to allow RDP and ICMP traffic for you have to open “Windows Firewall with Advanced Security” control panel applet.  You can get here by typing “firewall” in the search … Continue reading

May 23

How To Enable Snipping Tool, Windows Media Player and more Desktop Experience Tools on Windows Server 2008-2012 R2

Are you annoyed that you cannot play videos or use some of the cool windows tools like snipping tool with windows server?  Well, you can, they just have to be enabled before you can use them.  Below are instructions for … Continue reading