Feb 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
Aug24

SQL SERVER – Fix @@ServerName Property Value When Incorrect

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages, SQL Function
16 Comments
Our software systems are funny and sometimes give us strange values. I don’t quite venture out trying to fiddle around with system level properties on my servers, but having said that, this query had come from one of my colleagues who was working on his SQL Server instance and he…
Read More
Aug23

Interview Question of the Week #033 – How to Invalidate Procedure Cache of SQL Server?

Pinal Dave
SQL Interview Questions and Answers
SQL Server, SQL Server DBCC, SQL Stored Procedure
2 Comments

Question: How to Invalidate Procedure Cache in SQL Server?

Read More
Aug22

SQL Authority News – 100 Million Views and Onwards

Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks
SQL Milestone
15 Comments
I will always remember August 20, 2015 as a landmark milestone for SQLAuthority.com. On August 20th, this blog crossed 100 Million Views. When I started this journey on November 1, 2006, I had no idea that there will be over 100 Million Views on this blog. I am indeed very proud…
Read More
Aug21

SQL SERVER – DBCC CHECKDB errors – Msg 2520 during executions

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages
No Comments
Some of the simplest recommendations can lead you to some bizarre output that we never anticipated. I always recommend running DBCC CHECKDB on mission critical databases because we need to be 200% sure that the database disk system is healthy from time to time. During one of my sessions, I…
Read More
Aug20

SQL SERVER – Rewriting Database History – Notes from the Field #094

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Notes from the Field
1 Comment
[Note from Pinal]: This is a 94th episode of Notes from the Field series. When I read the title of this article – I was extremely intrigued with it – Rewriting Database History! When I was a kid, history was my favorite subject and till today when I have to deal…
Read More
Aug19

SQL SERVER – Login failed for user . Reason: Token-based server access validation failed

Pinal Dave
SQL
SQL Error Messages, SQL Login, SQL Scripts, SQL Server
34 Comments

This is one of the most common error searched on my blog search https://blog.sqlauthority.com/search-sqlauthority/ and lately I realized that I have not written any blog about the cause of such error and fixing that. Let us learn about how to fix the error login failed.

Read More
Aug18

SQL SERVER – How to Migrate Existing Database to Contained Databases

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts
1 Comment
Most of the queries that land into my inbox are based on something I have already written or something people want to explore more on. When it comes to learning and exploring the skills, there is no better way compared to people asking me some tough questions. This blog is…
Read More
Previous 1 … 345 346 347 348 349 350 351 … 829 Next
SQLAuthority News - Presenting Two Session at TechEd India 2013 on March 18-19, 2013 at Bangalore DSC03600

SQL SERVER – Weekly Series – Memory Lane – #019

SQLAuthority News – SQL Server Data Tools – Business Intelligence for Visual Studio 2012 – SQL Server 2012 Data-Tier Application Framework

SQLAuthority News - Presenting Two Session at TechEd India 2013 on March 18-19, 2013 at Bangalore columnorder

SQL SERVER – How to Add Column at Specific Location in Table

SQL SERVER – Avoid Using Function in WHERE Clause – Scan to Seek

SQL SERVER – Shortcut to SELECT Single Row from Table – SQL in Sixty Seconds #046 – Video

SQLAuthority News – Truly Amazing Experience at Pluralsight Author Summit February 2013

SQLAuthority News – Presenting Two Session at TechEd India 2013 on March 18-19, 2013 at Bangalore

Previous 1 … 345 346 347 348 349 350 351 … 829 Next

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 104 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.


Comprehensive Database Performance Health Check

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.


SQL Server Performance Tuning Practical Workshop

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.


  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com