Azure Advisor – for Azure Data Platform

Posted on February 3, 2020 by blobeater

Wouldn’t it be nice if we could access one main dashboard / report that pulls in information from many tools such as security centre, SQL advisor and cost management tools? Well you can, thus giving you a focal point to implement best practices, called Azure Advisor. This is not specifically for Azure SQL Database, you can leverage this for most resources within Azure. Later in this blog post you see that I will use it as a focal point for my database infrastructure in Azure.

In the Azure portal under services look for “advisor”

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 →

Azure Storage Accounts – Open to the Internet?

Posted on October 3, 2019 by blobeater

Let’s get straight to the point. From official documentation it states that “To secure your storage account, you should first configure a rule to deny access to traffic from all networks (including internet traffic) by default. Then, you should configure rules that grant access to traffic from specific vnets. This configuration enables you to build a secure network boundary for your applications”.

Navigate to your storage account, what is the default setting? It is shown below.

Continue reading →