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

Archives: June 2015

FOR JSON Clause With AUTO mode In SQL Server 2016

Hi friends, in release of SQL Server 2016 CTP2 one of the feature that introduced is JSON clause. So first …

Continue reading Read more

0 comments, 567 reads

Posted in Kapil Blogs on 30 June 2015

SQL Server – Extended Events in SQL Server 2012

Hi friends, today we will discuss about new performance monitoring system Extended Events which gets introduced in version SQL Server …

Continue reading Read more

0 comments, 574 reads

Posted in Kapil Blogs on 27 June 2015

Sysmail_help_principalprofile_sp – SQL Server Database Mail Stored Procedure – Part 10

Hi friends, in this blog of SQL Server  database mail stored procedure we will continue with another database mail stored …

Continue reading Read more

0 comments, 290 reads

Posted in Kapil Blogs on 15 June 2015

Sysmail_add_principalprofile_sp – SQL Server Database Mail Stored Procedure – Part 9

Hi friends, in this blog of SQL Server Database mail stored procedure we will continue with another database mail procedure sysmail_add_principalprofile_sp. …

Continue reading Read more

0 comments, 302 reads

Posted in Kapil Blogs on 13 June 2015

Sysmail_help_profileaccount_sp – SQL Server Database Mail Stored Procedure – Part 8

Hi folks, in our previous blog of SQL Server Database Mail stored procedure we added database mail account to database …

Continue reading Read more

0 comments, 281 reads

Posted in Kapil Blogs on 8 June 2015

Sysmail_add_profileaccount_sp – SQL Server Database Mail Stored Procedure – Part 7

Hi friends, in last previous blogs we created database mail profile and database mail account. In this blog we will …

Continue reading Read more

0 comments, 317 reads

Posted in Kapil Blogs on 4 June 2015

What is User Defined function in SQL Server?

User-defined functions encapsulate T-SQL statement and return a table or a scalar value to the caller. UDFs can not be …

Continue reading Read more

0 comments, 240 reads

Posted in Kapil Blogs on 1 June 2015