I've more than 5 years of experiance as a SQL/BI developer. I worked in SQL server 2005/ 2008/ 2008R2 and SQL Server 2012. Currently Working for QSI Healthcare (NextGen). Active Memeber of SQLBangalore and BDotNet user groups.
|
Encryption is one of the most secure way to protect your confidential data like Social Security Number, Date Of Birth , Patient clinical information etc. We need to encrypt certain data to meet the business requirements and sometime to meet certain compliance. Here we’ll see how can we encrypt ...
|
|
Index is one of most widely discussed topic among developers and DBAs. During query optimization Index is one of the important aspects. I came across multiple instances where Developer/ DBA creates Index but they are not sure whether that index is used by the optimizer or not. Also I received ...
|
|
LAG: Using this function we can fetch the nth row before (Lag) the Current row without using self-join. It is useful when we need to compare the current row values with values in a previous row. Syntax: LAG (scalar_expression [,offset] [,default]) OVER ( [ partition_by_clause ] ...
|
|
Wish you a very Happy New Year 2013. Today is a special day for me to celebrate the New Year because today my blog post turned 1 year old. I can’t believe that I have been blogging for a year now. This blog was just created with an intension to share what I learned during [...]
|
|
Does order of Column in where clause matters? Before you answer to this question I recommend all to read the blog post SQLAuthority. Whenever I have any doubt, I always play around with it to clarify my doubt. While doing experiment with index operation, I learnt something and here I’m ...
|