Creating and using SQL databases
One of the most used connections is a query to obtain or set data from a SQL database. Azure has a large variety of database connections in its catalog, but one of the most used is the SQL database. However, before we get on to the subject of timeouts and error messages, we need to understand how SQL databases are created and accessed. First, I will explain this process and get us to a point where we can use a database under normal operations. At that point, I will focus on errors and how to manage them.
Two types of databases are available, and this is determined by where the database is stored. If the database is stored within the cloud, it can be accessed by a connection object in the resource group that has direct authentication, typically by using your Azure service account (or user account, if you're not operating on an Enterprise-level project). As the database is a cloud resource, the account is common to both Azure and the database...