-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

All About SQL

I am a Senior DBA with interest in MS technology especially SQL Server and Azure. During 2015 I was mentored by Paul Randal – Data Platform (SQL Server) MVP and during 2016 I completed my SQLskills Immersion training on Internals and Performance Tuning. When I am not working I am in the gym burning calories.

SQL Server Backup To Azure Storage

Once again I would like to share with you an article I wrote about backing up (and restoring) a SQL Server database to Azure Blob Storage. In this article I write about some important concepts and show you the code … Continue reading

Read more

1 comments, 128 reads

Posted in All About SQL on 19 December 2018

Azure SQL Database DTU Versus vCore

I wrote a guest article for an IT consultancy on Azure SQL Database, more specifically DTUs and vCore options. At a high level I discuss what both options are, the differences and what you should select. Hopefully you will find … Continue reading

Read more

0 comments, 198 reads

Posted in All About SQL on 17 December 2018

SQL Server I/O

Sometimes I like to see and know what SQL server is doing under certain operations and recently I wrote an extended events script to see what sort of I/O patterns my query was doing (This is a fun post). The … Continue reading

Read more

1 comments, 150 reads

Posted in All About SQL on 11 December 2018

Azure SQL Database “Step By Step” Tutorials

I would like to share a link to my Azure SQL Database Stairway series hosted over at SQLServerCentral. As stated on the website a stairway guide is a series focused on a single topic and is arranged into no more … Continue reading

Read more

1 comments, 352 reads

Posted in All About SQL on 6 December 2018

Azure SQL Database – Firewall Rules

If you decide to use IP addresses to control what services have access to your Azure SQL Database, then understanding firewall rules are important. Within this important area you have the ability to create firewall rules that are scoped to … Continue reading

Read more

1 comments, 167 reads

Posted in All About SQL on 4 December 2018

Microsoft Professional Program vs Microsoft Certification

When learning new technologies many people will go towards training courses (in person or online) but many also go for certifications such as MCSA / MCSE, which I no longer pursue for many reasons. Microsoft now have this idea of … Continue reading

Read more

2 comments, 181 reads

Posted in All About SQL on 15 November 2018

Azure SQL Database – Fixing My Scaling Failure

This is kind of a follow up from my last blog post about a scale down request issue. (https://blobeater.blog/2018/11/07/azure-sql-database-aborting-scale-request/) I was confused, so confused that I ended up logging a support request with Microsoft. The issue was I wanted to … Continue reading

Read more

2 comments, 165 reads

Posted in All About SQL on 14 November 2018

Azure SQL Database – Aborting Scale Request

Scaling up or down an Azure SQL Database is a very common task. Whilst common it is also very easy to do via the Azure portal or even PowerShell. When you scale a database please be aware that  it creates a … Continue reading

Read more

1 comments, 221 reads

Posted in All About SQL on 7 November 2018

Azure SQL Database – Who Changed My Auto Tuning Settings?

One of the features Microsoft wants us to use for Azure SQL Database  is Automatic Tuning. Automatic Tuning is a feature where you can think of it as entering the world of self-running and self-tuning databases. It is said to … Continue reading

Read more

0 comments, 228 reads

Posted in All About SQL on 1 November 2018

Whirlwind Tour of Azure SQL Database

I have finally uploaded my Azure SQL Database presentation, apologies for the delay. I am already working on an improved version which I will be delivering next year. Here is the abstract: Azure SQL Database is a general-purpose relational database … Continue reading

Read more

0 comments, 743 reads

Posted in All About SQL on 24 October 2018

Azure SQL DB – Failed to update database because the database is read-only

Quite an interesting  situation I found myself in where I was perplexed for about 5 minutes. I was connected to an Azure SQL Database where I was configuring some users where then I executed a query and was presented with … Continue reading

Read more

1 comments, 175 reads

Posted in All About SQL on 22 October 2018

SQL Server – Reading BACPAC Files

If you have been reading my blog for a while now you would know that a common technique to move to Azure SQL DB is to use BACPAC files. Just a reminder, see the below image. I had a bacpac … Continue reading

Read more

0 comments, 189 reads

Posted in All About SQL on 19 October 2018

Auto-Scaling Azure SQL DB

When I was presenting my Azure SQL Database session at DataRelay (used to be SQLRelay) I was asked (over coffee) about auto scaling capabilities. Quite simply there is nothing out of the box to achieve this. The idea of auto … Continue reading

Read more

2 comments, 705 reads

Posted in All About SQL on 11 October 2018

Giant Azure SQL Databases

Okay it is not really called Giant Azure SQL Database but its close. There is a new public preview vCore service tier called Hyperscale. The architecture behind this is very different to that of a Standard tier SQL database (as … Continue reading

Read more

3 comments, 284 reads

Posted in All About SQL on 4 October 2018

Testing Failover for Azure SQL Database

It is always a good idea to test your failover processes when you have setup failover groups in Azure. I have the following setup: One SQL Server in West Europe being my primary called milkchoc and my secondary server in … Continue reading

Read more

1 comments, 265 reads

Posted in All About SQL on 2 October 2018

Using Microsoft Azure – Twitter Analysis

Time for a fun post, I have been working on a mini-project using technology from Microsoft Azure to hook into Arsenal FC public twitter feed to analyse what was being said about this great football club. (Yes I support Arsenal) … Continue reading

Read more

0 comments, 318 reads

Posted in All About SQL on 27 September 2018

Accidentally deleted an Azure SQL DB?

Okay honestly I have done this once. I have deleted Azure SQL Databases and then try and find the quickest way to recover. The Azure portal is actually pretty good when it comes to deleting resources, for example it will … Continue reading

Read more

2 comments, 208 reads

Posted in All About SQL on 24 September 2018

MAXDOP and Azure SQL DB

The infamous setting that we all know and love – MAXDOP. Did you know that you can actually control MAXDOP when using Azure SQL Database? You might not be able to tinker with the Cost Threshold for Parallelism setting but … Continue reading

Read more

2 comments, 285 reads

Posted in All About SQL on 12 September 2018

Hello Cloud Goodbye DBA

No, not quite. I have had many interesting conversations around this topic and I don’t think (personal opinion) that DBAs will disappear from the world of IT. It will definitely change, the so-called “production DBAs” affected the most. With Azure … Continue reading

Read more

0 comments, 586 reads

Posted in All About SQL on 10 September 2018

Moving an Azure SQL Database across Resource Groups

In my mind there are a couple of ways to move a database across resource groups. They vary from scripting to just using the Azure portal. I am going to use the Azure portal and do the following. Export a … Continue reading

Read more

2 comments, 890 reads

Posted in All About SQL on 5 September 2018

Older posts