You should never stop learning, especially within the IT industry. There are many fields to move into nowadays within the data space, you still have your classic / cloud DBA roles (crossing over to roles such as data engineer) and development roles too. Looking at the industry I see things like Big Data and Data Science becoming more popular. This led me to the Microsoft Professional Program where I spent my time completing the Big Data track – unfortunately it will be retired by Microsoft.
Azure – What is a Shared Access Signature?
Using a Shared Access Signature (SAS) is usually the best way to control access rights to Azure storage resources (like a container for backups) without exposing the primary / secondary storage keys. It is based on a URI and this is what I want to look at today.
I always use the Azure Storage Explorer to build a SAS token. Let’s dig into what the different parts mean.
Azure Storage Explorer
I only ever use the storage explorer when managing my blobs, files, queues within storage accounts. It is your single view access point for all your storage needs and I totally recommend downloading it and using it (https://azure.microsoft.com/en-gb/features/storage-explorer/).
DBCC CHECKDB – Msg 7928, Level 16, State 1, Line 3 The database snapshot for online checks could not be created.
Do you execute DBCC CHECKDB on your Azure SQL Database? From past experience I know some people do, I would suggest not to bother. Why?
Azure SQL Database Script for Size
Sometimes you may not want to flip over to the Azure portal to grab the database size, such as the used space below.