Blog Home Page - Page 515 of 829 - SQL Authority with Pinal Dave

Jul29

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…

Jul28

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

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…

Jul27

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

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…

Jul26

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

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…

Jul25

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

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…

Jul24

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

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…

Jul23

SQL SERVER – Observation of Top with Index and Order of Resultset

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index

SQL Server has lots of things to learn and share. It is amazing to see how people evaluate and understand different techniques and styles differently when implementing. There are three different instances where I have come across a situation where I felt that proper understanding is important and something which looks…

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 100 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.

Feb 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

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

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

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

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

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

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

SQL SERVER – Observation of Top with Index and Order of Resultset

SQL SERVER – How to Change SQL Server Collation on Microsoft Azure VM (IaaS)

SQL SERVER – What is DBCC TRACEON and DBCC TRACEOFF messages in ERRORLOG?

SQL SERVER – Huge Transaction Log in Snapshot Replication!

SQL SERVER – Identifying Database Default Locations for Data and Logs

SQL SERVER – InMemory OLTP Migration Assistant Powershell Script

What is ACID Property in Database? – Interview Question of the Week #066

Podcast – Conversation With Author – Serving a Benevolent Master