SQLAuthority News – Presenting Two Session at TechEd India 2013 on March 18-19, 2013 at Bangalore
SQLAuthority News – Truly Amazing Experience at Pluralsight Author Summit February 2013
SQL SERVER – Shortcut to SELECT Single Row from Table – SQL in Sixty Seconds #046 – Video
SQL SERVER – Avoid Using Function in WHERE Clause – Scan to Seek
SQL SERVER – How to Add Column at Specific Location in Table
Recently I noticed a very interesting question on Stackoverflow. A user wanted to add a particular column between two of the rows. He had an experience with MySQL so he was attempting following syntax. Following syntax will throw an error. Let us explore more about how to add column at specific locations in the table.
SQLAuthority News – SQL Server Data Tools – Business Intelligence for Visual Studio 2012 – SQL Server 2012 Data-Tier Application Framework
SQL SERVER – Weekly Series – Memory Lane – #019
SQL SERVER – Tricky Question – What is the Default Size of the Database
SQL SERVER – Check If String is a Palindrome in Using T-SQL Script – Reverse Function
One of my friends who works in a big MNC recently asked me that if there is any way to check if the String is Palindrome or not. The palindrome is a word, phrase, or sequence that reads the same backward as forward. For example A man, a plan, a canal – Panama! is palindrome so as Was it a car or a cat I saw?
My first reaction was to him was why does this kind of functionality. His answer was they have requirement in their business application where they are building captcha and they may display the image in mirror image as well as a part of challenge code and he can’t have any word which is palindrome as an option. For this he wanted to write a script which will go letter by letter and match them. If they are same, he will not use the word for captcha.



