In this blog I will tell you how we can attach a data disk to an Azure Virtual Machine using Azure Portal. We can also upload an existing data disk from on-premise data center to Azure and then add that disk as data disk to a VM. Navigate to the new Azure Portal at https://portal.azure.com… Continue reading How to attach a new data disk to Azure VM using Azure Portal
Hi friends, recently I was finding a way on taking backup of local database and restore that database to Azure SQL database. I found that there is new option available to generate the scripts for Microsoft SQL Azure database using Generate Scripts option. Let me walkthrough step by step on how we can take the… Continue reading How to backup local SQL database and restore to Azure SQL database
Hi friends, We need to collect inventory for database migration as well as platform to set up environment for migration, development and testing. Is there any tool from Microsoft to achieve this scenario? Yes, we have Microsoft Assessment and Planning Tool (MAP) for it. From BOL: The Microsoft Assessment and Planning (MAP) Toolkit is an… Continue reading How to collected inventory for SQL Server using Microsoft Assessment and Planning (MAP) tool
In my previous blog we discussed about the different format of SQL Server execution plan. Now in upcoming blogs we will discussed about the most commonly seen operators we see when execution plan generates. In this post I will start the easy one that is Table Scan operator. As with the name of operator Table… Continue reading SQL Server Execution Plan Operator – Table Scan
Execution plan helps in knowing how a query gets executed and troubleshooting a query which is performing poor. In SQL Server execution plan can be of 2 types: Estimated Execution plan Actual Execution plan Execution plan can be viewed in 3 different formats: Text format XML format Graphical format We can choose the format on… Continue reading SQL Server Execution Plan formats
Overview To save any organisation from any big future loss, one needs make a proper strategy or disaster plan that will save them in their hard time. When working with critical data it becomes very necessary to backup organisation data. In any organisation, for an administrator it is very important task to make a disaster… Continue reading Importance of Database Backup In SQL Server
Hi friends, one more limitation of In-Memory OLTP is SQL Server 2016 is that sp_rename is not allowed to change the name of in-memory OLTP objects. Sp_rename is a system stored procedure which allows to change the name of the user-defined objects like table name, column name, datatype of a column etc. in the current… Continue reading Limitation of In-Memory OLTP in SQL Server 2016 – Sp_rename not allowed
