Microsoft SQL Azure Database – Step by Step Creation tutorial
SQLShack
SQL Server training Español Microsoft Azure SQL Database – Step by Step Creation tutorial
March 14, 2017 by Venkatesan Jayakantham Microsoft Azure SQL Database is a managed cloud database for programmers/developers to develop their products easier due to less involvement in maintenance allowing the customer to concentrate on their products, because, most of the data maintenance or infrastructure is taken care by the cloud service providers. Advantages of a cloud database
Elastic in nature – increase or decrease your server capacity instantly. Availability – Geo replication becomes too easier. This makes the backup strategy very easy two or three clicks. Multitenant facility – Cost wise, no need to invest more money in the initial stage. Business scenario and justification: SQL Server 2016 Licensing costs: SQL Server
2016 editions Description or suitability of the product Licensing Details Channel availability Cost of the product (US$) Enterprise Comprehensive, Projects with high critical database and business intelligence requirements. The software provides high reliability and handles huge performance levels for Tier-1 workloads. Per core** Volume licensing, hosting $14,256*** Standard Core database management functionalities and business intelligence capabilities for non-critical workloads with minimal IT resources. Per core** Volume licensing, hosting $3,717*** Standard Core database management functionalities and business intelligence capabilities for non-critical workloads with minimal IT resources. Server + CAL****
(CAL – Client Access License) Volume licensing, hosting, retail FPP $931*** Developer Full-featured version of SQL Server software that allows developers to cost-effectively build, test, and demonstrate applications based on SQL Server software. Per user Free download Free Web Secure, cost effective and highly scalable data platform for public web sites. Available to third party software service providers only. – Hosting only See your hosting partner for pricing Express Free entry-level database that’s ideal for learning, as well as building desktop and small server data-driven applications of up to 10 GB. – Free download Free SQL Azure Costs: For basic level of SQL Azure is $4.99 per month. Business Calculations: For a small critical project, which lasts for 3 months of time, Dedicated database A user needs to buy the Standard version which costs $3,717 (USD) Microsoft AzureSQL Database A user can opt any other Azure model for storing the data 3 * 4.99$ = 14.97$ Cost Savings $ 3702.03 (USD) After 3 months, I finished my project and no need for SQL Server. If we think above the cost savings, it is really huge. Final Result : The above calculations demonstrates the advantages of Azure Computing in the modern era. The above justification clears an option of Pay as you go. How much you’ve used, pay for that. Easy firewall options to control, who can access the databases. SQL access with Virtual machines provides huge cost saving for the customers. Security patches – No need to think about updating the software’s, the cloud providers will take care of these things. Disk space – Maintaining the machine is the core part of the cloud providers. In case of disk filling, an automatic switch over of servers and everything is taken care by Microsoft. Moving databases between different servers to handle increased load – Everything is on simple clicks and the provider will take care of rest. SQL Azure History
SQL Azure was originally announced in 2009 and released in 2010. SQL Azure Step by Step creation
Step 1 : To access or create your Azure services or database. Go to -> Microsoft Azure Step 2 : You need a Microsoft account to login. Use your credit card for initial registration. You’ve got 3 months of free access to Azure portal and afterwards, they will charge for your usage. Step 3: Once you’ve registered and your account will get activated and you can see the initial portal of your Azure platform as below. Step 4: You are able to see the dashboard of your Azure portal as below. Some of the important portions to note down. Option to create your new services List of already created available services List of datacenters in the globe for Microsoft Azure Support console to contact support team – You can raise your problems as tickets and the support team will respond with clear solutions – personally, I love their service Your logged in account details with logout option. Searching option for the objects and also help files. Indications near to search option. In case of any over usage of billing details everything. Billing summary information’s. Step 5: Click “New” and Select “Databases” and you can click “SQL Database” to create your SQL Azure database. Step 6: Once you click the SQL Database, a SQL Database blade will appear in metro style with the below list: Database Name : Name of your SQL Azure database. Subscription Type : Under which subscription(payment model) you are trying to access or create database. Resource Group : It’s a kind of container which will have all the resources logically group together for maintenance purpose. See, I want to give access to a specific set of resources. In that case, I can group together and provide access to that group. This makes easier for me to allocate resources to resource groups based on what makes the most sense for your organization. Azure provides an option of Creating new resource groups Amend to the existing resource groups The option is yours to decide. List of key points to note under resource group. resource – An easily manageable item that is available through Azure. Some of the common resources are: virtual machine, storage account web app database virtual network Makes our life easier, we can deploy, manage, and monitor all the resources for your solution as a group instead of handling them individually. Consistency maintenance – We can repeatedly deploy solutions throughout the project lifecycle with much more confidence on our deployment which is in consistent state. We can manage our infrastructure through declarative templates rather than scripts. Deployment dependencies – Clearly define the dependencies between the resources. So that, they will be deployed in correct order. Select Source: Whether you want to create a blank database – No tables in it. Want to create a sample database – you can see AdventureworkLT. All the tables will be placed in your database. This will be used to work out some samples or quick check on your SQL databases. Backup – Whether this database is a backup database for already created databases (if any) In my case, I need to create my tables by my own. So, I’ve created a blank database. Elastic pool – This is one of the awesome new feature introduced in latest version of SQL Azure. Let’s talk about this one in my later articles. Configure server settings – This option is used to configure the server settings for your SQL Azure platform. Below are some of the points to note down in this area, On selecting this option, a new blade comes right to the existing windows asking for creating a new server or you need to put it in the existing server (if any). On clicking “create a new server” option, you are able to see multiple options to be provided by the user. Such as, Server name Server admin login Password to access the server Confirm password Location of the server you want. (List of available data centers will be provided in the drop down. You can select the server location based on your preference) An additional option is available like, allow Azure services to access server. If you want your Azure service to access, click and enable it. Click select button in the below window and finalize your option. Now comes the very important factor, pricing tier option to select your preference. You got lot of pricing options based on the features like premium, standard and basic level. Let’s talk about the pricing in detail in my future articles. I’ve selected an option of Basic level for my SQL Azure database. The final one is collation option – Collation indicates the way, how you are going to store the data and it is bounded by a set of rules. This is really important to store a varchar or char data type or nchar or nvarchar data type. The reason is we are able to specify case-sensitivity, accent marks kana character types and character width too After selecting the collation type, If you want you can pin the database in to the dashboard for quicker access. Click “Create” button. Now you SQL Azure database is ready to go. Step 7: Below is the database creation blade for your reference. Step 8: You are able to see the database SQLShack database is created in the server sqlshackvenkat server. It is displayed in your dashboard as below, Step 9: On clicking the newly created SQL Server “sqlshackvenkat” you are able to see all the internal details as below. Final Step 10: Below is the overall features and details of our SQL Azure database created. Author Recent Posts Venkatesan JayakanthamVenkatesan Prabu, Managing Director, KaaShiv InfoTech, India. He got 16 International awards(9 awards from Microsoft). Microsoft Awarded Most Valuable Professional on Dataplatform/database technologies and Azure Platform (Cloud computing). He usually writes articles for his blog http://venkattechnicalblog.blogspot.in/ & website www.wikitechy.com Latest posts by Venkatesan Jayakantham (see all) Microsoft Azure SQL Database – Step by Step Creation tutorial - March 14, 2017 Related posts
How to migrate MySQL tables to Microsoft Azure SQL database Integrate On-Premises and Azure using a site-to-site VPN with RRAS (step-by-step) Transparent Data Encryption (TDE) on Azure SQL database Storing Twitter feeds with Microsoft Flow in Azure SQL Database Working with Azure Active Directory and Azure SQL Database 15,291 Views Follow us
Popular
SQL Convert Date functions and formats SQL Variables: Basics and usage SQL PARTITION BY Clause overview Different ways to SQL delete duplicate rows from a SQL Table How to UPDATE from a SELECT statement in SQL Server SQL Server functions for converting a String to a Date SELECT INTO TEMP TABLE statement in SQL Server SQL WHILE loop with simple examples How to backup and restore MySQL databases using the mysqldump command CASE statement in SQL Overview of SQL RANK functions Understanding the SQL MERGE statement INSERT INTO SELECT statement overview and examples SQL multiple joins for beginners with examples Understanding the SQL Decimal data type DELETE CASCADE and UPDATE CASCADE in SQL Server foreign key SQL Not Equal Operator introduction and examples SQL CROSS JOIN with examples The Table Variable in SQL Server SQL Server table hints – WITH (NOLOCK) best practices Trending
SQL Server Transaction Log Backup, Truncate and Shrink Operations Six different methods to copy tables between databases in SQL Server How to implement error handling in SQL Server Working with the SQL Server command line (sqlcmd) Methods to avoid the SQL divide by zero error Query optimization techniques in SQL Server: tips and tricks How to create and configure a linked server in SQL Server Management Studio SQL replace: How to replace ASCII special characters in SQL Server How to identify slow running queries in SQL Server SQL varchar data type deep dive How to implement array-like functionality in SQL Server All about locking in SQL Server SQL Server stored procedures for beginners Database table partitioning in SQL Server How to drop temp tables in SQL Server How to determine free space and file size for SQL Server databases Using PowerShell to split a string into an array KILL SPID command in SQL Server How to install SQL Server Express edition SQL Union overview, usage and examples Solutions
Read a SQL Server transaction logSQL Server database auditing techniquesHow to recover SQL Server data from accidental UPDATE and DELETE operationsHow to quickly search for SQL database data and objectsSynchronize SQL Server databases in different remote sourcesRecover SQL data from a dropped table without backupsHow to restore specific table(s) from a SQL Server database backupRecover deleted SQL data from transaction logsHow to recover SQL Server data from accidental updates without backupsAutomatically compare and synchronize SQL Server dataOpen LDF file and view LDF file contentQuickly convert SQL code to language-specific client codeHow to recover a single table from a SQL Server database backupRecover data lost due to a TRUNCATE operation without backupsHow to recover SQL Server data from accidental DELETE, TRUNCATE and DROP operationsReverting your SQL Server database back to a specific point in timeHow to create SSIS package documentationMigrate a SQL Server database to a newer version of SQL ServerHow to restore a SQL Server database backup to an older version of SQL Server Categories and tips
►Auditing and compliance (50) Auditing (40) Data classification (1) Data masking (9) Azure (295) Azure Data Studio (46) Backup and restore (108) ►Business Intelligence (482) Analysis Services (SSAS) (47) Biml (10) Data Mining (14) Data Quality Services (4) Data Tools (SSDT) (13) Data Warehouse (16) Excel (20) General (39) Integration Services (SSIS) (125) Master Data Services (6) OLAP cube (15) PowerBI (95) Reporting Services (SSRS) (67) Data science (21) ►Database design (233) Clustering (16) Common Table Expressions (CTE) (11) Concurrency (1) Constraints (8) Data types (11) FILESTREAM (22) General database design (104) Partitioning (13) Relationships and dependencies (12) Temporal tables (12) Views (16) ►Database development (418) Comparison (4) Continuous delivery (CD) (5) Continuous integration (CI) (11) Development (146) Functions (106) Hyper-V (1) Search (10) Source Control (15) SQL unit testing (23) Stored procedures (34) String Concatenation (2) Synonyms (1) Team Explorer (2) Testing (35) Visual Studio (14) DBAtools (35) DevOps (23) DevSecOps (2) Documentation (22) ETL (76) ►Features (213) Adaptive query processing (11) Bulk insert (16) Database mail (10) DBCC (7) Experimentation Assistant (DEA) (3) High Availability (36) Query store (10) Replication (40) Transaction log (59) Transparent Data Encryption (TDE) (21) Importing, exporting (51) Installation, setup and configuration (121) Jobs (42) ►Languages and coding (686) Cursors (9) DDL (9) DML (6) JSON (17) PowerShell (77) Python (37) R (16) SQL commands (196) SQLCMD (7) String functions (21) T-SQL (275) XML (15) Lists (12) Machine learning (37) Maintenance (99) Migration (50) Miscellaneous (1) ►Performance tuning (869) Alerting (8) Always On Availability Groups (82) Buffer Pool Extension (BPE) (9) Columnstore index (9) Deadlocks (16) Execution plans (125) In-Memory OLTP (22) Indexes (79) Latches (5) Locking (10) Monitoring (100) Performance (196) Performance counters (28) Performance Testing (9) Query analysis (121) Reports (20) SSAS monitoring (3) SSIS monitoring (10) SSRS monitoring (4) Wait types (11) ►Professional development (68) Professional development (27) Project management (9) SQL interview questions (32) Recovery (33) Security (84) Server management (24) SQL Azure (271) SQL Server Management Studio (SSMS) (90) SQL Server on Linux (21) ►SQL Server versions (177) SQL Server 2012 (6) SQL Server 2016 (63) SQL Server 2017 (49) SQL Server 2019 (57) SQL Server 2022 (2) ►Technologies (334) AWS (45) AWS RDS (56) Azure Cosmos DB (28) Containers (12) Docker (9) Graph database (13) Kerberos (2) Kubernetes (1) Linux (44) LocalDB (2) MySQL (49) Oracle (10) PolyBase (10) PostgreSQL (36) SharePoint (4) Ubuntu (13) Uncategorized (4) Utilities (21) Helpers and best practices BI performance counters SQL code smells rules SQL Server wait types © 2022 Quest Software Inc. ALL RIGHTS RESERVED. GDPR Terms of Use Privacy