All About SQL

Azure Database for PostgreSQL

• by Arun Sirpal

• All About SQL

Having worked with Azure SQL Database and its many flavours for couple of years now I am confident in building deploying, whether manual or templates. Being in Azure you...

2020-02-18

16 reads

Azure SQL Database and Error Handling

• by Arun Sirpal

• All About SQL

For some reason I have friends / colleagues telling me that when scaling (up and down for this example) that no downtime occurs. Well, not only does Microsoft documentation...

2020-02-11

189 reads

Azure Advisor – for Azure Data Platform

• by Arun Sirpal

• All About SQL

Wouldn’t it be nice if we could access one main dashboard / report that pulls in information from many tools such as security centre, SQL advisor and cost management...

2020-02-03

9 reads

Amazon Web Services (AWS) vs Azure Features List

• by Arun Sirpal

• All About SQL

After much reading through the internet looking for Amazon’s equivalent of Microsoft’s Azure functions (Lambda), I found this outstanding link that ” helps you understand how Microsoft Azure services...

2020-01-13

216 reads

Common Things Admins Miss in Azure SQL DB

• by Arun Sirpal

• All About SQL

This is by no means a complete list but more of a personal list of features I have seen not setup or just missed out when looking at Azure...

2020-01-08

33 reads

Azure Site Recovery jobs fail on servers hosting SQL Server instances with AUTO_CLOSE DBs

• by Arun Sirpal

• All About SQL

This post is to help you if you are suffering from the following issue: A VSS writer has rejected an event with error. The writer experienced a non-transient error. If...

2020-01-06

5 reads

SQL Server Christmas Script

• by Arun Sirpal

• All About SQL

Nothing much to say but I hope you all have a nice break. Thanks for the support and reading my blog. Enjoy the script! (Might not format correctly here...

2019-12-19

43 reads

Azure SQL Database – Automatic Tuning – Have you enabled it?

• by Arun Sirpal

• All About SQL

Do you enable this setting to allow automatic tuning to care of all your performance needs? Well not ALL your needs, more so: CREATE INDEX DROP INDEX FORCE LAST...

2019-12-09

24 reads

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

217 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

97 reads