DP-900-Creating Azure SQL

 Creating Azure SQL


Step 1 : In the search bar, search for Azure SQL Database.


Step 2 : Click on Create. 


Step 3 : Add Details.

1. Basic :


- Select your subscription and resource group and give your database name.
- Server: if there are any existing servers, then select one of them or create a new server.



** Creating a Server.

Add Details.


Authentication method : 

1- Microsoft Entra-Only Authentication : 
    -Does not require any additional username and password 
    -Only Microsoft credentials are required for authentication



2- Use both SQL Admin and Microsoft entra authentication
    - Need to set Microsoft entra admin and server admin username and password



3- Use SQL Admin Authentication
    - Need to set server admin username and password.


Click OK.



Back to the Basics tab.
Here you can see the cost details of the Server.


Want to use SQL elastic pool?
We are creating a single database.
IF you select this option. It enables you to use an elastic pool, which means multiple SQL databases can share a single server.


Workload Environment :
Development : lower cost 
Production : costly



Compute + Storage :
- By clicking on configure database, you can edit database-related settings from the configure page.





Backup storage redundancy : select according to your requirement. 
Go to the Networking tab.


2. Networking :

Connectivity Method :
No access : Don't need any additional information.

Public Endpoint : Need to add firewall rules.
- Add current IP address - by selecting it as yes, it will automatically add your computer's IP address to the list of allowed devices.
- lets you manage and access the database from your computer.
- blocks other computers that aren't in the allowed lists from accessing the data

Private Endpoint : Need to add details of the private endpoint. 





Go to the Security tab.


3. Security :

Microsoft Defender :
Disable :
Enable : Monitors your access and checks for evidence

Ledger : Protects you against hacking by generating hash keys. Checks the Integrity of data and ensures that it has not been altered unintentionally. 



Go to the Additional Settings.


4. Additional Settings :

Data Source : 
- None : 
    - Used when you want to build everything from scratch
    - Creates an empty database

- Backup :
    - Used when migrating from an On premises to SQL Server
    - Creates database from existing data

- Sample :
    - Rarely used in real projects.
    - Creates a sample database with pre-filled tables and data for testing/learning.





Click Review + Create.


Click Create.


Step 4 : Click on go to the resource.


Step 5 : On the overview page.
From set server firewall you can set firewall rules and turn it on and off.



Step 7 : Click on Open Azure Data Studio, and it will download Azure Data Studio.

There are three ways to start developing database.
Azure Data Studio, Visual Studio, Visual Studio Code



Step 8 : Click on Download Azure Data Studio.


Process to Download and Install Azure Data Studio.











Step 9 : Click on Launch it now.


Step 10 : Add Details. And Click connect.



Step 11 : Go to any table and select the option of select top 1000 from actions column.































































































































Comments

Post a Comment

Popular posts from this blog

AI-900-3,4

Image
Module : 3 Get Started with Machine Learning in Azure Machine learning drives today’s AI by turning data into insights for predictions and recommendations. Creating an ML solution requires key decisions that affect cost, speed, and quality. Using Microsoft Azure, the process follows six main steps: Define the Problem: Decide what to predict and how to measure success. Get the Data: Find and access reliable data sources. Prepare the Data: Clean, explore, and format the data for modeling. Train the Model: Choose algorithms and adjust parameters. Integrate the Model: Deploy it to generate predictions. Monitor the Model: Track performance and retrain as needed. Machine learning is an ongoing process. Models evolve as data changes. Step 1: Define the Problem The first step in building a machine learning (ML) solution is to define the problem. You need to clearly understand what you want the model to predict and how you will measure success. Key Considerations Model output: What result shoul...
Read more

AI-900 12,13

Module : 12   Overview of Information Extraction * Information extraction is a process that uses AI to pull structured data from unstructured or semi-structured documents, like receipts, invoices, forms, and scanned files. It combines computer vision, OCR, and machine learning or generative AI. * Key Steps in an Information Extraction Pipeline 1. Text Detection & Extraction (OCR) - It uses computer vision to find text areas in an image. - The system extracts raw text from scanned or image-based documents. 2. Value Identification & Mapping It maps the OCR text to specific data fields using: - Machine learning - Rule-based mapping - Generative AI (in newer solutions) Example From a scanned receipt, the system extracts fields such as: - Vendor - Date - Subtotal - Tax - Total * Choosing the Right Approach When designing an information extraction solution, consider: Document Characteristics - Layout consistency - Fixed templates lead to simple, rule-based extraction - Many forma...
Read more

AI-900 10,11

Image
Module : 10  Introduction to Computer Vision Concepts  Computer Vision Tasks & Techniques   * What is Computer Vision? Computer vision uses AI techniques to process and understand visual input such as: - Images   - Videos   - Live camera streams   - It enables machines to "see" and interpret visual information.   1. Image Classification   - This predicts a single label for an entire image.   - The model is trained using many labeled images.   - For example, a smart grocery checkout can identify an apple, orange, or banana from a single item placed on a scale.   - Use case: Recognizing the main subject in an image.   2. Object Detection   - This identifies multiple objects in a single image.   It returns:   - Object labels   - Bounding box coordinates   - For example, a checkout system can detect all fruits placed together....
Read more