Hello all – I am excited to announce that I will be doing a Stairway series on Azure SQL Database hosted over at SQLServerCentral.com.
Azure SQL Database – Stairway Series
Reply
Category Archives: Azure SQL DB
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.
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:
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 Server Management Studio.
Like what?
Azure SQL 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 target for my XEL files.
This is more complicated than using the ring buffer as the target and requires a couple of things:
- Azure storage account where you create a dedicated container for the files.
- SAS key.
- Database master key.
- Database scoped credential.
All About Tech 