IG

Featured
Azure SQL DTU to vCore Migration Steps

Azure SQL DTU to vCore Migration Steps for PAAS Databases on Cloud

In this article, we are going to talk about Azure SQL DTU to vCore Migration. I have already spoken about the advantages of moving to a vCore based pricing model on a different...

Featured
How To Change Azure SQL DB MAXDOP Settings

How To Change Azure SQL DB MAXDOP Settings Using T-SQL Command

In this article, we are going to discuss how to change Azure SQL db MAXDOP settings. Since you have landed on this page, we expect you to have some background information on the...

Featured
Report Server Performance Tuning Best Practices

PowerBI Report Server Performance Tuning Best Practices (PBIRS)

In this article, we are going to highlight the PowerBI Report Server performance tuning best practices. Since the PBI report server is an enterprise reporting solution, it is...

Featured
Delete Azure Account Subscription

How To Delete Azure Account Subscription Permanently & Cancel Pay

If you want to delete Azure Account Subscription completely, then this article is for you. For starters, there could be multiple reasons why you would want to do that. You might...

Featured
Azure SQL Connection Pooling Best Practices

Azure SQL Connection Pooling Best Practices Pool Size & Exhaustion

In this blog post, we will be sharing the Azure SQL Connection Pooling best practices. Why is it important you ask? It is because connection pooling is a resource hogger, or in...

Featured
SQL Server 2019 System Requirements - Hardware & Software Prereqs

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...

Featured
Azure SQL Standard vs Premium

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...

Featured
Power BI Import vs Direct Query Feature Comparison & Limitations

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...

Featured
Azure SQL Database vCores vs DTU Feature Comparison

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...

Featured
Power BI Personal vs On-Premises Data Gateway

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...