Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Identity Fields Review – The SQL Query Techniques Tutorial for SQL Server 2012

Pinal Dave
SQL Tips and Tricks
Joes 2 Pros, SQL Identity, SQL Scripts, SQL Server

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.

Read More

SQLAuthority News – Presenting Two Technology Sessions at TechEd India 2013 – Today and Tomorrow

Pinal Dave
SQLAuthority News
SQL Index, SQL Server, TechEd

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.

Read More

SQL SERVER – Check If String is a Palindrome in Using T-SQL Script – Reverse Function

Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server, SQL String

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.

Read More

SQL SERVER – Download Microsoft PowerPivot for Excel 2010 and PowerPivot in Excel 2013 Samples

Pinal Dave
SQL
Excel, PowerPivot, SQL Download, SQL Server

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.

Read More

SQL SERVER – Beginning SQL 2012 – Basics of CONVERT FORMAT Function

Pinal Dave
SQL Tips and Tricks
Joes 2 Pros, SQL Function, SQL Scripts, SQL Server

From the September 17, 2011 blog post on the new SQL 2012 FORMAT function we learned how to format currency and time using different cultures. This is an improvement on what came before and also gives us new possibilities for getting date labels without needing to use DATEPART. In this post we will compare the FORMAT function to the previous techniques and also show you an easy way to grab the part of the date you need for reports. Let us learn about CONVERT FORMAT Function.

Read More