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

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

1 comments, 91 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, 155 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, 190 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, 286 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, 364 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, 245 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,147 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,771 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, 412 reads

Posted in All About SQL on 19 June 2018

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

Read more

1 comments, 1,885 reads

Posted in All About SQL on 15 June 2018

Azure SQL Database – Stairway Series

Hello all – I am excited to announce that I will be doing a Stairway series on Azure SQL Database hosted over at SQLServerCentral.com. The aim of this series is to start gently and is very much intended for readers … Continue reading

Read more

0 comments, 202 reads

Posted in All About SQL on 13 June 2018

Linked Server to Azure SQL Database

You may (or may not) have a requirement to setup a linked server to Azure SQL Database from a locally installed SQL Server. One reason could be to pull down some reports from an Azure SQL Database to a local … Continue reading

Read more

2 comments, 1,697 reads

Posted in All About SQL on 5 June 2018

Azure SQL Database – The Default Isolation Is?

So what is the default isolation level for Azure SQL Database? I ran the following code to check it out. Or you can use this DBCC command. Quite simply the default isolation level for Azure SQL Database is RCSI – … Continue reading

Read more

2 comments, 201 reads

Posted in All About SQL on 30 May 2018

Azure SQL Database / SQL Server – Paused Index Rebuild

I was creating some demo non-clustered indexes in one of my Azure SQL Databases and received the following warning when I executed this code: Msg 10637, Level 16, State 3, Line 7 Cannot perform this operation on ‘object’ with ID … Continue reading

Read more

1 comments, 1,734 reads

Posted in All About SQL on 22 May 2018

Handy TSQL for Azure SQL Database

I do not always use the Azure portal to make database changes or to check for certain information. I use it a lot of for blogging purposes but for some tasks I rather just run code via SSMS – SQL … Continue reading

Read more

0 comments, 239 reads

Posted in All About SQL on 14 May 2018

Extended Events – Using Azure Storage

Last year I wrote about Azure SQL Database extended events (https://blobeater.blog/2017/02/06/using-extended-events-in-azure/)  and gave an example where I was capturing deadlocks via the ring buffer. Ever since then I wanted to do a follow-up post but using Azure storage as the … Continue reading

Read more

2 comments, 1,297 reads

Posted in All About SQL on 8 May 2018

Getting my Twitter Data via Azure Logic Apps

As a mini project I wanted to use Azure logic apps to pull tweets from my twitter account when people were tweeting about #Azure / #Microsoft. From here I used cognitive services – sentiment analysis API which returns a numeric … Continue reading

Read more

4 comments, 239 reads

Posted in All About SQL on 2 May 2018

Azure SQL Database – A Copying “Gotcha”

Creating copies of your Azure SQL Database is a common and relatively simple process. You can issue a TSQL statement on the master database such as: Now, I was looking at the following code. You would think this is okay? … Continue reading

Read more

2 comments, 262 reads

Posted in All About SQL on 24 April 2018

Azure SQL Database vCore

vCore based performance levels are very new, currently in preview and not yet rolled out to all Azure regions (The preview is not available in the following regions: West Europe, France Central, UK South, and UK West.). It does offer … Continue reading

Read more

2 comments, 2,072 reads

Posted in All About SQL on 16 April 2018

Azure SQL DW – Let’s Shuffle?

Initially, the main focus of this post was going to be quick and about using the latest version of SSMS (SQL Server Management Studio) to check out execution plans for Azure SQL Data warehouse (DW). I got a little side … Continue reading

Read more

1 comments, 705 reads

Posted in All About SQL on 12 April 2018

Older posts