SQL Server 2019 System Requirements – Hardware & Software Prereqs
In this article, we will be sharing the SQL Server 2019 System Requirements based on the current release from Microsoft. The 2019 edition is going to be a significant release for...
Azure SQL Standard vs Premium Specification Comparison & Differences
In this article, we will be comparing Azure SQL Standard vs Premium service tiers. We have also included the basic tier since it is widely used for development purposes. The DTU...
Power BI Import vs Direct Query Feature Comparison & Limitations
In this article, we will be comparing Power BI Import vs Direct Query methods for creating data models. You can either use PowerBI desktop or Excel to create data models using...
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...
