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

Microsoft Azure – Enable Geo replication of data – Cosmos DB Part 2

In this article, we will learn how to replicate the data to any Azure region globally. Global Distribution Azure Cosmos DB allows to distribute the data globally to any available Azure region with a click. With, Azure Cosmos DB data is replicated in a transparent manner. Azure Cosmos DB also…

Read more

0 comments, 186 reads

Posted in Kapil Blogs on 2 July 2018

Microsoft Azure – Introduction to Cosmos DB – Part 1

Hello Friends, Please find the link of new post of about Introduction to Cosmos DB and how to create the cosmos db account as below link – https://social.technet.microsoft.com/wiki/contents/articles/51596.azure-cosmos-db-part-1-introduction-to-cosmos-db.aspx

Read more

0 comments, 193 reads

Posted in Kapil Blogs on 4 June 2018

Microsoft Azure – Azure Mobile App is available now

Hello friends, Please check the below link for my new post on Microsoft Azure Mobile App. https://social.technet.microsoft.com/wiki/contents/articles/51525.microsoft-azure-mobile-app-is-available-now.aspx

Read more

0 comments, 584 reads

Posted in Kapil Blogs on 14 May 2018

SQL Server – TRIM() function in SQL Server 2017

Hello friends, Please check the below link of my new article on TRIM() function in SQL Server 2017 – https://social.technet.microsoft.com/wiki/contents/articles/51047.introduction-to-trim-function-in-sql-server-2017.aspx  

Read more

0 comments, 280 reads

Posted in Kapil Blogs on 8 January 2018

SQL Server – TRANSLATE() function in SQL Server 2017

Hello Friends, Wish you all a very Happy New Year 2018. Please find the link of my first article of year 2018 at below link – https://social.technet.microsoft.com/wiki/contents/articles/51008.translate-function-in-sql-server-2017.aspx

Read more

0 comments, 357 reads

Posted in Kapil Blogs on 1 January 2018

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

Read more

0 comments, 441 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  

Read more

0 comments, 382 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

Read more

0 comments, 406 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

Read more

0 comments, 353 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

Read more

0 comments, 594 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

Read more

0 comments, 428 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

Read more

0 comments, 462 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

Read more

2 comments, 357 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, 603 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, 438 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, 411 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, 448 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, 401 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, 608 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, 477 reads

Posted in Kapil Blogs on 7 August 2017

Older posts