About Dan Stolts ITProGuru

Dan Stolts (The "ITProGuru") is a technology expert who is a master of systems management and security. He is proficient in many Microsoft products especially in the server area (Windows Server, System Center, Exchange, SharePoint, Virtualization, Etc) and holds many certifications including MCT, MCITP, MCSE, TS, etc. Dan is currently specializing in System Management and Security and is also very passionate about virtualization technologies. Dan is and has been a very active member of the community. He is president of Boston User Groups, Founder of Virtualization Group Boston, Founder of North East Leaders and serves on many IT Community group boards. He is in the process of writing his first book on building technology communities. He is a believer in social networking and can be reached on twitter @ITProGuru. He has participated in many non-technology community groups such as: Rotary Club, Lions Club, local Chambers of Commerce and is a mentor for the local high schools. Dan is an enthusiastic advocate of technology and is passionate about helping others. Dan's lifelong passion has been and continues to be to help and teach others!
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

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

Aug 29

The Super Simple Way To Backup Your Infrastructure – Leverage Azure Storage – How To Backup To Azure Step-By-Step

In this detailed post and hands on lab (HOL) guide we will introduce Windows Azure backup and dive in deep with step-by-step instructions you can use to schedule a backup, perform a manual backup of your server and perform a … Continue reading

Aug 21

Awesome Tool – Estimating costs for migrating workloads to Azure with Azure IaaS Cost Estimator Tool Step-By-Step

Have you seen this incredible tool.  Microsoft hit a home run with this little gem.  The Azure Cost Estimator Tool will allow you to scan a machine, a virtualization host or even an entire Virtual Machine Manager Network.  The Azure … Continue reading