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
Mar14

SQL SERVER – SCRIPT – SQL Listening on Dynamic Port?

Pinal Dave
SQL Tips and Tricks
SQL Server Security
2 Comments

How do you know if SQL Server is listening on a fixed or dynamic port? Here is a script that reads the TcpDynamicPorts registry value for your instance.

Continue Reading
Mar13

SQL SERVER – Interesting Function AGENT_DATETIME

Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function
16 Comments

AGENT_DATETIME in msdb converts integer date and time values in YYYYMMDD and HHMMSS format into a datetime. Here is how it works, with examples.

Continue Reading
Mar12

SQL SERVER – The Basics of the File System Task, Part 1 – Notes from the Field #071

Pinal Dave
SQL Tips and Tricks
Notes from the Field, SSIS
8 Comments

Andy Leonard explains the basics of the SSIS File System Task, a handy tool when loading data to and from flat files. This is part 1 of the series.

Continue Reading
Mar11

SQL SERVER – Error – Msg 6401, Level 16: Cannot roll back Transaction

Pinal Dave
SQL Tips and Tricks
SQL Error Messages
6 Comments

Is there such a thing as nested transactions in SQL Server? A simple demo shows why rolling back a named inner transaction fails with Msg 6401.

Continue Reading
Mar10

SQL SERVER – FIX – A connection cannot be made to redirector. Ensure that ‘SQL Browser’ service is running. (Microsoft.AnalysisServices.AdomdClient)

Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Error Messages, SQL Server
52 Comments

I opened SQL Server Management Studio and instead of a database engine. Below is the error which I received for SQL Browser:

Continue Reading
Mar9

Add a User Across Databases: A Tested Script With Cleanup

Pinal Dave
SQL Tips and Tricks
Dynamic SQL, SQL Login, SQL Scripts, SQL Server Security
9 Comments

To add a user across databases you need one login and, in every chosen database, a user and a role. This post gives a tested script that does it, checks it and removes it again on SQL Server 2025. It also answers the model database question and shows the server-level shortcut.

Continue Reading
Mar8

Interview Question of the Week #010 – What is the Difference Between Primary Key Constraints and Unique Key Constraints?

Pinal Dave
SQL Interview Questions and Answers
1 Comment

Compare primary keys and unique key constraints in SQL Server, including NULL rules, foreign keys, and filtered unique indexes.

Continue Reading
Previous 1 … 386 387 388 389 390 391 392 … 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