All About SQL

Azure Databricks to Azure SQL DB

• by Arun Sirpal

• All About SQL

Recently I got to a stage where I leveraged Databricks to the best of my ability to join couple of CSV files together, play around some aggregations and then...

2020-05-26

11 reads

SQL Server 2019 Linux On Azure

• by Arun Sirpal

• All About SQL

It was just a matter of time until I started combining my cloud experience with “different” flavours of SQL Server. I haven’t used Linux since my university days (Oracle...

2020-05-19

77 reads

SQL Server 2019 Overview

• by Arun Sirpal

• All About SQL

There are many quality resources regarding SQL Server 2019, from eBooks to videos about the newest features and how one would implement these within your business. I recommend the...

2020-05-12

22 reads

Tracking Costs in Microsoft Azure via Tags

• by Arun Sirpal

• All About SQL

Moving to public cloud such as Azure, AWS or even private cloud services you need to be tracking costs and seeing if you are “effective”. What is the best...

2020-05-06

99 reads

Installing SQL Server 2019 on Azure VM

• by Arun Sirpal

• All About SQL

Unfortunately, this is not an on-premises SQL Server install because I do not have the right operating system available for SQL Server 2019, which includes the below: Windows 2016...

2020-04-28

20 reads

Azure SQL Database – Error Logs?

• by Arun Sirpal

• All About SQL

Ok, so Azure SQL doesn’t really have its own error log based somewhere on a machine within \MSSQLLog directory but the closest thing you will get is a system...

2020-04-07

178 reads

Azure SQL DB – An instance-specific error occurred while establishing a connection to SQL Server.

• by Arun Sirpal

• All About SQL

The full message when connecting to your Azure SQL Database is: Reason: An instance-specific error occurred while establishing a connection to SQL Server. The public data endpoint on this...

2020-03-16

117 reads

SQL Server Agent for Azure SQL DB?

• by Arun Sirpal

• All About SQL

I always wanted a way to schedule commands within Azure SQL Database. Personally, for me, the go to standard is the functionality of SQL Server Agent. Obviously, this is...

2020-03-02

18 reads

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

208 reads