I hardly get hard time to come up with the title of the blog post. This was one of the blog post even though simple, I believe I have not come up with appropriate title: Group by Rows and Columns using XML PATH – Efficient Concating Trick. Anyway, here is the question I received.
SQL SERVER – Identity Fields Review – The SQL Query Techniques Tutorial for SQL Server 2012
In this blog post we are going to learn about Identity Fields Review.
Why buy this Book: The beta of this book actually existed for a year and was tested and used in my classroom. Its purpose back then was to help the students do the steps individually that led to the skills where they could all pass the Microsoft test. It worked and then many went out for their SQL interview. They did good enough to get the job, but they told me about one or two questions they were not able to answer. A year of collecting this data and turning them into lessons doubled the size of this book of 300 pages to 600 pages. This book is designed to make the query question and query skills in the professional work must seem easier. Let us learn about Identity Fields Review.
SQLAuthority News – Presenting Two Technology Sessions at TechEd India 2013 – Today and Tomorrow
Every year I am looking forward to TechEd India as it presents a wonderful opportunity to meet community in first hand. Community is my passion and I love to get involved with it at every single opportunity it presents. This year once again I am presenting a technology session at TechEd India. I will be presenting two Technology Sessions on the following subject.
Here is something I promise – if you attend my session – when you walk out of my session you will immediate action items which you can use it for your production server and improve the performance of the database. Additionally, I will have some goodies with me for everyone. I will have a few of my books, free subscription access to Pluralsight’s library as well something totally interesting as a giveaway.
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.
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.
SQL SERVER – SSMS Does NOT Print NULL Values
Here is a very interesting question asked on the blog by Karthik. I really liked the question and I would like to discuss this here about SSMS doe snot Print NULL values.
SQL SERVER – Download Microsoft PowerPivot for Excel 2010 and PowerPivot in Excel 2013 Samples
Learning any technology is easy when we have good documentation and sample database to play along with. When I have to learn any new technology, my first action is to install the trial software and look for sample database next. Once I get sample database, I try to find a video tutorial about the technology and continue to learn onwards. Let’s see PowerPivot for Excel 2010 and PowerPivot in Excel 2013 Samples here.