2025-08-05
1,832 reads
2025-08-05
1,832 reads
Every few weeks, headlines scream about how artificial intelligence is coming for our jobs. The narrative is often the same: white-collar professions are at risk, automation is taking over, and we’re all doomed to obsolescence.
2025-08-05
250 reads
As we continue to build more applications using AI embedded solutions, database professionals are increasingly being asked to support workloads that would have seemed outside their charter just a few years ago. One of the most significant shifts has been the rise of vector data (i.e. high-dimensional numerical representations of content like text, images, and […]
2025-07-26
638 reads
2025-07-24
496 reads
In a world of always-on learning and the relentless march of tech evolution, podcasts emerged as a quiet revolution in how I consume information. I’ve been part of several podcasts this year, including recording one earlier today with Ed Roske for the Oracle community. As a data professional and technical specialist, for me they’re more […]
2025-07-24
128 reads
2025-07-23
894 reads
Oracle treats most DDL as auto-committing, meaning once it executes, it's done. SQL Server, however, blurs that line in fascinating ways, allowing some DDL operations to be part of an explicit transaction.
2025-07-23
390 reads
2025-07-22
751 reads
The data professional’s world is changing and I know you hear this from me in editorials, blogs posts and social media, but it’s the truth. With the rise of Microsoft Fabric, we’re not just seeing another platform shift; we’re witnessing a redefinition of how data is valued, governed, and protected across the enterprise. Fabric isn’t […]
2025-07-22
269 reads
Working across Oracle, SQL Server, PostgreSQL, and MySQL, I've learned that the real challenge isn’t just knowing each platform, but understanding the subtle differences in terminology, syntax, and mindset, and staying open to learning on the fly every time I jump in. The “Sacred Six” are rules that I’ve learned to live by and accept. […]
2025-07-12
128 reads
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Comments posted to this topic are about the item Building a SQL Server Fleet...
Comments posted to this topic are about the item Smart AI Agents and Data...
Comments posted to this topic are about the item RegEx Functions IV
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', 'i') AND BusinessEntityID IN (7,8)See possible answers