Creating a Microsoft Azure SQL Database (SQL Server in the Cloud)

A SQL Server database can be installed on Microsoft Azure. If you do this, then you don't even need to install SQL Server on your computer.
This video comes from my DP-900 course: rebrand.ly/dp900
My SQL Server Udemy courses are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: rebrand.ly/querying-microsoft-sql-server
98-364: Database Fundamentals (Microsoft SQL Server): rebrand.ly/database-fundamentals
70-462 SQL Server Database Administration (DBA): rebrand.ly/sql-server-dba
Microsoft SQL Server Reporting Services (SSRS): rebrand.ly/sql-server-ssrs
SQL Server Integration Services (SSIS): rebrand.ly/sql-server-ssis
SQL Server Analysis Services (SSAS): rebrand.ly/sql-server-ssas-mdx
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): rebrand.ly/microsoft-powerpivot-ssas-tabular-dax
----
In this video, we will get a free Microsoft Azure account, with around US$200 worth of credit. Then we'll log in, and create an Azure SQL Database with some sample database. We'll then make sure that your computer has access to it.
This is taken from my new DP-900 course. For more details, please click here: rebrand.ly/dp900

[@RajendraPrasad-ol1ki]

Very Nice Thanks for information Rajendra From India .

[@linhtranthiphuong3980]

Thank a lots. Your guidance for using Azure SQl helps me run data cleaning task without installing MS SQL Server in Window 11 :)

[@suvwrites]

Thank you. This one is going to come in my practical exam. Helped a lot.

[@pravarshakollu7646]

how you opened sql server management studio in this video???????????

[@SQLServer101]

Hello. Please see learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms for details. Phillip

[@sagarikaseshagiri]

at 9'51" where you create a new server, I wasn't given the option to create a username and password. I went ahead with creating the server anyway and that is done. But now I can't log in to SSMS as I do not have credentials. And the active directory authentication which I assumed would work isn't. Please help if you have any solution.

[@zakhelezwide1911]

Thanks so much for sharing this information.

[@ekamdavadi15]

How come you have tables, Views and Stored Procedures in your SQL server right after you created it? You should have a blank server, isn't it?

[@SQLServer101]

Hi Ek, thank you for watching. At 11’48” I click the button to install Sample Data. Phillip

[@bankolekehinde906]

Great video. I thought they said the service was free? Why did you still have to pay, or is that just an estimate?

[@SQLServer101]

Hi Bankole. Some of the services are free, and some are free for 365 days. See docs.microsoft.com/en-us/answers/questions/391722/free-tier-azure-sql-database.html for more details. Phillip

[@fadelellaherrami8840]

thank you very much ser

[@t624mohammediqbalaeronauti3]

What's the software used For DB connectivity like SQL workbench

[@SQLServer101]

Hello. You may be talking about SQL Server Management Studio. Please see learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms for details. Phillip

[@radchad4414]

im having validation error in creating sql server. how can i solve that?

[@t624mohammediqbalaeronauti3]

Whats that microsoft software name

[@SQLServer101]

Hello. You may be talking about SQL Server Management Studio. Please see learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms for details. Phillip

[@ekamdavadi15]

I do not think you covered the part in which you stored sample data on the sql server. Correct me if I am wrong.

[@SQLServer101]

Hi Ek, thank you for watching. At 11’48” I click the button to install Sample Data. Phillip

[@rezakhan1304]

Great Video , thanks bro.

[@ceejayviii]

Thanks a lot, Mister, I have an inquiry though, Is it possible to not pay at all but continue to use the database service?

[@SQLServer101]

Hi CeeJay. You can use "Azure SQL Database" "250Gb S0 instance with 10 database transaction units" free for 12 months. See azure.microsoft.com/en-us/pricing/free-services/ . After that, you would have to pay. If you want to use SQL Server for free, have a look at the Developer edition, which you download onto your computer. See kzbin.info/www/bejne/j5CtZ62Dq7uSoK8 . Phillip

[@R-Kannada-DevOps]

In resources we can see sql database and sql server , you have chooses sql database , could you please explain difference between sql database and sql server..

[@SQLServer101]

Hi Kannada. Azure SQL Database is a standalone database in the cloud - it doesn't require a Virtual Machine, whereas SQL Server on a Virtual Machine does. However, Azure SQL Database doesn't have all of the features of on-premises SQL Server or SQL Server on a VM. For more details, please have a look at more DP-900 course on Azure Data: rebrand.ly/dp900 . Phillip

[@jaym9846]

If you go over any limits (ie network, cpu), are charges incurred automatically?

[@SQLServer101]

Hello Jay. If you have entered credit card details, then yes, some charges will be incurred. How much depends on what type of database you have provisioned. Have a look at azure.microsoft.com/en-gb/pricing/calculator/ for details. However, it's easy to keep a check on it. Additionally, for 12 months you do get for free "250 GB of SQL Database standard S0 instance with 10 database transaction units" - see azure.microsoft.com/en-gb/free/ for details.

[@G-ManWaseKasiInManchester]

On you DP900, are you covering everything covered in the Microsoft DP900 course? Because that would be great actually.

[@SQLServer101]

Hi Actually. Yes, in my DP-900 course I cover all of the requirements of Microsoft's DP-900 exam. Phillip

[@subhashpaudel246]

@@SQLServer101 What is Dp-900? where did you get that from. Zero knowledge in sql. need help possibly classes if you offer

[@frenamakenson9844]

Very Nice videlo Save me a lot of time

[@sallymuhammad3649]

Is there a way to put this database on a virtual machine that's already created on azure?

[@SQLServer101]

Hello Sally. If you mean transfer the database, then you would need to install SQL Server on that Virtual Machine, and then copy it onto it. If you mean access the database, then you could install SSMS on that VM, and then access the Azure database through that SSMS. Phillip

[@sallymuhammad3649]

@@SQLServer101 got it..thank you😊

[@ScienceSeekho]

nice video thanks

[@sinduravishnu8306]

thank you

[@rickybrooks2554]

Great video!! 👍

[@alexrosen8762]

Very useful! Thanks