Review Azure SQL Database Configuration

Q

How is my Azure SQL Database configured?

✍: FYIcenter.com

A

If you have followed the previous tutorial, you can continue with this one to review your Azure SQL Database configurations.

1. Login to your Azure Web portal.

2. Search and select your resource group name "Group". You see two services have been created:

fyi-db-server - SQL server
fyi_db - SQL database

3. Click on "fyi-db-server". You see the details of the SQL Server service that supports your SQL database service.

4. Go back to the service group and click on "fyi_db". You see the details of the SQL Database service.

Server name: fyicneter-db-server.database.windows.net
Pricing tier: Standard S0: 10 DTUs

5. Scroll down and review other configurations:

Database data storage: Used space 4 MB
Transparent data encryption: Configured
Automatic tuning: Not configured.
...

⇒ Use Query Editor on Azure Portal

⇐ Create Azure SQL Database

⇑ Introduction of Azure SQL Database

⇑⇑ SQL Server Storage Tutorials

2019-07-07, ∼1984🔥, 0💬

sqa.FYIcenter.com Links
Collections: Selenium Tutorials UFT-QTP Tutorials JMeter Tutorials Test Management SQL Server Storage Online Tools Other Resources: SQA (Software QA) Developer Resources DBA Resources Windows Tutorials Java JAR Files DLL Files File Extensions Security Certificates Regular Expression Link Directories... 2025-04-03, ∼7349🔥, 1💬

💬 2019-01-16 Gffg: Online test tools --> try!

IOPS Tests on Azure SQL Database with INSERT
Where to find tutorials on IOPS Tests on Azure SQL Database with INSERT Statements? Here is a list of tutorials to answer many frequently asked questions compiled by FYIcenter.com team on IOPS Tests on Azure SQL Database with INSERT Statements. What Is IOPS (I/O Operations Per Second) Table for IOPS... 2019-08-08, ∼3733🔥, 0💬

Use Query Editor on Azure Portal
How to use Query Editor on Azure Portal? Query Editor on Azure Portal is nice client tool that allows you to run SQL queries to your Azure SQL database. 1. Login to your Azure Web portal. 2. Search and select your Azure SQL Database name "fyi_db". You see a summary information of your database. 3. C... 2019-07-28, ∼2583🔥, 0💬

Introduction of Azure SQL Database
Where to find tutorials on Introduction of Azure SQL Database? Here is a list of tutorials to answer many frequently asked questions compiled by FYIcenter.com team on Introduction of Azure SQL Database. What Is Azure SQL Database Create Azure SQL Database Review Azure SQL Database Configuration Use ... 2019-07-18, ∼2560🔥, 0💬

What Is IOPS (I/O Operations Per Second)
What Is IOPS (I/O Operations Per Second)? IOPS (I/O Operations Per Second) is a measurement on how fast a data storage device can perform read and write operations. IOPS is not a throughput measurement, it only gives you the total number of I/O operations. Throughput can be estimated by multiplying ... 2019-08-08, ∼2548🔥, 0💬

Create Azure SQL Database
How to create an Azure SQL Database? If you have subscription account with Microsoft, you can follow this tutorial to create an Azure SQL Database with Azure Web portal. 1. Login to your Azure Web portal. 2. Select Create a resource in the upper left-hand corner of the Azure portal. 3. Select Databa... 2019-07-21, ∼2491🔥, 0💬

Table for IOPS Tests on INSERT Statements
How to design a database table to perform IOPS tests on INSERT Statements? In order to for perform IOPS tests on INSERT Statements, we should start with a simplest table first using minimum database functionalities. Here is an example of database table, FYI_INT, with only 1 column: CREATE TABLE FYI_... 2019-08-08, ∼2462🔥, 0💬

What Is Azure SQL Database
What Is Azure SQL Database? Azure SQL Database is the intelligent, scalable, cloud database service offered by Microsoft on their Azure cloud platform. Main features of Azure SQL Database are: Frictionless database migration with no code changes at an industry leading TCO Built-in machine learning f... 2019-07-04, ∼2223🔥, 0💬

Azure SQL Database Related Terminology
Azure SQL Database Related Terminology: DTU - DTU (Database Transaction Unit) is a unit of measure of mixed resources of CPU, Memory and IO used to support Azure SQL database. The actual computing power provided by each DTU is based on your SQL database service tier. For example, at the "Standard" t... 2019-07-05, ∼2025🔥, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.