All About SQL

SQL Server 2019 eBook

• by Arun Sirpal

• All About SQL

SQL Server 2019 is ready available for use, but before you download you should review the webinars, white papers and eBook available on the technology (definitely the eBook ??...

2019-12-02

123 reads

Execution Plans in Azure SQL Database

• by Arun Sirpal

• All About SQL

Yes you can still get execution plans for Azure SQL Database, you cannot get this from the Azure Portal so it is good to know for your tuning days....

2019-11-20

86 reads

Azure SQL Best Practices?

• by Arun Sirpal

• All About SQL

A way to enforce good practice and standards is by Azure Policy. As stated by Microsoft “Azure Policy is a service in Azure that you use to create, assign,...

2019-11-12

39 reads

SQL Server Backup / Restore from URL

• by Arun Sirpal

• All About SQL

I think many have covered how you should backup your SQL Server database to Azure storage (also known as backup to URL) but what about restoring? Lets assume you...

2019-11-07

116 reads

Deadlocks – Azure SQL Database

• by Arun Sirpal

• All About SQL

Would you like to troubleshoot a deadlock in Azure SQL Database? To do this you probably will be after the deadlock graph. So does this mean that you need...

2019-11-04

97 reads

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

197 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

96 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

95 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