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
SQL SERVER - Fun Post - Connecting Same SQL Server using Different Methods

SQL SERVER – Fun Post – Connecting Same SQL Server using Different Methods

September 7, 2012
Pinal Dave
SQL Tips and Tricks

Five ways to connect to the same SQL Server on your local box: 127.0.0.1, a single dot, (local), localhost and the computer name. Can you name more?

Read More
Cannot connect to SQL Server.

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)

September 6, 2012
Pinal Dave
SQL Tips and Tricks
SQL Error Messages

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.

Read More
Gouache painting of beach pebbles in loose clusters, two similar round pebbles close together, one vermilion, and a jagged stone far away.

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

September 5, 2012
Pinal Dave
AI
AI, SQL Index, SQL Scripts

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.

Read More
SQL SERVER - Step by Step Guide to Beginning Data Quality Services in SQL Server 2012 - Introduction to DQS

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

September 4, 2012
Pinal Dave
SQL Tips and Tricks
Business Intelligence, Data Quality Services, Data Warehousing, SQL Server

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.

Read More
Two buildings joined by an overhead walkway whose middle section has been removed, seen against an overcast sky.

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

September 3, 2012
Pinal Dave
SQL Tips and Tricks
Data Quality Services, SQL Error Messages, SQL Scripts, SQL Server

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.

Read More
A plain balance scale with two small wooden blocks on a softly lit wooden worktable.

How to Evaluate a New Database Without Fooling Yourself

September 2, 2012
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

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

Read More
Book Signing Event

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

September 1, 2012
Pinal Dave
Personal
Memory Lane, SQL Book, SQL Wait Stats, SQLAuthority Book Review

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.

Read More
An empty picture hook on a wall with a faint clean rectangle where something used to hang.

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

August 31, 2012
Pinal Dave
SQL Tips and Tricks
SQL Error Messages

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.

Read More
Gouache painting of a cutaway building containing database storage and processing machinery

SQL Server Architecture Terminology: A Beginner’s Guide by Anil Kumar

August 30, 2012
Pinal Dave
SQL Tips and Tricks
SQL Data Storage, SQL Server, SQL Server Architecture, SQL Training

SQL Server architecture terminology is easier to follow when each term can be seen in a running instance. This guest introduction by Anil Kumar covers instances, storage, memory, the transaction log and SQLOS, with tested queries on SQL Server 2025.

Read More
Gouache painting of three streams of paper cards merging through wooden channels into an organized output tray.

Insert Multiple Rows in SQL Server: SQL in Sixty Seconds #024

August 29, 2012
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Scripts, SQL Table Operation, SQL Transactions

To insert multiple rows in SQL Server, use separate INSERT statements, UNION ALL or one VALUES list. The tests here compare all three on SQL Server 2025, including failures, the 1,000 row limit and the time for 1,000 rows.

Read More
Previous 1 … 366 367 368 369 370 371 372 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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