Wednesday, January 25, 2017

Draw Pie chart using Google chart in MVC

Monday, January 23, 2017

Check Case-Sensitivity in SQL Server

In this article I am going to explain how to Check Case-Sensitivity in SQL Server.


Description:
SQL server determines case sensitivity by collation. COLLATE is the T-SQL clause used to specify a particular collation for an expression. We can use this to validate the users enter password at the time of login.

Thursday, January 12, 2017

Sql server: different approaches to create comma separated list

Sunday, January 8, 2017

Sql server: Encrypt store procedure, view and function

In this article I am going to explain how to Encrypt store procedure, view and function in sql server.


Description:
We write most of logic in Store procedures. Sometime due to security reason we have to hide the logic from end users. Keyword With encryption is used to encrypt the text/logic of store procedure, view and function.

How to take database Backup and restore using command T-Sql

In this article I am going to explain how to take database Backup and restore using command T-Sql.


Description:
We have only 2 commands for database backup, backup database and backup log. Backup database takes backs up the full database and backup log backs up transaction log.

Backup database
Backup database [demo] to disk='D:\demo.bak'

Backup log
backup log [demo] to disk='D:\demolog.bak'

Restore database
restore database [demo] from disk='D:\demo.bak' 









Sunday, January 1, 2017

Sql server REPLACE function