This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Sep6

SQL SERVER – FIX ERROR – Cannot connect to . Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452)

Pinal Dave
SQL Tips and Tricks
SQL Error Messages
42 Comments

Error 18452 said my login was from an untrusted domain while I connected from my own machine to 127.0.0.1. Here is the small change that caused it.

Continue Reading
Sep5

VECTOR_SEARCH in SQL Server 2025: Finding Similar Rows With a Vector Index

Pinal Dave
AI
AI, SQL Index, SQL Scripts
1 Comment

VECTOR_SEARCH returns the rows whose vectors sit closest to a vector you give it, and a vector index makes that search approximate and fast. This post builds a six-row test with hand-made numbers on SQL Server 2025, with no AI model, and lists the limits the test showed.

Continue Reading
Sep4

SQL SERVER – Step by Step Guide to Beginning Data Quality Services in SQL Server 2012 – Introduction to DQS

Pinal Dave
SQL Tips and Tricks
Business Intelligence, Data Quality Services, Data Warehousing, SQL Server
26 Comments

A step by step introduction to Data Quality Services in SQL Server 2012 for beginners: build a Knowledge Base from an Excel file and use it to spot bad data.

Continue Reading
Sep3

SQL SERVER – DQS Error – Cannot connect to server – A .NET Framework error occurred during execution

Pinal Dave
SQL Tips and Tricks
Data Quality Services, SQL Error Messages, SQL Scripts, SQL Server
7 Comments

Opening the DQS client, I hit a long .NET Framework error from SetDataQualitySessions and could not connect. Here is that DQS Error and how I worked through it.

Continue Reading
Sep2

How to Evaluate a New Database Without Fooling Yourself

Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server
1 Comment

Use realistic data and workload tests to evaluate a database, checking correctness, latency, recovery, compatibility, and the full operating cost.

Continue Reading
Sep1

Anniversary of SQL Wait Stats Book: Memories From the First Year

Pinal Dave
Personal
Memory Lane, SQL Book, SQL Wait Stats, SQLAuthority Book Review
5 Comments

A year ago I published my second book, SQL Wait Stats. On this first anniversary of SQL Wait Stats book, here are some memories from that journey: the blog series behind it, the work with my co-author, and why September 1st is a special day for me.

Continue Reading
Aug31

SQL SERVER – Error: Fix – Msg 208 – Invalid object name ‘dbo.backupset’ – Invalid object name ‘dbo.backupfile’

Pinal Dave
SQL Tips and Tricks
SQL Error Messages
64 Comments

Msg 208, Invalid object name ‘dbo.backupset’, but only in SSMS? A reader’s backup history query failed there while it worked in the app. Here is what was going on.

Continue Reading
Previous 1 … 524 525 526 527 528 529 530 … 847 Next

SQL Server slow? Let's fix it together in about four hours.

Pinal Dave

In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.

You keep every script, and the know-how to fix it yourself next time.

Want your whole team to learn it?

My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.

Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.


Who We Are

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

Pinal has authored 19 books and 125 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 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.


Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

  • Books
  • Testimonials
  • Privacy Policy

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