Lesson Learned #60: Using Partition Option in Azure SQL Managed Instance

Hello, Time ago, we discussed in this post about partitioning option in Azure SQL Database. One of the main differences creating this partition in Azure SQL Database is all partition will use the same filegroup. In Azure SQL Managed Instance we could create different filegroups and files for each partition having a better performance having multiple…


Lesson Learned #43: Using partitioning option for Azure SQL database

Some days ago, I have been working on advisory service request where our customer asked for partitioning option for Azure SQL database. They found the guidelines but when they tried to implement it, they got the error message: ‘filegroup’ is not supported in this version of SQL Server. Trying to answering the question, partition is supported on Azure SQL Database but…