All About SQL

Backup Techniques for SQL Server on Azure Virtual Machines

• by Arun Sirpal

• All About SQL

In the previous blog post I did a quick overview building a SQL VM (imaged) in Azure. It is now time to clarify some backup techniques because it can...

2019-10-17

26 reads

SQL Server Virtual Machines in Azure

• by Arun Sirpal

• All About SQL

Let’s create a virtual machine in Azure that has an imaged copy of SQL Server on it. I want to do this because down the line I want to...

2019-10-09

83 reads

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

25 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

16 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

25 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

12 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

212 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

66 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

65 reads