Azure SQL Database – Scaling up

Scaling up and down your SQL Database is something that is quite common to do. I want to discuss the...

SSMS and MFA support for Azure SQL DB

Quite a mouth full for a title but never the less very exciting. With the new version of SQL Server...

Azure Cloud “Fear” Busting #4 – Losing Control?

So the decision to move to the cloud has been made but there is a fear from people that once...

Azure Automation and SQL Index Maintenance

Azure does a lot for your SQL Database, from backups to automatic tuning but it still doesn’t have an index...

SQL Server – So you like to shrink do you?

If you do – shame on you and shame on me because I do.

Moving on, I found strange behaviour within SQL...

Interviews and Oranges

What a great topic for this month’s T-SQL Tuesday hosted by Kendra Little https://littlekendra.com/2017/08/01/tsql-tuesday-93-interviewing-patterns-anti-patterns/

The topic being: Interviewing Patterns and Anti-Patterns....

Azure Cloud “Fear” Busting #2 – Seeking for Better Performance

We all want high performing applications and when you are in the cloud that is no different, if anything it...

Azure Cloud “Fear” Busting #3 – There is no going back?

Once you go cloud, there is no going back.  This is false and from a database perspective you can migrate...

Azure Cloud “Fear” Busting #1 – Security

So here we go, the first installment of my cloud blog series. From my experience this concern is a common...

SQL Server Rookie Mistakes

A quick elementary post which is my entry to this months’ T-SQL Tuesday entry hosted by a good friend SQLDoubleG...