Azure SQL Database vCores vs DTU Feature Comparison
In this article, we are going to compare Azure SQL Database vCores vs DTU pricing models. While DTU was perfect for small to medium deployment, the concept of DTU created a sense...
Power BI Personal vs On-Premises Data Gateway (Enterprise Gateway)
In this article, we will try to objectively understand the differences between the Power BI Personal vs On-Premises Data Gateway and understand their coexistence. First, let us...
PowerBI Data Refresh Limitations & Restrictions for Pro and Premium user
In this article, we are going to highlight some of the PowerBI Data Refresh Limitations and restrictions. However, you will have to understand that, not all “Data...
T-SQL Performance Tuning on Bulk Load Data in SQL Server 2017
In this article, we are going to talk about a specific scenario where T-SQL Performance Tuning is required for bulk load operations. This scenario aims to improve SQL Performance...
How To Find The IP Address of a Network Printer From Command Line
If you work in a big organization, you might have a couple of network printers. In fact, network printers are the only options for large corporations and other networked devices...
Resolve & Fix – Windows Firewall fails to launch – Error 5 on Windows 10
When Windows Firewall fails to launch it may lead to security risks, especially when your device is connected to the internet. Windows Firewall is perhaps the first layer and one...
How to use Azure Ad Join on Windows Server 2019? & Gateway Access
Just like Microsoft Windows 10, the Microsoft Server 2019 also lets you make use of Azure AD authentication. We will guide you through the process for using the Azure AD join. If...
ReFS vs NTFS – The Differences Similarities and Feature Comparisons
ReFS vs NTFS anyone? If you have been using Microsoft products for long, you should be aware of the new ReFS file system recently announced by Microsoft. The term is the short...
What is a VPN? VPN Types & How To Setup VPN with Best Free Options
In the emerging world, the Internet was used only by a select few just a few years ago has become one of the widely used medium over the years now. This huge spike in usage has...
How To Check & Fix Index Fragmentation on SQL Server via Script & ssms
Before we learn to fix Index fragmentation on SQL Server, let us understand why this happens. Indexes can be fragmented primarily due to data modifications over shorter or longer...
