-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Kapil Blogs

Hi friends, I am Kapil Singh Kumawat and I am from Jaipur in Rajasthan, India. I have been working with SQL Server for the last four and a half years and am currently working with Cognizant Technology Solutions as an SQL Server Developer. I have experience in performance tuning, SSIS, data migration, database designing and writing queries. My other interests include travelling, watching football and listening to music.

Identity_Cache feature introduced in SQL Server 2017

Hello friends, Please find the full article at this link – https://social.technet.microsoft.com/wiki/contents/articles/40666.sql-server-identity-cache-feature-in-sql-server-2017.aspx   Advertisements Tagged: Identity_Cache, Sql Server, SQL Server 2017, Sql Server Developement

Read more

0 comments, 168 reads

Posted in Kapil Blogs on 11 October 2017

SQL Server Features Comparison at IaaS vs PaaS vs On Premise

Hello friends, Please find the link for my blog here – https://social.technet.microsoft.com/wiki/contents/articles/40295.sql-server-features-and-basic-comparison-at-iaas-vs-paas-vs-on-premise.aspx Tagged: Azure, Microsoft Azure, SQL Azure, Sql Server, SQL Server 2016

Read more

0 comments, 173 reads

Posted in Kapil Blogs on 5 October 2017

How to reset the password of Microsoft Azure virtual machine using PowerShell

Hello friends, Please find the link of my article here – https://social.technet.microsoft.com/wiki/contents/articles/40112.microsoft-azure-how-to-reset-the-password-of-azure-virtual-machine-using-powershell.aspx Tagged: Azure, AzureSubscription, Microsoft Azure, Powershell, Reset Password, Virtual Machine, Windows Powershell

Read more

0 comments, 168 reads

Posted in Kapil Blogs on 2 October 2017

Error – Unable to retrieve child resources in Azure Storage Explorer

Hello friends, Please find the link of this article here – https://social.technet.microsoft.com/wiki/contents/articles/40188.error-unable-to-retrieve-child-resources-in-azure-storage-explorer.aspx Tagged: Azure, Azure Storage, Microsoft Azure, SQL Azure

Read more

0 comments, 189 reads

Posted in Kapil Blogs on 27 September 2017

Delete all the resources from a resource group using Windows PowerShell

Hello friends, Please find my new post at this link – https://social.technet.microsoft.com/wiki/contents/articles/40141.delete-all-the-resources-from-a-resource-group-using-windows-powershell.aspx Tagged: Microsoft Azure, Powershell, resource group, Virtual Machine, Windows Powershell

Read more

0 comments, 190 reads

Posted in Kapil Blogs on 19 September 2017

Microsoft Azure – How to check the available extensions for a virtual machine using Windows PowerShell

Hello friends, Please find the link of my new article – https://social.technet.microsoft.com/wiki/contents/articles/40102.microsoft-azure-how-to-check-the-available-extensions-for-a-virtual-machine-using-powershell.aspx Tagged: Azure, AzureSubscription, Microsoft Azure, Powerhsell, Powershell, Sql Server, Windows Powershell

Read more

0 comments, 269 reads

Posted in Kapil Blogs on 14 September 2017

Microsoft Azure – How to attach data disk to existing Azure Virtual machine using PowerShell

Hello friends, Please checkout the blog at below link – https://social.technet.microsoft.com/wiki/contents/articles/40086.microsoft-azure-how-to-attach-data-disk-to-existing-virtual-machine-using-powershell.aspx Tagged: Azure, AzureSubscription, Microsoft Azure, Powershell, Virtual Machine, Windows Powershell

Read more

2 comments, 192 reads

Posted in Kapil Blogs on 11 September 2017

Microsoft Azure – How to create a virtual machine using PowerShell – Part 2

Hello friends, you can find the post at below link – https://social.technet.microsoft.com/wiki/contents/articles/40010.how-to-create-a-virtual-machine-in-microsoft-azure-using-powershell-part-2.aspx Tagged: Azure, Microsoft Azure, Powerhsell, Powershell, SQL Azure, Virtual Machine, Windows Powershell

Read more

0 comments, 335 reads

Posted in Kapil Blogs on 30 August 2017

Microsoft Azure – How to create a virtual machine using PowerShell – Part 1

Hello friends, you can find the post at below link – https://social.technet.microsoft.com/wiki/contents/articles/40000.how-to-create-a-virtual-machine-in-microsoft-azure-using-powershell-part-1.aspx   Tagged: Azure, Microsoft Azure, Powerhsell, Powershell, SQL Azure, Windows Powershell

Read more

0 comments, 262 reads

Posted in Kapil Blogs on 28 August 2017

Microsoft Azure – How to check details about Azure VM sizes using PowerShell

In this blog we will discuss about how to check the details about Azure VM tiers and sizes. Microsoft Azure has basically three tiers: Basic, Standard and Premium. Difference between these two tiers are the features present in them for virtual machine like high availability, auto scale etc. When we…

Read more

0 comments, 248 reads

Posted in Kapil Blogs on 25 August 2017

Microsoft Azure – How to get details about azure locations using PowerShell

Hello friends, when we create any virtual machine using management portal we need to select the location for cloud service and azure portal shows us list of available locations. We just select the location we want and move further to next steps. We can also do this same using PowerShell…

Read more

1 comments, 263 reads

Posted in Kapil Blogs on 23 August 2017

Microsoft Azure – How to Check the availability of cloud services using PowerShell

Hello friends, in this blog we will learn how to check whether a cloud service is available to use with virtual machine or not. Cloud service is basically how to access virtual machine using virtual IP address (VIP). Cloud services can contain multiple virtual machine by creating cloud service first…

Read more

0 comments, 243 reads

Posted in Kapil Blogs on 21 August 2017

Microsoft Azure – How to create a virtual machine (VM) with Reserved Public IP (VIP)

In my previous blog, we learnt that a Virtual IP (VIP) get lost or changed when we stop or deallocate the virtual machine (VM). So, to overcome this we can assign a reserved IP so that whenever we restart the virtual machine we would get the same IP. Microsoft Azure…

Read more

0 comments, 412 reads

Posted in Kapil Blogs on 11 August 2017

Limitation of Virtual IP address (VIP) in Microsoft Azure – Part 1

Virtual IP (VIP) is a public IP address and created when a cloud service is created. A VIP is a public IP address that can be used to access Virtual machine in Azure. All VM in same domain name share a single VIP. By using a reserved IP address, you…

Read more

0 comments, 291 reads

Posted in Kapil Blogs on 7 August 2017

Azure – Storing all cmdlets in a file using Windows Azure PowerShell

Hello friends, windows Azure Powershell has a big library for Azure cmdlets which is very helpful in doing things without logging to Azure portal. In this blog, we will learn how to get all azure cmdlets from PowerShell window and how to import all cmdlets to a text file for…

Read more

0 comments, 378 reads

Posted in Kapil Blogs on 4 August 2017

Connect to Microsoft Azure Subscription using Windows PowerShell – Part 2

In my previous blog we learnt to connect to Azure subscription by importing azure license setting file. In this blog we will learn an easier method of connecting to azure subscription using Add account method using windows PowerShell. First step is to open the windows PowerShell window. Type the command…

Read more

0 comments, 329 reads

Posted in Kapil Blogs on 3 August 2017

Connect to Microsoft Azure Subscription using Windows PowerShell – Part 1

Hello friends, in this blog we will learn how we can connect to Azure Subscription using PowerShell. As you know we can also perform the operations from PowerShell window which we can do using management portal. We can connect to the Azure subscription from windows PowerShell in 2 ways: Importing…

Read more

0 comments, 326 reads

Posted in Kapil Blogs on 1 August 2017

How to attach a new data disk to Azure VM using Azure Portal

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…

Read more

0 comments, 414 reads

Posted in Kapil Blogs on 5 January 2017

How to backup local SQL database and restore to Azure SQL database

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…

Read more

3 comments, 606 reads

Posted in Kapil Blogs on 28 November 2016

How to collected inventory for SQL Server using Microsoft Assessment and Planning (MAP) tool

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…

Read more

0 comments, 705 reads

Posted in Kapil Blogs on 30 September 2016

Older posts