Tag: How To
-
How To Get The Most Out Of Your Windows 8.1 Keyboard And Mouse – Shortcuts Galore
How do you navigate in a touch world without a touch device? I am glad you asked. This post will address that question in great detail but we will also look at all the other great things you can do with keyboard and mouse shortcuts. Read It, to understand what you have been missing. Bookmark…
-
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 a checkbox under Pivot Table options but I could not get it to work …
-
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 or customer office where the IT department has blocked port 3389. There is a new…
-
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 migrate to a VM running SQL Server. The methods that you chose to move will…
-
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 (and video), 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. The generic message “Login Failed for User (Microsoft SQL Server, Error: 18456)” means…
-
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 space on one of our volumes so we can order drives and get them install…
-
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 box near the start button and selecting it from the list (likely on top) or…
-
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 test restore.The post assumes only that you have a server that you want to backup…
-
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 (IaaS) Cost Estimator has been designed keeping in mind the need to provide the IT…
-
Assessing Current IT infrastructure with Microsoft Assessment and Planning Toolkit (MAP) AND BONUS-Evaluate for Migration to Azure Cloud
The Microsoft Assessment and Planning Toolkit makes it easy to assess your current IT infrastructure for a variety of technology migration projects. This Solution Accelerator provides a powerful inventory, assessment, and reporting tool to simplify the migration planning process. It is one of many solution accelerators from Microsoft. Solution Accelerators are free, scenario-based guides and…
-
Deploy SQL Server 2014 VM on Azure Cloud and Configure with Adventure Works DB–Step-By-Step
Part 1: Creating SQL Server Virtual Machine on Windows Azure (using the new portal) Step-By-Step 1. Login to Windows Azure Portal 2. Click New in the lower left corner 3. Click SQL Se3rver 2014 Standard 4. Enter Host Name, User Name, Password (Host Name must be unique system wide, username cannot be “admin” password…
-
How to Access the New Windows Azure Portal–Switch Azure portals–Step-By-Step
You can go directly to the new portal at http://portal.azure.com The production Azure (main) portal is http://portal.windowsazure.com Once you are on the new portal, you can switch to the Azure portal by clicking on Azure Portal from the HOME screen From any screen, you can also click on your name in the upper right…
-
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 enabling these features in Windows Server 2008 and in Windows Server 2012 (slightly different instructions)…
-
How To Convert Physical to Virtual Machine (P2V) Migration – Step By Step – MUCH Easier Than You Might think!
I found a great article I wanted to share. If you use the Disk2VHD, be careful of SCSI and Raid controllers. Test booting and running the VM before you blow away the original disk; you have been warned :} … In previous posts, I have shown you how to export and import machines from one…
-
How To Sysprep – Sysprep is a Great And powerful tool And Easy Too If You Know How (Step-By-Step)
Sysprep is a tool that is designed for system administrators, Original Equipment Manufacturers (OEMs), and others who must automatically deploy an operating system on multiple computers. After you perform the initial setup steps on a single computer, you can run the Sysprep tool to prepare the sample computer for cloning. However with the propagation of…
-
How To Get The Most Out Of Your Keyboard And Mouse – Shortcuts Galore
How do you navigate in a touch world without a touch device? I am glad you asked. This post will address that question in great detail but we will also look at all the other great things you can do with keyboard and mouse shortcuts. Read It, to understand what you have been missing. Bookmark…
-
Install Windows Azure PowerShell Cmdlets Step-By-Step Connect to Windows Azure Includes Importing MSOnlineBackup Module
There are two ways you can authenticate to Windows Azure. You can store a username and password or you can use a certificate. If you want to authenticate with a password see How to: Connect to your subscription My preference is to use a certificate. Certificate Authentication The Windows Azure PowerShell module includes cmdlets that…
-
Backup Windows Server Using Windows Azure Backup 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 test restore. The post assumes only that you have a server that you want to…
-
Activate Free MSDN Windows Azure Account From BizSpark benefits
By Now, you should have a LiveID / Microsoft Account. You are enrolled in the BizSpark program so now we need to activate your Free MSDN Windows Azure Account. Login to your BizSpark account (http://www.microsoft.com/bizspark/default.aspx). Click My BizSpark from the top navigation Click on Get your free software! Then click Download Microsoft Software (via MSDN)…
-
Windows Server 2012 R2 Backup Full Integration with Windows Azure Backup #WhyWin2012R2
If you have a small number of servers to protect and you currently have no backup solution, you are using the in box Windows Server backup tool on these servers, or use a third party backup solution, Windows Azure Back may be a viable option for you. If you have a larger infrastructure and already…