SQL Server Managed instances are going to be the next big thing in the SQL server world. Currently, it’s in preview and promises a lot to offer. After this offering will come into GA, I hope we can witness many migrations from SQL server VM to SQL Server Managed Instances. Now if you are new
It’s always recommended to check Azure Resource Health before doing any further troubleshooting. I am giving you two interesting examples which we have seen in the past. Recently few DBA’s has complained about the slow running of the SQL queries in some of our large ERP databases for some of the day in a week.
I will be attending the data platform summit 2018 #DPS10, which is going to be started from tomorrow. This summit will be held for three days at Hotel Radisson Blue at the outer ring road, Bangalore. 3 Days of Conference, 7 Tracks, 30+ Technologies, 50+ Speakers, 90+ Subjects, 100+ Sessions, 300+ Companies, 1000+ Attendees &
As an Azure Pre Sales or Delivery Architect, there must be lots of pressure on you to find various ways to save/reduce the cost/spend in the cloud. Your KPI and KRA may be also integrated with the cost savings which you can show at the end of the year. How to save the operational cost
Just after 1 year and 7 months of its launch, today my blog on Microsoft Azure has crossed 200000 (2 Lacs) visitors. I would like to thanks all the Microsoft Azure enthusiastic who have spent their valuable time in reading my blog posts. When I have started writing in Jan. 2017 I have never thought
Since Azure File Sync which is currently on GA you can upgrade your old agents in your Azure or On-Premise servers. It’s also very easy to do that and can be done by following few steps which I will show you. Upgradation Steps: Go to the Windows server 2016 or Windows Server 2012 R2 where
PowerShell 6 was in GA last January and many of us has already started working with it and the below news was really big leap for the PowerShell lovers. And the good news is that PowerShell 6.0 is also supported in Linux. For the one who have missed the release of the PowerShell 6 can
MS has released three beta exams for the MS Azure on July 16th. You can try them if you have time. They are listed as follows: AZ-100: Microsoft Azure Infrastructure and Deployment (beta) AZ-101: Microsoft Azure Integration and Security (beta) AZ-102: Microsoft Azure Administrator Certification Transition (beta)
I think many of you have seen the power of Azure File Sync, I thought to write an article on Azure File Sync for many days but unable to work on it due to various other assignments. Also we are long waiting for some of the changes which were needed for AFS and recently added
Picture Credit: Royalty Free Pictures from Pexeles.com The Azure Resource Manager model has come up with the option to upgrade to VM Backup Stack V2. There are many salient features of the VM Backup Stack V2 , the main price point I believe is the ability to take the snapshot backup of the disks up
Recently I have been asked by few people about the Azure VM charges. Let’s see how Azure Bill for the VM. Please note that when a new VM spin-up Azure starts charging for the following meters. Compute hours IP Address hours (if the Public IP is static) Data Transfer Out (it’s about the data get
Azure Platform guys are again in dilemma with the new release of the Standard SSD Disks. This new disk offering combines the elements of Premium SSD Disks and Standard HDD Disks to form a cost-effective solution. They need to change their storage plans again in the regions where it will be currently supported or soon
Recently I got a chance to work on the Azure Backup of the SQL Server VM’s. In this post, I am going to share my experience with the Azure Backup of SQL Server VM’s. In Part II of this post, I will share my experience with Recovery of the Backup databases. Please note that this
As many of you know that Azure ExpressRoute let us to extend our on-premises infrastructure to Azure Cloud over a private dedicated connection. With ExpressRoute, you can establish connections to Microsoft Azure Network. If you are from the Azure pre sales background or an Azure Architect like myself, you must be aware that in most
It’s not very easy to delete Azure Recovery Services Vault because it’s generally contain multiple objects in it. If you don’t delete the recovery services vault which is not in use in a timely manner it may incur additional Azure Bills which you may not anticipated. Today I will show how you can easily delete
Sometimes if you are not using a Azure VM there is a quite possibility that you will forget the password of the VM, there is a way to reset the password for the Azure ARM based VM’s. You can reset the password from the Azure Portal as you can see below. Go to the reset
Today I have noticed that a new button for the directory and subscription filter added in the Azure Portal. It was the need of the hour otherwise browsing through multiple subscription was becoming pain for the MS Admins. Kudos to the design team for considering the feedback from the community. Here is the screen shot.
Dear friends in my last two posts (Part I and Part II ), I have shown you how to install Azure Analysis Services and today I will show you the step by step installation of the On-Premises Gateway for the Azure Analysis Services. To start with first you need to download the setup of the
In my last post I have shown you how to create and configure the Analysis services in Azure. Today I will show you how to connect to the Analysis Services from Visual Studio SSDT (SQL Server Data Tools). In my lab environment the initial Architecture was as follows. Fig: Azure Analysis Service Initial Architecture. The
This post I have targeted to the BI developers and system admins who are interested to configure and work with the SQL Server Analysis Services in Azure (Called Analysis Services in Azure) What is SQL Server Analysis Services? SQL Analysis Service is the PaaS instance of SQL Server Analysis Services. It’s an analytical data engine
Dear friends, ensuring your application workloads and data are secure is essential, but it is not enough. Monitoring play an important role for any infrastructure. For IaaS workloads, Azure Monitoring play a very important role and this require ‘s almost similar effort what you need to monitor your on premises infrastructure. We need continuous monitoring
I think if you are an old school infrastructure management service techie, you must have been part of many DR excersice during your various job roles. If you are a pre sales techie, in many of the pre sales discussion you may have tried to convince your customers that Microsoft Azure enviroment is highly reliable
When you deploy App Services in Azure sometimes it’s necessary to connect to on premises data sources which may a database server or monitoring server (SCOM) or some other application data. Since your App Service is using a predefined netwok it’s important to use Hybrid connections since Hybrid connections allowed the connectivity with the resources
Sometimes you need more public IP for your subscription and the ARM resources limit is set at ‘Per region per subscription’ basis. Therefore, 20 is the default limit per region in the subscription. You would have 20 as default limit for all the regions respectively. Like any other quota increase request you need to open
Unable to RDP to Azure VM is a very common issue faced by many people worldwide. If you have installed the terminal services or RDS the RDP issue is more common. As per Microsoft there are multiple troubleshooting steps mentioned in the troubleshooting session. And here is the list. Reset Remote Desktop configuration. Check Network
I know many of you are using the Azure MARS backup agent for taking the backup of the files and folders. Today I would like to share with you some issues which we have faced recently with Azure MARS backup agent. This blog post will also have the resolutions of those issues as well. Issue
Recently we have faced issues related to the backup of the Azure VM, the VM is a newly build Azure IaaS server. While taking the snapshot backup of the Azure VM we have found that that we are unable to take the backup and this VM and this is the error message that is generated
