All About SQL

Azure Storage Accounts – Open to the Internet?

• by Arun Sirpal

• All About SQL

Let’s get straight to the point. From official documentation it states that “To secure your storage account, you should first configure a rule to deny access to traffic from...

2019-10-03

31 reads

Hot Patching sqlservr.exe in Azure SQL Database

• by Arun Sirpal

• All About SQL

An amazing blog post by Microsoft describing the idea of hot patching the database engine in Azure SQL Database to allow for minimal downtime when applying patches to SQL...

2019-09-25

20 reads

SQL Server 2019 – Compatibility Level in Azure

• by Arun Sirpal

• All About SQL

I am not sure when this became available but for Azure SQL Database 150 compatibility level is now available. Last time I created a database few weeks ago, only...

2019-09-18

43 reads

Azure SQL Database Types

• by Arun Sirpal

• All About SQL

I want to do a quick summary post of the many different types of Azure SQL Database available and I am not talking about elastic pools, VMs etc, more...

2019-09-17

18 reads

Azure SQL Database – Azure Portal Updates

• by Arun Sirpal

• All About SQL

A small but useful change has been made to the Azure Portal for Data Platform objects. Straightaway more meaningful information is exposed (and centralized), such as the service tier...

2019-09-17

18 reads

Training – Learning Data Science

• by Arun Sirpal

• All About SQL

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

2019-09-12

220 reads

Azure – What is a Shared Access Signature?

• by Arun Sirpal

• All About SQL

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

2019-09-08

72 reads

Azure Storage Explorer

• by Arun Sirpal

• All About SQL

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

2019-09-04

70 reads

DBCC CHECKDB – Msg 7928, Level 16, State 1, Line 3 The database snapshot for online checks could not be created.

• by Arun Sirpal

• All About SQL

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? Well I have mentioned...

2019-08-23

13 reads

Azure SQL Database Script for Size

• by Arun Sirpal

• All About SQL

Sometimes you may not want to flip over to the Azure portal to grab the database size, such as the used space below. So here is a handy script...

2019-08-12

8 reads