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.


If you know about DBCC CHECKDB then most likely you will know about DBCC CHECKTABLE. Quite simply this command performs primitive system-catalog consistency checks, per-table consistency checks on the single table specified, and cross-table consistency checks on indexed views that refer­ence the specified table. (Page 899 Microsoft SQL Server Internals… Read more

4 comments, 219 reads

Posted in All About SQL on 20 November 2017

Azure SQL Database Alerting

It’s good to be proactive and one way is to setup alerts and it is no different when using Azure SQL Database. I like creating alerts for my Azure SQL Databases and I encourage you to do the same.

I keep things simple and like to look at certain performance… Read more

4 comments, 371 reads

Posted in All About SQL on 16 November 2017

Folks Who Have Made a Difference

TSQL Tuesday time hosted by Ewald (https://sqlonice.com/tsql-tuesday-96-folks-who-have-made-a-difference/) and quite simply one man has morphed me into who I am today – Paul Randal. Over two years ago I was a one of many that had the chance to be mentored by him. It lasted just under one year… Read more

3 comments, 209 reads

Posted in All About SQL on 14 November 2017

SQL Server 2017 – Interleaved Execution

I worked on testing interleaved execution with Microsoft back in January, I didn’t do much, just tested the functionality against some in-house code we had. (If you need a detailed primer on the subject, please see https://blogs.msdn.microsoft.com/sqlserverstorageengine/2017/04/19/introducing-interleaved-execution-for-multi-statement-table-valued-functions/)

As the article states it “changes the unidirectional boundary between the optimization… Read more

2 comments, 625 reads

Posted in All About SQL on 9 November 2017

Azure SQL Database Compatibility Levels

Let’s start off with a quick overview of SQL Server versions and compatibility levels.

  • 100 = SQL Server 2008 and Azure SQL Database
  • 110 = SQL Server 2012 and Azure SQL Database
  • 120 = SQL Server 2014 and Azure SQL Database
  • 130 = SQL Server 2016 and Azure SQL Database

Read more

2 comments, 271 reads

Posted in All About SQL on 6 November 2017

Microsoft MVP!?

What? Is probably the most common reply out there and if it is then that is how I felt when I read the message early Thursday morning.

My ultimate goal in my professional life was to work for Microsoft, you can read about my failed attempt here https://blobeater.blog/2016/09/29/my-application-to-microsoft/ but since… Read more

5 comments, 310 reads

Posted in All About SQL on 2 November 2017

Azure SQL Database Automatic Tuning – Questions Answered

I used to be on the fence regarding whether or not Automatic Tuning should be on as the default when creating Azure SQL Databases. A part of me never liked the idea of Azure creating/dropping indexes or forcing plans without my prior approval but then again if it happens to… Read more

2 comments, 247 reads

Posted in All About SQL on 1 November 2017

SQL Server Phantom Reads

With Halloween around the corner what better topic to discuss than phantom reads. A phantom read occurs when rows have been inserted after a read operation and becomes visible in a follow-up read operation within the same transaction.

I will show you what this looks like with an example. Please… Read more

1 comments, 1,306 reads

Posted in All About SQL on 26 October 2017

Query Store – SQL Server 2017 vs Azure SQL Database

I love the query store, it is powerful (can be dangerous) , easy to use and packed full of information. I use it frequently across my local SQL Servers and Azure SQL Database.

Obviously it the same tool across local and cloud databases but there is one subtle difference between… Read more

1 comments, 1,650 reads

Posted in All About SQL on 24 October 2017

Connecting to Azure SQL Database Primary Endpoint – Failover Groups

When you have setup a Failover Group in Azure for your SQL Databases connecting to the R/W (Read / Write) endpoint via SSMS (SQL Server Management Studio) is pretty simple, if you remember one little thing, which will be the discussion point for this blog post.

I wrote about Failover… Read more

0 comments, 314 reads

Posted in All About SQL on 19 October 2017

SQL Server: What will REPAIR do?

So I had a corruption issue and I was thinking about running repair but I wanted to know what would potentially get deleted.

I was faced with the following message.

Table error: Object ID 1189579276, index ID 1, partition ID 72057594046578688, alloc unit ID 72057594053132288 (type In-row data). Page (1:441).… Read more

0 comments, 1,717 reads

Posted in All About SQL on 16 October 2017

When Things Go Wrong in Azure

Things go wrong in IT, it is no different with the cloud. When I say cloud I am thinking quite specific  such as the  underlying infrastructure that a company like Microsoft looks after for their Azure platform.

I took the below image from https://blogs.msdn.microsoft.com/psssql/2014/03/27/dont-rely-on-a-static-ip-address-for-your-sql-database/

It shows the many different layers… Read more

3 comments, 317 reads

Posted in All About SQL on 12 October 2017

Azure SQL Database Level Firewall Rules

I have written about Azure SQL Database LEVEL firewall rules before during my blog series, more specifically the security blog post. If you can’t remember the section on firewalls then I will bring the following diagram to your attention.

The main purpose of this post today is to discuss… Read more

1 comments, 999 reads

Posted in All About SQL on 11 October 2017

SQL Server 2017 Encrypted Backups And Compression

Let’s work through some code to do an encrypted backup. This feature is available to you if you are using SQL Server 2014 onwards but I decided to use SQL Server 2017.

To encrypt during backup, you must specify an encryption algorithm, and an “encryptor” to secure the encryption key.… Read more

4 comments, 1,766 reads

Posted in All About SQL on 9 October 2017

Azure SQL Database Data Integrity Checks

If you remember last month I wrote about DBCC CHECKDB and Azure SQL Database, more specifically whose responsibility (Microsoft’s) it is and ponderings on how it is actually done. (https://blobeater.blog/2017/09/04/dbcc-checkdb-azure-sql-database/)

Recall that is consumes a lot of DTUs running CHECKDB on your Azure SQL Database so I had… Read more

0 comments, 287 reads

Posted in All About SQL on 4 October 2017

SQL Server Tracking Tempdb Size

Here is a quick Extended Events script I knocked up where I wanted to track Tempdb file size changes for both the data and log file. I wanted to know who caused the tempdb growth, when it was done, what the T-SQL was and what sizes were involved. Not exactly… Read more

0 comments, 299 reads

Posted in All About SQL on 3 October 2017

SQL Server – Pause VS Stop

You have the ability to actually pause SQL Server, if you are in SQL Server Management Studio (SSMS), you might have noticed it as the below image.

As stated via official Microsoft documentation “Pausing the Database Engine service prevents new users from connecting to the Database Engine, but users who… Read more

1 comments, 229 reads

Posted in All About SQL on 2 October 2017

SSMS 17 Dark Theme

Have you ever wanted SQL Server Management Studio (SSMS) 17 to have a dark theme? Seeing the below image (visual experience color theme options) really got me excited.

To do this you have to edit system files, don’t get me wrong, it obviously is not a supported means to get… Read more

6 comments, 514 reads

Posted in All About SQL on 29 September 2017

Checking Out SQL Vulnerability Assessment

Apparently there is a new tool from Microsoft where you can discover, track, and remediate potential database vulnerabilities. This tool is available for both on-premises SQL Server and Azure SQL Database. I actually cannot find the download for the on-premises version so I decided to give it a go in… Read more

1 comments, 1,176 reads

Posted in All About SQL on 28 September 2017

Azure SQL Database Active Geo Replication Changes

Six months ago how you would go about setting up Active geo replication for your SQL Databases would be different to today, yes things (naturally) do change but for this specific area it has changed for the better – again something that you would expect right?

So what exactly am… Read more

1 comments, 342 reads

Posted in All About SQL on 25 September 2017

Newer posts

Older posts