Several months ago, I discussed my customer’s intention to enable trace flag 3625. Since that time, we have observed an intriguing phenomenon when encountering a login failure. To demonstrate...
2024-12-13 (first published: 2024-12-10)
540 reads
SQL Server has evolved a great deal since I first started working with SQL Server 6.5 in 1998. Unfortunately I continually come across newer systems that are configured with...
2024-12-10
101 reads
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether you're in data analysis, data science, or any field that uses data. Trust me, it's...
2024-12-10
279 reads
The post How to Build Data Management for Unstructured Data appeared first on Joyful Craftsmen.
2024-12-16 (first published: 2024-12-10)
458 reads
Brent Ozar is a very successful DBA/consultant/speaker/business owner in the data platform space. Many of you have likely seen him speak, read his blog, used his sp_Blitz script, or...
2024-12-20 (first published: 2024-12-09)
640 reads
One of the things that I think is neat is that Redgate Monitor helps you track patching on your systems. This is something that has been challenging in every...
2024-12-16 (first published: 2024-12-09)
288 reads
I had been meaning to post this, so as I finished a piece that referenced this, I decided to post the picture. This was from Small Data SF, where...
2024-12-06
48 reads
fardle-din – n. a long-overdue argument that shakes up a relationship, burning wildly through your issues like a forest fire, which clears out your dry and hollow grievances and...
2024-12-06
43 reads
The post Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch appeared first on Joyful Craftsmen.
2024-12-11 (first published: 2024-12-05)
1,072 reads
I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter asked about the difference between Min() and First_value. This post looks at a few cases....
2024-12-13 (first published: 2024-12-04)
723 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