All Articles - SQL Authority with Pinal Dave

SQL SERVER – 5 Videos from Joes 2 Pros Series Exam Prep Series 70-433 – SQL in Sixty Seconds

August 1, 2012

SQL, SQL Server, SQL Tips and Tricks, SQL Video

Joes 2 Pros SQL Server series is a five part series is written with keeping SQL Server Exam 70-433. It is written with the focus on beginners and who wants to build expertise for SQL Server programming and development from fundamental. Exam is major focus but this series goes beyond…

SQL SERVER – Follow up on Beginning NuoDB – Who will Benefit and How to Start – Part 2

August 1, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

NuoDB, SQL Documentation, SQL Download

Earlier I blogged about Beginning NuoDB – Who will Benefit and How to Start, I received a few follow up questions about it so I decided to write a short article as a follow up. One of the questions I received was why I started with this product. Well, the…

SQL SERVER – Beginning NuoDB – Who will Benefit and How to Start

July 31, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

NuoDB, SQL Documentation, SQL Download

I finally got some time to play around with the beta 7 release of NuoDB that I downloaded a few weeks ago. Personally I don’t think NuoDB yet gives downloaders enough information on how to get started so I decided to tackle that here myself. Before I get into the…

SQLAuthority News – A Year Older and 3 SQL Server Books and 3 Video Courses – 33

July 30, 2012

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Today is my birthday. I am 33 today. 33 is an interesting number. There are two 3’s in this number. Curiously, I looked it up in Wikipedia and found out that there is plenty of information about this number. Let me quote a few statements from Wikipedia here. “33 is the largest positive…

SQL SERVER – Services Pack 2 for SQL Server 2008 R2 – Microsoft SQL Server 2008 R2 Service Pack 2

July 29, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download, SQL Service Pack

Service packs are very critical and important. In the industry I have seen many people waiting for the first service pack to arrive before moving to opting the product. I often see it as a good practice because there are some unknown bugs or missed enhancements in original product which are…

SQL SERVER – Difference Between ORIGINAL_LOGIN() and SUSER_SNAME()

July 28, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

Today let us start today’s blog post with a simple start question which I was asked by reader of my latest book SQL Server Interview Questions and Answers. Indeed a good question warrants a good answer with a script associated with the same. Question: What is the difference between ORIGINAL_LOGIN() and…

SQL SERVER – Query to Get Unique Distinct Data Based on Condition – Eliminate Duplicate Data from Resultset

July 27, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Seems like in T-SQL world the issue with Duplicate Records never an old topic. Today lets quickly go over another question which made it to my mailbox 3 times this week. Question: How do I display only unique records from my table? The natural reaction will be to suggest DISTINCT…

SQL SERVER – Answer – How to Convert Hex to Decimal or INT

July 26, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

Has it ever happened to you that you say something but forget to follow up due to any reason? It usually does not happen to me as I try to remember everything in my task list but there is always an exception. Last year I asked a question regarding about…

SQL SERVER – How do I Record Video and Webcast – Milestone – 2200th Blog Post – SQL in Sixty Seconds #022 – Video

July 25, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio

Earlier I used to do Milestone blog posts where at the interval I used to celebrate achievements. However, as time passed the achievements changes their value and importance. We all grow more and more and our priorities are different. However, today I have come across a very interesting milestone! This…

SQLAuthority Guest Post – Lessons from Life and Work – Power in the Workplace – Srini Chandra (Author of 3 Lives, in search of bliss)

July 24, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQLAuthority Book Review

Power, Fear, and Vulnerability are all part of office politics. I often see the best developers loosing their focus and ability to write beautiful code when they let themselves involve with a power struggle. Power is the interesting factor which everybody want often, but when they have it they are…