The database move from production to lower environment is the most common request a DBA can receive, when it comes to MI it could be easy or difficult depending upon your environment. Easy when you have configured the MI with Service-managed key and all the different instances are in the same subscription. And difficult in […]
I have done this multiple times when I need to create a duplicate VM having same configuration set as before. The steps are quite simple and pretty straight forward: Step 1 Create a Snapshot of your OsDisk. Step 2 Once you have got your snapshot created, create a disk using this snapshot. Step 3 Once […]
Starting anything new is always difficult, when I had started with Azure CLI was like foreign language to me. I always felt more comfortable with PowerShell and Portal, but never ever tried to use CLI. But once I started using it I find it much easier to remember and work on it. It could be […]
Sometimes the simplest things becomes difficult to understand just because you are not using it much, and that was the case for Policy and Initiative for me. Azure Policy is a service you use to create, assign, and manage policies. These policies apply and enforce rules that your resources need to follow. These policies can […]
Currently I provide support as a DBA to around 150 developers, some SQL and Cube developers and majority chunk working on SSIS ETL. When you are providing support to many with different level of experience you ought to see some unique errors and requests. Today I got a ping from one of the developers sharing […]
A system-versioned temporal table is a type of user table designed to keep a full history of data changes and allow easy point in time analysis. This type of temporal table is referred to as a system-versioned temporal table because the period of validity for each row is managed by the system (i.e. database engine). […]
It is always difficult to find some relevant information about any error or record from SQL Server logs mostly when you have 100 log files and also has backups information in the logs. Use below script to find a specific string looping through all your logs. GitHub link. It will create a temporary table and […]
Azure Load Balancer operates at layer four of the Open Systems Interconnection (OSI) model. It’s the single point of contact for clients. Load Balancer distributes inbound flows that arrive at the load balancer’s front end to backend pool instances. These flows are according to configured load balancing rules and health probes. The backend pool instances […]
Azure Traffic manager is one of many awesome features available in Azure to better load your data. First thing is what is Azure Traffic Manager? Azure Traffic Manager is a DNS-based traffic load balancer that one can use to distribute traffic optimally to services across Azure regions globally. That is, when boarding the flight the […]
When we need to process the cube to fetch new data from the data source, we can either do it manually by right clicking the cube itself or by creating a SQL Server Agent Job. There are multiple modes of processing the cube and what is updated will depend upon the type of mode chosen. […]
being a dba 