Posts

AZCopy-- How to copy files from Azure Storage Blob Container to on-premises local storage drive and folder

Image
 This article will describe about how to copy .bak file or .BACPAC file from Azure Blob Container to your on premises local drive and folder. Here I am only describing about only the command which can be used to fulfil our copy request which AZCopy .  This AZCopy is a command line utility which you can download from the mentioned URL. After you download this to a specific drive and folder you to run this from the command prompt(CMD). Before that we need these things. 1) Create a Azure SQL Database and take the backup to Azure Storage blob container. Once the file ready under azure storage you can run AZCopy command from your on-premises server and you can bring to on premises drive and folder. If you see the image below I am need to give READ,ADD,CREATE,WRITE  permissions based on the requirement. Once you give this permissions and after generating SAS please run AZCopy command from the command prompt of your on premises server.  Please see the last image. And the ap...
Post a Comment
Read more

Locally Reduntant Storage(LRS)_Zone-Reduntant Storage(ZRS)_Geo-Reduant Storage.

Image
 The below images are self explanatory. IN detailed explanation available in the link below. Backup Storage Redundancy And the below one is Geo-Zone Redundant storage.
Post a Comment
Read more

Geography_Region_DataCentersOrAvailabilityZones

Image
 This is how Geography,Region,Data Centers or Availability Zones structured like below.
Post a Comment
Read more

Creating a Linked Server between Azure SQL Database and On Premises database.

Image
The topic below describes about how to create a linked server between a Azure SQL Database and an on premises environment. Before that please follow the steps below. 1) Create an Azure SQL Database in Azure 2) Create a login in Azure SQL database or use the same login with which you are connecting to the Azure SQL Database. 3) Create a Linked Server in On premises environment by providing the login details(2nd step). Follow the below images The images below are self explanatory Go to on premises server under server objects to create a linked server. Here the testDB is the name of the database which got created in Azure SQL Database The below Image is the second image where you need to provide security . Here the user name and password are Azure Login information. After click on OK button the linked server will automatically gets created. However the linked server is not shown here. But you can see it from your end once it gets created. The image below is an example of Azure SQL Datab...
Post a Comment
Read more

Connecting Azure SQL Managed Instance with public endpoint(Internet), no need of VPN

Image
We can connect to the Azure SQL Managed instance from our local machine(home machine) if you are practicing or working with Azure Portal, this can be possible without creating VPN. While creating AZure "Sql Managed Instance" please take care of below points under Networking Section while you are creating SQL Managed instance. Please make below changes. For creating a SQL Managed Instance it will a use a dedicated subnet which is associated with NSG(Network Security Group), and we need to make change in this NSG inbound security rule. We need add 3342 in Allow inbound connections. The below Image will you will see after you created SQL Mnaged Instance, this will appear under Virtual Network. You can take above endpoint connection string try to access from SSMS which is installed in your home system. It will allow you to connect, no need of any VPNs
Post a Comment
Read more

Azure SQL Database DTU Calculator

Image
 If we have a plan to migrate our on-premises SQL Server database or   pool of databases  to Azure SQL Databases. We need to check for which we service tier we need to choose first for that particular database(s) in the cloud , to check this we have DTU (Database Transaction Units) calculator 1) Download the below PowerShell script and run it for one hour, chose that particular hour in which you usually see the load DTU Calculator Set-ExecutionPolicy -Scope Process -ExecutionPolicy Unrestricted -Force $ErrorActionPreference = "Stop" $VerbosePreference = "Continue" cls Write-Output "Collecting counters..." Write-Output "Press Ctrl+C to exit." $counters = @ ( "\Processor(_Total)\% Processor Time" , "\LogicalDisk(_Total)\Disk Reads/sec" , "\LogicalDisk(_Total)\Disk Writes/sec" , "\SQLServer:Databases(_Total)\Log Bytes Flushed/sec" ) Get-Counter -Counter $counters -SampleInterval 1 -MaxSampl...
Post a Comment
Read more

Configuring Always on setup in Microsoft Azure.

Image
I mentioned those steps here in which i face issues, remaining procedure same. 1)       1)  Go to custom deployments in market place of azure and search with below word. active-directory-new-domain . And it shown like below https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/application-workloads/active-directory/ active-directory-new-domain /azuredeploy.json Provide below values to the fields. Please provide values for the domainname and dnsprefix appropriately. domainname : aoag.contoso.com-->name should give this way and contoso.com is compulsory. dnspefix : aoagl location: eastus2 Vnet: adVNET DomainFQDN: aoag.contoso.com(this will come in later part) 3)       After creating above domain VM. Create two “ SQL Server Virtual VMs ”,(chose SQL Server 2017 version don't chose SQL Server 2019 as this version has some issues with SQL IaaS extensions) not regular VM. Search in the market place as “SQL Vir...
Post a Comment
Read more