#azure database

Step 1: Azure Subscription You would need to subscribe for azure portal in order to use azure services. Below is the link for azure portal – https://portal.azure.com/ If you do not have an Azure account, provide your email or telephone number and it will verify that you are not in the system and will invite you to create an account. There is an option for a free trial account with $200 USD in credits for 30 days, so you can play with Azure resources without spending money during those 30 days. Step 2: Create SQL Database Once you are subscribed on azure , you can go to “SQL Databases” link and click "Create SQL Database". Once you click on "Create SQL Database" , you will see the form as below –

Step 3: Create Server In order to create database instance ,you need to create server as highlighted below -

Step 4: Create Database Instance After all the configuration is done , you can create database instance by clicking Review + Create button as shown below -

Now the database instance is up and running as shown below screen -

Step 5: Access Database You can see database details once you open the resource as below -

You connect to database using visual studio to perform various operations -

You need to install below plugin in Visual Code Studio to connect to database.

Once the plugin is installed , you can connect to database by giving database details . Also you can connect and access database from azure platform -

Azure SQL Geo-Replication in Action

Azure has been offering a lot of overwhelming services, but for me, if I need to rate top 3 Azure SQL will definitely be there. If you are coming from the historic era of SQL on-prem i.e. SQL Server 2000 and later you would definitely agree with me.

Considering Azure SQL off the shelf benefits already gives it a lead over SQL server few are as below:

Azure SQL environment i.e. servers, security…

之前和大家分享了一些 十分有用的SQL Script 用來 Monitor / 檢查 SQL Server  MS SQL Notes – Database Management Scripts 今日同事想查詢公司某一個Database 有什麼query 正在執行

在這個情況..使用sp_whoisactive 這個script　便最適合了 可以看到有什麼query在執行..和已經執行多久 可惜嘗試在 Azure的database 安裝時出現了些問題 應該是permission的問題..不能在master上執行

做了一會research之後發現..原來他有一個給Azure 用的WhoIsActive script 只需要在每一個Azure 上的Database 執行便可以了

詳情可以考以下Blog Post

http://sqlblog.com/blogs/adam_machanic/ar…

New Post has been published on http://robertfertig.com/azure-sql-failed-export-database-storage-account/

Azure SQL failed to export the database to storage account

Azure SQL failed to export the database to storage account

Description

Failed to export the database: dbname. ErrorCode: 400 ErrorMessage: There was an error that occurred during this operation : ‘<string xmlns=”http://schemas.microsoft.com/2003/10/Serialization/”>Error encountered during the service operation. ; Exception Microsoft.SqlServer.Management.Dac.Services.ServiceException:Unable to authenticate request; </string>’ STATUS Error TIME Day Date Time Minute CORRELATION IDS abcdef-1234-1234-1234-1234567890

Fix

New Post has been published on http://robertfertig.com/configure-geo-replication-for-azure-sql-db/

Configure Geo Replication for Azure SQL DB

Azure SQL DB Geo Replication Configuration

In the last post I explained how to create a SQL Database Instance on Azure. This time I will show you how to Configure Geo Replication for Azure SQL DB.

Follow these steps to Configure Geo Replication for Azure SQL DB:

Login to the Microsoft Azure Portal .

Click on All resources in vertical navigation panel.

Click on your SQL Databases.

Select your databases. In my case I will configure Geo Replication for db1 database

  Click on Configure Geo-Replication at the bottom of the page.

  Select your target location for Geo-Replication.

In my example I will use West Europe

  Click on Target Region

Configure secondary database settings.

Select Pricing tier

Select Secondary database type. In my example I will use Non-readable for DR purpose.

Click on target server and Configure required settings.

  Create a new server or use existing one.

In my example I will create a new server.

Specify Server name

Specify your administrative credential and click select.

      Your secondary database settings will be visible as bellow.

Click OK to Initialize Geo Replication.

  Database replication process will be initialized and visible as bellow:

Initializing…

  Sending..

  Geo Replication process completed