indiandotnet

PWDCOMPARE–a hidden function of SQL SERVER TIP #88

  I the last tip TIP#88 we saw how to encrypt a password. Now in this tip I would like to share how to check encrypted password ? Means once you stored your encrypted password in database now next step is to compare that particular password with your input password and return results accordingly. The …

How to Encrypt password in SQL Server ? TIP #87

Security is always a concern for every database developer. How to secure valuable information is one of the major and important aspect. The first approach toward security to have a strong username & password and the next step is to have password in encrypted form. Now this article will help you to encrypt your password …

How easy to determine table dependencies ? TIP # 86

  Determine the table dependencies is challenging sometime but we can easily resolve this by using a simple stored procedure which  SQL Server provides. By using this stored procedure we can easily determine all the dependencies of particular table. The stored procedure is sp_msdependencies We can use this stored procedure as shown below Execute sp_msdependencies …

“sp_helptext“ – Useful command to view detail TIP #85

  It might be already known to you but I thought for sharing because I frequently use this command and it is very useful command. When someone wants to determine detail of a function or stored procedure he/she can use this useful command. The syntax is very simple. Just write sp_helptext Storedprocedure/ functionname For example …

How to Enable / Disable Xp_cmdShell in SQL SERVER? TIP #82

Friends, Sometimes it might be possible that you have to run dos command from SQL SERVER. In such situation you have to enable the xp_cmdShell option of  sql configuration. To enable this we can write following statement EXEC sp_configure ‘show advanced options’, 1;GORECONFIGURE;GOEXEC sp_configure ‘xp_cmdshell’, 1;GORECONFIGURE;GO Just wanted to share that it can be a …

Contained Database–A new feature in SQL SERVER 2012 TIP #81

While working on a project sometimes it happened that we need to shift the database from one server to another due to various reason (sometimes it is only money ). We are aware that this easy step take backup and restore another machine but glitch is what about the users which have access to the …

How to insert value in Identity column ? TIP #80

  Happy new year 2015 . Suppose you have a source table and one destination table (Which is exact replica of source table) and you want to copy all the rows of source table into destination table. Now the challenging part here is that there is an identity column and in source & destination table …

How to determine free space on each fixed drive of server machine using SQL SERVER ? TIP #75

  When you do  SQL Server maintenance one of important aspect is available space on server drive because your SQL SERVER data is dependent on space . Now what you need to do to get free space from each drive ? Just create a simple job which run on daily basis which send you space …

How to replace a specific string from a large string with Write feature ? TIP #72

  This is very interesting feature and I recently come to know this awesome feature. Lets understand this by an example below Suppose we have a student table with following structure  as shown in below image   We have a detail column with VARCHAR(MAX) . Now as it is VARCHAR(MAX) column it may content a …