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
21 reads
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
21 reads
It’s a day off for Redgate today. This is our annual wellbeing day, where everyone gets the day off. Well, not everyone, but anyone that has to work today...
2026-03-02
18 reads
Next Monday, March 9, 2026, my one-day live online training SQL Server 2025 Unleashed: AI, Performance & Beyond will take place! This hands-on training is designed to help DBAs,...
2026-03-02
37 reads
As someone who’s worked with data for over 20 years and with many cloud platforms, my main focus has always been on helping teams streamline their development process. A...
2026-03-06 (first published: 2026-03-02)
620 reads
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll see companies like OpenAI, Anthropic, Gemini, Lovable, and Poolside AI dominating the conversation. Different names,...
2026-03-03 (first published: 2026-03-02)
41 reads
it has been a year since i have not written much on the blog and i would like to start a “blog a day” series. i have been continuously...
2026-03-01
37 reads
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which makes you feel that much more rooted to the world, even if the roots belong...
2026-02-27
22 reads
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
29 reads
I have been active in the data community throughout my career. I have met people and made friends in the process. As I look back on it, I am...
2026-02-26
28 reads
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part of all the Versions!! 7 (70)– Foundation, OLAP Services, Query Analyzer 2000 (80) – SSAS,...
2026-02-27 (first published: 2026-02-26)
27 reads
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Telp/WA 62 8218200174 Setiabudi Atrium, Plaza Setiabudi, Jl. H. R. Rasuna Said No.Kave 62...
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers