Where is my TNSPING?
I’m a big fan of the “instantclient” solution to Oracle connectivity. No more calls to “runInstaller”, no registry files on Windows, it is just download-unzip-go. That makes installation a...
2026-03-05
50 reads
Connor McDonald
Generate INSERTs the new 26ai way
Six years ago(!) I did an Office Hours session where I demonstrated a little routine that would let you generate more efficient INSERTs by converting a standard INSERT-VALUES into...
2026-03-02
41 reads
INSERT-VALUES – Bigger is NOT always Better!
One of the super cool features in 26ai is the ability to extend the VALUES clause in your INSERT statements to allow multiple rows per execution. If you’re unfamiliar...
2026-02-27
53 reads
SQL Macros make so many things easier
Addenda Feb 20: I had one colleague point out a mistake, then another colleague point out something else, then I thought about it a little and found other problems…sigh. ...
2026-02-19
36 reads
26ai Quick Tip for Database Links
It seems an odd thing that so many facilities on the cloud environment take advantage of the concept of stored database credentials when it comes to authenticating/authorising access to...
2026-01-29
44 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers