-->
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, 291 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, 238 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, 635 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, 316 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, 399 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, 483 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, 416 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, 442 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, 383 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, 721 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, 463 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, 510 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, 385 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, 666 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, 473 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, 443 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, 488 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, 429 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, 633 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, 508 reads

Posted in Kapil Blogs on 7 August 2017

Older posts