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