Amazon Web Services (AWS) vs Azure Features List

Posted on January 13, 2020 by blobeater

After much reading through the internet looking for Amazon’s equivalent of Microsoft’s Azure functions (Lambda), I found this outstanding link that ” helps you understand how Microsoft Azure services compare to Amazon Web Services (AWS). Whether you are planning a multi-cloud solution with Azure and AWS, or migrating to Azure, you can compare the IT capabilities of Azure and AWS services in all categories”..

This is extremely handy and wanted to share it with you.

https://docs.microsoft.com/en-us/azure/architecture/aws-professional/services

Continue reading →

Common Things Admins Miss in Azure SQL DB

Posted on January 8, 2020 by blobeater

This is by no means a complete list but more of a personal list of features I have seen not setup or just missed out when looking at Azure SQL DB. After reading, not only will I hope that you agree but it may provoke you to double check your setups.

Continue reading →

Azure SQL Database – Automatic Tuning – Have you enabled it?

Posted on December 9, 2019 by blobeater

Do you enable this setting to allow automatic tuning to care of all your performance needs? Well not ALL your needs, more so:

CREATE INDEX
DROP INDEX
FORCE LAST GOOD PLAN

Continue reading →

Execution Plans in Azure SQL Database

Posted on November 20, 2019 by blobeater

Yes you can still get execution plans for Azure SQL Database, you cannot get this from the Azure Portal so it is good to know for your tuning days. It is based on the same code you have probably run many times before. Lets get the plan handle and work through an example.

Continue reading →