Sep 7, 2022
Nice table outlining the different data masking functions in Azure. Fully details here.
seen from Venezuela
seen from Japan
seen from United States
seen from China
seen from South Korea
seen from Spain
seen from Chile
seen from Chile
seen from Vietnam
seen from Spain
seen from Singapore
seen from Australia
seen from Australia
seen from United States
seen from Australia
seen from Australia
seen from India
seen from United States
seen from Singapore
seen from United States
Nice table outlining the different data masking functions in Azure. Fully details here.
Creating database instance in Azure
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 -
Read the full article
Azure SQL Geo-Replication in Action
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…
View On WordPress
This article shows how we can create a Azure SQL Database. This article also shows how we can connect to the Azure SQL database.
Microsoft kondigt na platinum lidmaatschap preview van Azure Database voor MariaDB aan
Microsoft sluit zich als platinum sponsor aan bij de MariaDB Foundation, waardoor de technologie gepromoot zal worden en het ondersteunen van continuïteit en samenwerking voor de open-source community onderstreept wordt. Tegelijkertijd kondigt de techgigant een preview van Azure Database voor MariaDB aan. De onthulling vond plaats tijdens de Connect ontwikkelaarsconferentie van Microsoft. Het bedrijf belooft […] http://dlvr.it/Q1FXMd
WhoIsActive for Azure
之前和大家分享了一些 十分有用的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…
View On WordPress
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...
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
Select SQL Servers from vertical navigation panel. Select your SQL Server Instance. Click on Settings. Go to General and click on Firewall. Switch “Allow Access to Azure services” to ON. Save your firewall settings. Export your Database.
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...
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
Geo Replication process will be visible in SQL Database section.