Azure SQL Database Blog


Shivani Mishra - Easy Azure for Everyone

SQL Database Basics

SQL database is a relational database service that allows you to manage and query structured data. It is the latest version of Microsoft SQL Server database engine in the cloud.


Relational databases in Azure

What is a Relational Database?

A relational database is a collection of tables that are related to each other through defined relationships. It allows you to store data in a structured manner and define constraints to ensure data quality.

·         You can define tables with columns to store data.

·         You can define constraints to ensure data quality.

·         You can use multiple tables and define relationships between them.

·         You can run SQL queries to combine data from multiple tables.

Why Use Relational Databases?

Relational databases are useful for managing structured data and exploring data using SQL queries.

·         You can manage structured data effectively using constraints and relationships.

·         You can use SQL queries to analyze and explore your data.








Azure SQL Database Deployment Methods

Azure SQL Database offers three deployment methods:

1.    Single Database: Fully isolated and managed database.

2.    Elastic Pool: Allows you to share resources across multiple single databases.

3.    Managed Instance: Full capabilities of SQL Server, managed by yourself.

SQL Database Pricing Models

Azure SQL Database offers different pricing models:

·         DTU (Database Transaction Unit): Microsoft unit of performance.

·         vCore: Purchase virtual cores to scale performance.

·         Serverless: Pay for actual usage with automatic scaling.

Elastic Pool

Elastic Pool allows you to share resources across multiple databases. It is useful for scenarios where you have many databases with uneven usage patterns.

Serverless

Serverless allows you to scale your database between one and four vCores, based on usage. It is suitable for scenarios with uneven usage and rare database activity.

Additional Features

Azure SQL Database offers availability features, such as automatic backups, point-in-time restores, and active geo-replication, to ensure data quality and protection.

Demo: Creating an SQL Database

You can create an SQL database through the Azure portal. Choose the deployment method, pricing tier, and configure the database according to your needs.

After creating the database, you can connect to it using SQL Server Management Studio or Azure Data Studio.

In order to set yourself as an admin in Active Directory, you need to go to the database server and navigate to the Active Directory Admin section. From there, you can set yourself as an admin using an account from the Active Directory. Once you have set yourself as an admin, you can log in to the SQL server using your Active Directory account.

If you encounter a pop-up saying that the firewall is blocking your connection, you need to go to the server settings and add your current IP address to the firewall rules. This will allow you to connect to the database. If your IP address is dynamic, you may need to update it in the future.

After connecting to the database, you can create tables, views, and perform queries. You can also use Azure Data Studio as a tool to connect and work with SQL databases. Azure Data Studio offers a user-friendly interface and additional features.

Remember to always set yourself as an admin to the database, add your IP address to the firewall rules, and consider the pricing tiers and deployment models when choosing a SQL database in Azure.

Comments

Post a Comment

Popular posts from this blog

The fundamentals of using Azure Secret Computing to Safeguard your data

Image
The exponential rise of datasets has led to increased scrutiny of how data is disclosed, both from the perspective of consumer data privacy and compliance. Confidential computing becomes a key tool in this setting to assist enterprises in meeting their privacy and security requirements for commercial and consumer data. Confidential computing technology encrypts data in memory and processes it only once the cloud environment has been confirmed, prohibiting data access from cloud operators, malevolent administrators, and privileged applications like the hypervisor. It aids in the protection of data throughout its lifecycle. Data is now safeguarded when in use, in addition to existing technologies for securing data at rest and in transit. Organizations all over the world can now take advantage of previously unattainable prospects because to secret computing. They can now, for example, profit from multi-party data analytics and machine learning, which aggregate datasets from parties ...
Read more

Azure Data Factory | Copy multiple tables in Bulk with Lookup Activity & ForEach

  Shivani Mishra - Easy Azure for Everyone Introduction to Azure Data Factory Lookup and ForEach Actions In this blog, we will learn how to build dynamic pipelines in Azure Data Factory using lookup and forEach actions. The lookup action allows you to retrieve a data set from a file or table within your database, and you can use this data set to determine the list of objects that you want to work with in your pipeline. The lookup action supports most of the data sources currently supported in Data Factory, so you can use various types of databases or flat file solutions. The lookup action is often paired with the forEach action, which allows you to execute a set of activities for each object in the list returned by the lookup action. This blog will walk you through a step-by-step setup of a pipeline that lists tables from a SQL database using a lookup activity, and then iterates over the results to perform a simple copy extraction. Step-by-Step Setup Initial S...
Read more

Azure Data Factory | Introduction to ETL in Azure

Image
Shivani Mishra - Easy Azure for Everyone Data Factory: A Brief Introduction In this blog post, we will see Azure Data Factory, a service that allows you to move data between different sources. Whether you are working in the cloud or on-premises, data movement is an essential part of any project. Let's explore how Data Factory works and how you can use it in your own projects. How does Data Factory work? To understand how Data Factory works, let's use an analogy. Imagine you want to move a cabinet from a shop to your home. In this scenario, you need certain information: ·          A key and address to locate the shop and access the cabinet ·          Information about the cabinet, such as disassembly instructions or packaging details ·          Delivery details, including what to do with the package once you receive it ·    ...
Read more