IG

Featured
SQL Server 2019 Always On Availability Groups

SQL Server 2019 Always On Availability Groups new features – Whats new

If you are a DBA or a Database architect, our article on SQL Server 2019 Always On Availability Groups should be of interest to you. SQL Server availability groups were first...

Featured
SQL Server Managed Instance BYOL Hybrid Licensing & Dev_Test Options

SQL Server Managed Instance BYOL Hybrid Licensing & Dev/Test Options

Microsoft offers SQL Server Managed Instance BYOL Hybrid Licensing for your On-Premises products and discounted pricing for Dev/Test environments. Since managed instances are...

Featured
Azure SQL Managed Instance General Purpose vs Business Critical

Azure SQL Managed Instance General Purpose vs Business Critical

In this article, I will try to compare the Azure SQL Managed Instance General Purpose vs Business Critical service tiers based on the information available online. While comparing...

Featured
EROFS vs Squashfs

EROFS vs Squashfs – Whats the difference? File Systems Comparison

A file system is an essential element in any computing system. This is what would determine how you save your data and retrieve it. We have access to numerous file systems...

Featured
SQL Server Hybrid Backup to URL on Azure Storage

How to do SQL Server Hybrid Backup to URL on Azure Storage in 2019

The SQL Server hybrid backup to URL feature offers flexibility to customers. It provides an additional layer of fault tolerance for your valuable backup files and stores them on...

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