Database

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 …

Proper Aliasing will help you somewhere TIP#104

Recently, When we were delivering session on “SQL SERVER” one of the persons asked why we require Aliasing so I thought this might be question in everyone’s mind. So lets start with couple of well know statements then we will see the actual problem where we need it explicitly. There are two type of aliasing …

A myth about view TIP #102

  I don’t know why every interviewer’s favorite question “Can we insert record using View ?” If you say Yes/No the interviewer will roaming around like so Can you update record using View?  or Can you delete record using view ? I  hope everyone who is reading this article will be aware of what is …

Find all the dates in a date range ? TIP #100

  It’s almost one month that I didn’t write anything on the blog due to some personal reason. I am really sorry for that. Now , Lets talk about the scenario sometimes we need to generate a report of total sales in particular date range but the condition is you need to show all the …

How to hide my SQL Server instance in network ? TIP #99

  In TIP #70  we saw how to find all the running SQL SERVER instance in a network or a machine. to revise see below image. This tip is just opposite to tip #70 you don’t want that your co-worker see your SQL Server instance running on your machine machine. (There are several reason behind …

I am not able to access my SQL server instance on another computer tip #98

  On last Friday , one of my colleagues had some issue related to accessing of SQL Server instance of database server machine in the office through his machine. I think this is generalized problem and might be faced by many of us. So to begin with  default port of SQL SERVER is 1433 , …