The Good The Bad and The SLA

Lets just get straight to the point, Azure SQL Database across all service tiers gives you the customer a SLA of 99.99% up-time. This means potential unavailability periods shown below.

Continue reading

SQL Reserved vCores

Have you ever heard of SQL Reserved vCores? Well I never until recently.  With this concept you have the ability to save money by PRE-PAYING for your compute resources for Azure SQL DB where you might be currently using a pay-as-you-go plan.

Continue reading

SQL Agent for Azure SQL Database? Not quite

The following post shows my preferred way to automate / schedule some code against my Azure SQL Database. No it is not PowerShell or Azure Runbooks but it is definitely my favourite way.

Continue reading

Azure SQL DB – Login failed for user NT AUTHORITY\ANONYMOUS LOGON.

Now that I have your attention with a powerful title how about some context? It is quite common to get this error message when trying to connect to your Azure SQL Database which obviously resides on a “logical” SQL Server.

Continue reading

Azure SQL DB – Login failed for user NT AUTHORITYANONYMOUS LOGON.

Now that I have your attention with a powerful title how about some context? It is quite common to get this error message when trying to connect to your Azure SQL Database which obviously resides on a “logical” SQL Server.

Continue reading