SQL Archives - Page 252 of 519 - SQL Authority with Pinal Dave

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

July 30, 2012

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…