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

0 comments, 123 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, 113 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, 329 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, 210 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, 289 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, 252 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, 268 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, 364 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, 549 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, 651 reads

Posted in Kapil Blogs on 30 September 2016

SQL Server Execution Plan Operator – Table Scan

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…

Read more

0 comments, 320 reads

Posted in Kapil Blogs on 28 September 2016

SQL Server Execution Plan formats

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…

Read more

0 comments, 640 reads

Posted in Kapil Blogs on 14 September 2016

Importance of Database Backup In SQL Server

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…

Read more

0 comments, 375 reads

Posted in Kapil Blogs on 1 September 2016

Limitation of In-Memory OLTP in SQL Server 2016 – Sp_rename not allowed

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…

Read more

0 comments, 330 reads

Posted in Kapil Blogs on 21 July 2016

Getting started with In Memory OLTP in SQL Server 2016 – Part 1

In Memory OLTP (Hekaton) introduced in SQL Server 2014 is a new database engine component which is optimized for OLTP workloads to achieve the performance by storing data in memory and accessing data from memory. Memory optimized tables can be accessed using Transact –SQL. When memory optimized tables are accessed…

Read more

0 comments, 518 reads

Posted in Kapil Blogs on 18 July 2016

Limitation of In-Memory OLTP in SQL 2016 – Create Index is not supported

Hi friends, in this blog I will discuss another limitation of In Memory OLTP in SQL Server 2016. Once you create a table you cannot create any index created on memory optimized table using CREATE INDEX statement. So to create indexes you need to create them with column definition of…

Read more

1 comments, 345 reads

Posted in Kapil Blogs on 17 July 2016

SQL Server – How to retrieve SQL plans from Cache

Hi friends, in this blog post I will tell you how we can retrieve the SQL plan from the cache. In SQL Server there are multiple DMV (Dynamic Management Views) and DMO (Dynamic Management Objects) which can be used to retrieve the information about execution plan. Sys.dm_exec_query_plan is most commonly…

Read more

1 comments, 524 reads

Posted in Kapil Blogs on 13 July 2016

SQL Server – String_Escape function in SQL Server 2016

Hi friends, in SQL server 2016 another string function that introduced is String_Escape. This function can escape special characters within texts and will return text with escaped characters. Syntax STRING_ESCAPE (expression, type) Currently only the value that is supported for type argument is ‘json’ only. If you try to specify…

Read more

1 comments, 827 reads

Posted in Kapil Blogs on 10 July 2016

Microsoft SQL Server 2016 Certifications Announced

Hi friends, Microsoft has announced the release of three new SQL 2016 certifications, based on the different working database professional’s roles. MCSA: SQL 2016 Database Development can be achieved by passing the following two exams: 70-761 – Querying Data with Transact-SQL 70-762 – Developing SQL Databases MCSA: SQL 2016 Database…

Read more

0 comments, 600 reads

Posted in Kapil Blogs on 8 July 2016

SQL Server – STRING_SPLIT function in SQL Server 2016

Hi friends, in SQL server 2016 another new function STRING_SPLIT gets introduced which helps in splitting the character expression using separator. Previously, to do this type of work we need to write some code or function to split the character expression but in SQL 2016 function STRING_SPLIT reduce that work…

Read more

0 comments, 421 reads

Posted in Kapil Blogs on 6 July 2016

Older posts