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

Azure SQL Database Online Columnstore Unicorn and Rainbow Theory

As Microsoft states “online clustered columnstore index build enables you to optimize and compress your data with minimal downtime without major blocking operations on the queries that are executing while you are transforming the data.” Based on one of my … Continue reading

Read more

0 comments, 121 reads

Posted in All About SQL on 21 February 2019

Azure SQL Database and Transaction Log

Checking out the transaction log in Azure SQL Database. If you are curious like me, you will want to know about what your transaction log is doing in the cloud. The following queries have been tested and run okay within … Continue reading

Read more

1 comments, 140 reads

Posted in All About SQL on 13 February 2019

Automating T-SQL for Azure SQL Database via Logic Apps

Have you ever wanted to capture the T-SQL, waits, sessions IDs (etc) at a specific time for Azure SQL Database? Sure there are a few ways to do this. Extended Events comes to mind but I wanted to do something … Continue reading

Read more

1 comments, 187 reads

Posted in All About SQL on 6 February 2019

SQL Server Looking into Differential Backups

I seem to be writing solely about Azure so to shake things up a bit I am going back to my “roots”. In SQL Server your differential backup is cumulative and NOT incremental and a differential will contain the data … Continue reading

Read more

4 comments, 145 reads

Posted in All About SQL on 5 February 2019

Classify your Azure SQL Database

Here I am talking about SQL Data Discovery & Classification feature that is built into Azure SQL Database. With this feature you have the ability to classify your database, which is what I will do today. There are 2 attributes to … Continue reading

Read more

1 comments, 156 reads

Posted in All About SQL on 4 February 2019

Azure SQL Database Roadmap

I do not usually link straight to other blog posts or technical papers but I really had to with this one because it contains awesome information. The paper is called “Azure SQL Database for Gaming Industry Workloads” by : Pankaj … Continue reading

Read more

1 comments, 236 reads

Posted in All About SQL on 24 January 2019

Azure SQL Database and Transaction Log

Checking out the transaction log in Azure SQL Database. If you are curious like me, you will want to know about what your transaction log is doing in the cloud. The following queries have been tested and run okay within … Continue reading

Read more

1 comments, 342 reads

Posted in All About SQL on 23 January 2019

Azure SQL Database – Reduce the workload before initiating another service objective update

Getting straight to the point, I initiated a very common task recently, another scale up request. However, a new message popped up. “The service objective assignment for database on server could not be completed as the database is too busy. … Continue reading

Read more

0 comments, 194 reads

Posted in All About SQL on 21 January 2019

Moving off SQL Server 2008 / R2 – What can Azure offer?

You will very likely know that SQL Server 2008 / R2 end of support is on July 9th 2019. Not that long to start thinking about and assessing your options. For this post I just want to discuss couple of … Continue reading

Read more

1 comments, 221 reads

Posted in All About SQL on 15 January 2019

Azure SQL DB VS SQL Server For the DBA

Being the start of the new year and with new projects most likely starting again I would like to share with you an article I wrote a while back, but still quite relevant. Hopefully you find it useful for those … Continue reading

Read more

1 comments, 269 reads

Posted in All About SQL on 7 January 2019

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, 2,606 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, 788 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, 189 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, 420 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, 198 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

3 comments, 222 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, 197 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, 254 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, 267 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, 777 reads

Posted in All About SQL on 24 October 2018

Older posts