-->
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.

SQL Server – Concat_WS function in SQL Server 2017

Hello friends, Please find the link for my new article at below url – https://social.technet.microsoft.com/wiki/contents/articles/44327.sql-server-concat-ws-function-in-sql-server-2017.aspx    Regards Kapil Advertisements Tagged: concat_ws, Sql Server, SQL Server 2017, Sql Server Developement

Read more

0 comments, 272 reads

Posted in Kapil Blogs on 26 October 2017

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   Tagged: Identity_Cache, Sql Server, SQL Server 2017, Sql Server Developement

Read more

0 comments, 266 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, 283 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, 255 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, 302 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, 271 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, 349 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, 263 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, 438 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, 344 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, 316 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, 342 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, 314 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, 499 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, 371 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, 456 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, 369 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, 354 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, 442 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, 652 reads

Posted in Kapil Blogs on 28 November 2016

Older posts