Proven Tips for Microsoft MCSA: SQL Server 2012/2014 Certification and 70-463 Exam

There’s nothing more satisfying than achieving your goals. Every IT professional dreams of rising through the ranks and attaining the topmost Microsoft certification in the long run. However, obtaining the highly covetable MCSA and MSCE certifications is never a walk in the park. But as tough as the journey might get, the prospect of enjoying the potential benefits of these certifications in the future should keep you going. This article outlines the key aspects of…

SOLVED: Veeam Error Copying Data from Deduplicated Volumes Requires That The Console Is Installed on Windows Server 2012 R2 or Later

When performing file restores using Veeam you may see an error that says: Copying Data from Deduplicated Volumes Requires That The Console Is Installed on Windows Server 2012 R2 or Later.  This message appears when the data you are restoring was originally stored on a server with Windows Data Deduplication enabled. Fortunately all you need to do to get around it is to install the Data Dededuplication Console on the server that hosts your Veeam.  You…

SOLVED: Performance Differences Between Azure Storage Data Centers Sites

If you are considering using Azure Storage via Azure File Sync or Azure File Share, you need to know how fast files transfer.  To figure this out we setup Azure storage shares in Toronto, San Antonio, California and Ireland than ran some tests. Specifically, we used Azure File Sync which moves ALL of the files to the Microsoft Azure cloud but lets you cache files on your local servers to dramatically increase performance of your commonly…

SOLVED: Azure File Share Connection Problems

If you are using Azure File Shares you will find connection errors on various Operating Systems and configurations.  This article is designed to tell you what you need to know quickly. Azure File Share Requirements: SMB3 : You need to be on Windows 8.1 or above or Windows Server 2012 (original ‘R1’) or above because Azure File Sharing requires SMB 3.0 See the OS/SMB table at the bottom of this article for more details .…

SOLVED: VIDEO: How To Allow Other Azure Administrators to View & Modify Your Work

If you are working with Azure and other Azure administrators cannot see your work, the problem is likely permissions. In this video we show how to grant admin rights to other Azure admins: Log into portal.azure.com as the administrator you created the changes in Click ALL SERVICES and find SUBSCRIPTIONS Click on the Subscription in question Click ACCESS CONTROL (IAM) Click ADD ROLE ASSIGNMENTS Select OWNER from the ROLE drop down list Find the person you…

SOLVED: How To Deregister A Server Endpoint From Azure Storage Sync

If you are using Azure Storage Sync and want to remove a on-premises server you may be tempted to just DELETE it from the the SYNC GROUP, but that will not do the trick. If you want to deregister / unregister an on-prem server from Azure Storage Sync you have to: Go into STORAGE SYNC SERVICES Click on the Sync Service in question Click REGISTERED SERVERS Click on the server you want to remove Click…

SOLVED: How to Upgrade or Install Windows Server 2016/19 Standard VM on a Windows Server Data Center Host

The short version is that if your host server is running Datacenter you can NOT upgrade an existing Windows Server 2016/2019 STANDARD Virtual Machine to anything but Datacenter.  If you try you will see that Windows Server STANDARD is missing and not an option from the list.  The way it was explained to me is: Datacenter upgrades to Datacenter ONLY.  Windows Server Standard is missing from the upgrade list, by design: There is also no…

SOLVED: VIDEO: A 2019 Review of the Huawei P10 Lite With Android 8

The Huawei P10 Lite was released on March 27, 2017 but is still a good device today in 2019.  We recently tested a Google / LG Nexus 5X and have very little good to say about that units build quality. We just bought a P10 used and want to show you how to get through a few configuration issues, like hiding unwanted apps and bloatware from the home screen and setting the wallpaper to not…

SOVLED: VIDEO: How to Hide or Remove Apps from A Huawei Home Screen

If you have a Huawei cell, like P10 or P20 Mate / Lite you will find that having all of the app shortcuts on on the “home screen” like an Apple iPhone, makes it difficult to use. Fortunately, there is an easy way to hide / remove the apps / bloatware you do not want to see by enabling what Huawei calls their App Drawer. We show you how to hide / remove less used…

SOLVED: Azure General Purpose v2 Storage Pricing Demystified

If you are new to Azure, the wide variety of pricing can be overwhelming (for us too!), so we reviewed the numbers to come up with some simplified calculations. Yes, we know these are oversimplifications but if you just need to wrap your head around the scale, these metrics should help. HOT vs COOL PRICING Hot is 80% more expensive than Cool storage Hot is nearly free for read’s, while Cool costs about one and…

SOLVED: VIDEO: How To Setup Azure File Sync From Nothing In Just 20 Minutes

The instructions and video below assume you know very little about Azure and have nothing but a Windows Server 2016 (or 2012R2 or 2019) server. In case you don’t already know, Azure Storage lets you create a real UNC share on to an Azure cloud disk, kind of like what many people thought One Drive For Business was going to do.   You can also use Azure File Sync to take old files from your existing…

SOLVED: How To Remove A Unwanted GUEST Account From Teams

If you have previously accepted an invitation to join a Team as a “Guest” from outside your organization, it is far from obvious how to remove that account when you are done with it. To remove an unwanted Guest account in Teams: Surf to https://myapps.microsoft.com Click you icon in the top right corner and then the ORGANIZATIONS cog Click  SIGN IN TO LEAVE ORGANIZATION beside the organization you don’t want to be connected to anymore…

SOLVED: How To Tell If Microsoft Is Having Problems

If you are working on Microsoft connected systems (Office 365, Azure, Windows Update…) and you see some odd behavior, it might not be you.  The question then becomes, where can you go to see if Microsoft is down? We use the following five sites to see if Microsoft is having problems or is in a full outage: Windows Update Status: isitdownrightnow.com/update.microsoft.com.html  Office365 Status: portal.office.com/Adminportal/Home#/servicehealth Azure Status: azure.microsoft.com/en-ca/status Microsoft in General: outage.report/microsoft XBox Status: support.xbox.com/en-CA/xbox-live-status  

SOLVED: VIDEO: How To Create a Sunburst Chart In Excel

If you want to get a bunch of data that you need to get into peoples heads, you need to convert that data to information.  The best way to accomplish this is with a graphic.  In this video we will show you how to very easily convert the information in the tiered Excel sheet below into a much more meaningful sunburst graphic. Energy Stationary Combustion Mining & Upstream Oil & Gas Production 105253 Public Electricity…