New Feature of SQL SERVER

9 Amazing features of SQL SERVER 2016

Although, I know I am bit late to share this thing on our blog but it says in Indian proverb “Der aai durust aai” means it’s OK you came late but you came that is more important. Anyways, so you all might aware that Microsoft launched SQL SERVER 2016 officially in June 2016. You can …

An interesting setting for NULL but don’t use it for future TIP #109

As we discussed earlier in TIP#103 for NULL in which I shared that we have to take extra care for NULL. Now in this tip I would like to share one of the interesting setting for NULL. Although it is just for knowledge but don’t use it because it is deprecated in future version and …

A big issue when try to Alter user define table type structure TIP #108

  I hope all of you aware of  User define table type (a table value parameter) which we discussed earlier in TIP #57. Now recently one interesting incident happened. We are using a user define table type in few stored procedure and due to some business requirement change we need to change /update data type …

A simple way for consistency TIP #106

  Whenever we develop application of maintain application we define sets of rules or policies  like naming convention , data type, database & SQL SERVER properties (like which property should be unable or disable)  but the problem is to cross check or to enforce these properties is very tedious. To enforce the policies SQL SERVER …

How to send E-mail/E-mail with Attachments in SQL Server TIP #97

  In last post, TIP#96 We have configured Database E-mail. Now in this post we will see how to send mail in SQL SERVER. Sometimes we need to send mail for different requirements like 1) Notification mails like  data inserted /updated/deleted successfully 2)Send data reports like no of amount earned, failed transaction  etc. for this …

How to resolve Space issue in SQL server 2005 TIP #93

Hello friends,Many times we face space issues with our database. To resolve this problem SQL Server 2005 provided one more solution which is VARDECIMAL feature. ** VARDECIMAL feature exist in SQL SERVER’s Developer & Enterprise edition. ** This feature is not available in SQL Server 2005’s Standard edition. I hope by the name it is …

Kill–use this weapon carefully in SQL SERVER . TIP #90

When we heard “Kill” then first impression of this word is very bad. We always scare with this word. In real world we never want this action  from anyone but in SQL Server case it is very helpful and help us many times. This feature we can use but very carefully. It is something like …

Secure your password with HashBytes TIP #89

Dear Friends, In my last article (TIP 87) I wrote about PWDENCRYPT.  I forgot to write few details but thanks to all my talented friends & blog readers who guided me by providing there feedback on post. I respect their inputs and always interested to get more inputs. Thanks to all of you. Now I …

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 …