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
Cardinal Rules cartoon by SQLAuthority. Three panel Halloween cartoon. Sam says nobody has opened this procedure since 2011. The red bird says it read the whole thing and the office lights flicker. The bird reports a comment saying do not fix, signed by the bird, yesterday.

AI Read the Procedure Nobody Dares to Touch

October 31, 2026
Pinal Dave
AI
AI, SQL Documentation, SQL Humor, SQL Stored Procedure

AI read the procedure that everybody walks past. Nine hundred lines, no comments, one very old warning at the top.

Read More
A smaller cream spool sits beside a fresh sage spool, sample binding and prepared tool case.

SQL SERVER – Microsoft Official Support End Dates for Different Versions

July 15, 2019
Pinal Dave
SQL Tips and Tricks
SQL Documentation, SQL Server

SQL Server Support end dates belong in upgrade planning before the deadline. My original post followed the July 2019 support transition.

Read More
A row of window shutters with most slats at one angle and two set differently, a hand resting on one

Listing Non-Default Server Settings From sys.configurations

April 30, 2019
Pinal Dave
SQL Tips and Tricks
DBA, SQL Documentation, SQL Server Configuration, SQL System Table

Inventory non-default server settings with a versioned baseline, compare configured and active values, and keep the review read-only.

Read More
Caption SQL Keyword Get-Instance.

SQL SERVER – Installation Failure – Specified Instance Via Transform is Already Installed. MSINEWINSTANCE Requires a New Instance that is not Installed

December 31, 2018
Pinal Dave
SQL Tips and Tricks
SQL Documentation, SQL Scripts, SQL Server, SQL Server Installation

A client’s second clustered SQL Server instance failed to install: Specified instance via transform is already installed. Here is what I found and the fix.

Read More
A small red flag marking one foxglove in a garden border with no fence around it

Tagging Personal Data Columns With ADD SENSITIVITY CLASSIFICATION

November 28, 2018
Pinal Dave
SQL Tips and Tricks
SQL Column, SQL Documentation, SQL Server, SQL Server Security

Add sensitivity classification to reviewed columns, inspect stored labels, and keep discovery separate from encryption and access controls.

Read More
SQL SERVER - You Are Not Logged on as the Database Owner or System Administrator

SQL SERVER – You Are Not Logged on as the Database Owner or System Administrator

November 2, 2018
Pinal Dave
SQL Tips and Tricks
SQL Documentation, SQL Error Messages, SQL Server, SQL Server Security

A developer creating a table in SSMS got a pop-up: You are not logged on as the database owner or system administrator. Here is what the message means.

Read More
Several boats connect to one mooring point while a separate line leads outward

How Many Foreign Key Can You Have on A Single Table? – Interview Question of the Week #096

November 6, 2016
Pinal Dave
SQL Interview Questions and Answers
SQL Constraint and Keys, SQL Documentation, SQL Server

How many foreign key references can you have on a single table? I said 253 at SQLPASS, but my answer was not complete. Here is the full answer.

Read More
1 2 3 4 … 6 Next
  • Books
  • Testimonials
  • Privacy Policy

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