In the previous posts of this series (Part 1 and Part 2) I walked through the creation and population of an Azure SQL Database that contains "real world" crime statistics (with granularity down to the individual police report). This is a very simple database de...
Let’s login to Azure new portal and create a SQL database. For creating a database on Azure portal, you have to fill in some details of it. Give a name to your database, subscription name, resource group whatever you want to use, blank database and a Server. Click Servers, if you...
I will tell you the steps of creating an Azure SQL Database as PaaS (Platform As A Service ). Azure SQL Database has some difference with the On premises SQL Server. I will going to explain details of many of these difference in my later articles...
In this series, i am gonna teach you how we can develop RESTful API in Asp.Net and how we can consume this RESTful API in Xamarin.Android. In the first episode, i will create SQL database in Azure portal.
Step 1. Setting up Azure Step 2. Creating a new PHP WebSite on Azure Step 3. Configuring a MySQL database on Azure Step 4. Uploading files to Azure Step 5. Connecting a Github repo to Azure Step 6. Connecting a PHP app to a MySQL da...
I signed up for Azure fundamental online course recently. While running the exercise on SQL database creation using the Sandbox option, a message popped up on the screen. ‘You don’t have permission to create a database. You will be billed by end of the month”. It surprised me be...
Microsoft Azure SQL Database with the AdventureWorksLT sample database installed, using SQL Server Logins AdventureWorks has standardized on the Microsoft SQL Server Relational Database Management System platform, and the Development team wants to use a managed service for the database rath...
For example if you would like to create a new SQL login on Azure SQL Database (i.e. name it “testLogin1“) and you would like to make this login a db_owner on database “TestDB1“, then the process would be the below:
This Hands-On Lab is comprised of the following exercises: Create or configure a SQL Azure database Create a database schema for the SQL Azure database Load sample data into the SQL Azure database schema Estimated Time to complete this lab:30 minutes ...
Elastic pooling a cost-effective feature in the Azure SQL Database. If you are running multiple databases on one server, you can share the DTUs and storage between these databases. This feature is important when you are having multiple databases on a server. ...