Kapil Singh

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.

All authors

Sysmail_help_principalprofile_sp – SQL Server Database Mail Stored Procedure – Part 10

by Kapil Singh

Kapil Blogs

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

2015-06-15

408 reads

Sysmail_add_principalprofile_sp – SQL Server Database Mail Stored Procedure – Part 9

by Kapil Singh

Kapil Blogs

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

2015-06-13

491 reads

Sysmail_help_profileaccount_sp – SQL Server Database Mail Stored Procedure – Part 8

by Kapil Singh

Kapil Blogs

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

2015-06-08

415 reads

Sysmail_add_profileaccount_sp – SQL Server Database Mail Stored Procedure – Part 7

by Kapil Singh

Kapil Blogs

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

2015-06-04

490 reads

What is User Defined function in SQL Server?

by Kapil Singh

Kapil Blogs

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

2015-06-01

373 reads

Sysmail_help_Account_sp – SQL Server Database Mail Stored Procedure – Part 6

by Kapil Singh

Kapil Blogs

Hi friends, in this blog we will learn how to get information about database mail account using stored procedure sysmail_hep_account_sp....

2015-05-30

870 reads

Sysmail_add_account_sp – SQL Server Database Mail Stored Procedure – Part 5

by Kapil Singh

Kapil Blogs

Hi friends, today we will continue with database mail stored procedure and will learn how to create database mail account...

2015-05-28

968 reads

Sysmail_help_profile_sp – SQL Server Database Mail Stored Procedure – Part 4

by Kapil Singh

Kapil Blogs

Hi friends, today we will learn how to get information about database mail profile using stored procedure sysmail_help_profile_sp. Sysmail_help_profile_sp stored...

2015-05-26

335 reads

Find blocking using sp_who in SQL Server

by Kapil Singh

Kapil Blogs

Hi friends, in this blog I will tell you how can we find blocking using sp_who system stored procedure. Also,...

2015-04-22

296 reads

How CONCAT_NULL_YIELDS_NULL behave with computed columns In Sql Server

by Kapil Singh

Kapil Blogs

Hi friends, in this blog I am going to tell you about effect of CONCAT_NULL_YIELDS_NULL for computed columns while creating...

2015-04-18

237 reads

All authors

Kapil Singh

Sysmail_help_principalprofile_sp – SQL Server Database Mail Stored Procedure – Part 10

Sysmail_add_principalprofile_sp – SQL Server Database Mail Stored Procedure – Part 9

Sysmail_help_profileaccount_sp – SQL Server Database Mail Stored Procedure – Part 8

Sysmail_add_profileaccount_sp – SQL Server Database Mail Stored Procedure – Part 7

What is User Defined function in SQL Server?

Sysmail_help_Account_sp – SQL Server Database Mail Stored Procedure – Part 6

Sysmail_add_account_sp – SQL Server Database Mail Stored Procedure – Part 5

Sysmail_help_profile_sp – SQL Server Database Mail Stored Procedure – Part 4

Find blocking using sp_who in SQL Server

How CONCAT_NULL_YIELDS_NULL behave with computed columns In Sql Server

Blogs

Think Twice Before Enabling Fabric’s Inbound Network Protection

Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python

Advice I Like: Responsibility

Forums

ALAMAT KANTOR BCA KCP Pondok Gede Telp:083831618008

AI Observability Challenges in FinOps as a DBA

Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL

Question of the Day

Finding a Database Master Key