On January 9 I have done an online presentation about Exploring PostgreSQL for the SQL Server Developers and DBAs for the Cloud Data Driven User Group. You can find the...
2025-01-29 (first published: 2025-01-20)
429 reads
I wanted to experiment a bit with an LLM and training it, so I decided to try a few things. I looked at a few tutorials (see the references...
2025-01-29 (first published: 2025-01-20)
889 reads
Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest in flip-flops. But guess what? You absolutely can become an SQL whiz without sacrificing your...
2025-01-19
261 reads
Microsoft announced on November 2024 a preview for SQL Server 2025 another major release /revolution from Microsoft SQL Server prospect, including – AI Buildin’, as AI plays an important...
2025-01-19
138 reads
How to apologize: quickly, specifically, sincerely. Don’t ruin an apology with an excuse – from Excellent Advice for Living This is great advice. I remember myself often saying “I’m...
2025-01-17
25 reads
Try this step-by-step guide to build and deploy a scalable serverless app that’s accessible through a RESTful API.Developers charged with building modern, scalable applications often face the burden of having...
2025-01-17
45 reads
2025-01-16
11 reads
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World Exercises for All Levels. It covers subqueries – a must-have tool for any SQL pro....
2025-01-16
37 reads
The more I work with the Data API Builder (DAB), the more I lean towards GraphQL instead of REST. Rest isn’t bad, but it’s tough. This is part of...
2025-01-27 (first published: 2025-01-15)
388 reads
A full transaction log can occur for a number of reasons. Typically it is due to the log not being truncated with regular transaction log backups, or something else...
2025-01-15
60 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...
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...
Comments posted to this topic are about the item The Costs of Multiple Platforms
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