To Create your Azure free account:
Open the link for azure sign up:
https://azure.microsoft.com/en-in/free/
Requirements:
- Email address
- Phone number
- Credit card(You don't charged)
Benefit you get on creating account:
- 13,300 credit to explore any Azure service for 30 days.
- Azure knowledge documents.
After successfully creating azure account you get email from Microsoft:
Enter into azure portal to manage services:
Creating an Azure SQL Database
Once you click on “SQL Databases” Azure will take you to this page. If there already SQL Databases, you will see them listed here.
When you first click the “Create Database” button you will see this.
After deployment new database is created.
Connecting to the Database:
However, in order to connect there is one thing we need to copy, that is the Server Name. In my case, azsqlconnect.database.windows.net.
Open SSMS. You will connect just as if you were connecting to an On-Prem SQL Server using SQL Authentication.
Once you enter a user name and password, you click Connect.
However, in order to connect there is one thing we need to copy, that is the Server Name. In my case, azsqlconnect.database.windows.net.
Open SSMS. You will connect just as if you were connecting to an On-Prem SQL Server using SQL Authentication.
Once you enter a user name and password, you click Connect.
Sign in to your account to login into your Azure account:
Once connected you will see a few significant differences from an On-Prem instance of SQL Server. Notice that the SQL Server agent is not present. Microsoft has provided a number of ways to schedule maintenance jobs.
Below you will see many more differences.
All other features are enabled or disabled from azure portal:
Feature: Transparent Data Encryption
Once connected you will see a few significant differences from an On-Prem instance of SQL Server. Notice that the SQL Server agent is not present. Microsoft has provided a number of ways to schedule maintenance jobs.
Below you will see many more differences.
All other features are enabled or disabled from azure portal:
Feature: Transparent Data Encryption