-->
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.

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, 612 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

2 comments, 226 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, 210 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, 216 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, 155 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, 214 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, 547 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, 796 reads

Posted in All About SQL on 5 September 2018

Azure SQL Database – Detecting Threats

At first I was nervous but then I realized it was me triggering “Someone has logged on to your server  from an unusual location” message against my Azure SQL database. The process of investigating the “rouge” login didn’t help with … Continue reading

Read more

3 comments, 717 reads

Posted in All About SQL on 3 September 2018

Deleting Azure SQL DB

So you want to do a clean-up exercise in Azure and remove some databases. You go to delete a database that is no longer required (as shown below). But you get an error code 400 – Failed to delete the … Continue reading

Read more

0 comments, 156 reads

Posted in All About SQL on 28 August 2018

My Azure SQL Database Elastic Job is Broken!

I use elastic pools. They are a fabulous way of saving money when running many Azure SQL Databases, that is assuming you understand the resource utilization patterns of the databases involved. I recently created couple of elastic jobs for my … Continue reading

Read more

2 comments, 238 reads

Posted in All About SQL on 23 August 2018

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. Good, bad, you decide. The point is that even in … Continue reading

Read more

3 comments, 179 reads

Posted in All About SQL on 20 August 2018

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 … Continue reading

Read more

0 comments, 226 reads

Posted in All About SQL on 16 August 2018

Azure SQL DW – Query Labels

Using a query label in Azure SQL DW (Data Warehouse) can be a really handy technique to track queries via DMVs. You might want to do this to see what problematic queries are doing under the covers. Let’s check out … Continue reading

Read more

1 comments, 261 reads

Posted in All About SQL on 14 August 2018

Azure SQL Data Warehouse and Backups

Just because the cloud movement is strong doesn’t mean the end of “DBA’s”, it does mean a change in skills and no doubt you will (one day) create Azure SQL Data Warehouse (DW) in Azure. If you are from an … Continue reading

Read more

1 comments, 337 reads

Posted in All About SQL on 7 August 2018

SQL Server – Blocking a Truncate

The truncate option is fast and efficient but did you know that it takes a certain lock where you could actually be blocked? What am I talking about? When you issue a truncate it takes a Sch-M lock and it … Continue reading

Read more

2 comments, 414 reads

Posted in All About SQL on 31 July 2018

PsPing your Azure SQL Server

PsPing tool is part of the sysinternals PsTools download found –  ( https://docs.microsoft.com/en-us/sysinternals/downloads/psping) This is the tool of choice when wanting to find out latency to your Azure SQL Server. In addition to standard ICMP ping functionality, it can report … Continue reading

Read more

1 comments, 297 reads

Posted in All About SQL on 23 July 2018

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. I have been using Azure Logic apps … Continue reading

Read more

2 comments, 2,264 reads

Posted in All About SQL on 9 July 2018

Azure SQL Elastic Pools – Moving Databases

If you read official Microsoft documentation about naming conventions for your SQL elastic pools, it is hard to find any guidelines on the subject. You are probably thinking it is not that big of a deal. I thought the same … Continue reading

Read more

0 comments, 1,842 reads

Posted in All About SQL on 2 July 2018

SQL Server 2017 – SELECT INTO [A SPECIFIC FILEGROUP]

Forget about Adaptive Query Processing for a minute, what other feature have I been waiting for? SELECT INTO a specific filegroup, not the default filegroup! I have needed this feature many times in the past. Let’s take a look at … Continue reading

Read more

1 comments, 494 reads

Posted in All About SQL on 19 June 2018

Older posts