Azure SQL Database Roadmap

Posted on by
1

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 Arora, Senior Software Engineer, Microsoft.

Find the link here – https://azure.microsoft.com/mediahandler/files/resourcefiles/azure-sql-database-for-gaming-industry-workloads/Azure%20Sql%20DB%20for%20Gaming%20industry.pdf

Look out for the last section regarding the future, Hyperscale databases, Gen 6 hardware and potential “serverless” offering?

It got me excited.

 

 

Azure SQL Database and Transaction Log

Posted on by
6

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 Azure SQL Database. It gives you some great insight.

Continue reading →

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

Posted on by
Reply

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. Reduce the workload before initiating another service objective update”.

Continue reading →

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

Posted on by
1

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 things that you can do and I specifically mention Azure technologies, think of this as a high level starter guide.

Continue reading →

Azure SQL DB VS SQL Server For the DBA

Posted on by
1

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 wanting to know key differences between Azure SQL Database and a locally installed SQL Server from a DBA perspective and whether or not these key differences can be seen as advantages or disadvantages.

Continue reading →