Cloud Era – Azure DBA

• by Arun Sirpal

• All About SQL

I get asked quite a bit about my thoughts on the impact Cloud computing has on a DBA role. Still in 2019, I get people say oh it’s the...

2019-10-28

207 reads

Azure SQL Database Failover – Grace Period?

• by Arun Sirpal

• All About SQL

The Azure SQL Database service triggers an automatic failover after a failure is detected and the grace period has expired. What is the grace period? You can find this...

2019-10-23

110 reads

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

28 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

100 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

29 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

18 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

41 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

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

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

218 reads