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