Wednesday, 2 June 2021
Wednesday, 30 December 2020
With one of my client we had to create a external data source between 2 Azure DB's but we were not happy to set Allow Azure services option to enable connectivity for 2 Azure DB's and open up Firewall to DB from all Azure resources so we went through the option of setting Allow Azure Services Off and whitelisting SQL ServiceTag IP's for Azure region where our DB's were hosted, Below is the script i created to accomplish the task and WestEurope is the region I used...
Monday, 15 June 2020
dbmanagerrole, or be the server administrator login. Then execyte the below TSQL(Server name will be just the AZSQL Server name without database.windows.net
Tuesday, 17 December 2019
Friday, 11 October 2019
In order to run the below Powershell script you first need to install MicrosoftPowerBIMgmt module in your powershell environment.
Thursday, 29 August 2019
Monday, 10 June 2019
Let see how it can be configured via Azure Portal,
Primary SQL Instance - td-sqltestinstance
Region - UK West
Database Name - AdventureWorks2017
Secondary SQL Instance - td-sqlinstance-dr
Region - UK South
I am going to create a geo-replication first between the primary and the secondary server and allow geo-replication link to be inherited by the failover group.
I am adding UK South as my secondary server location and keeping the secondary Replica as a readable copy as below,
In the below Pic you can see my secondary read-only replica has been added, Primary Server can be used for all RW functions and Secondary read-only replica can be used for all reports.
As you can see below, UK South has now become primary and UK west is now secondary read only replica but the Listener endpoints remains the same.