Implementing Fuzzy Sets in SQL Server, Part 2: Measuring Imprecision with Fuzzy Complements
By Steve Bolton
…………Taking the dive into fuzzy sets immediately elicits the obvious question: just how fuzzy is the data we’re...
2016-08-02
862 reads
SQL Server Indexing Book Giveaway – Part 7
More of the same with the next Expert Performance Indexing for SQL Server book giveaway. So far, I’ve sent out six copies of the book based on comments from the past six (1, 2,...
2016-08-01
28 reads
SQL Server Indexing Book Giveaway – Part 7
More of the same with the next Expert Performance Indexing for SQL Server book giveaway. So far, I’ve sent out six copies of...
2016-08-01
817 reads
Power BI Custom Visuals Class (Module 10 – Card with States)
In this module you will learn how to use the Card with States Power BI Custom Visual. The Card with...
2016-08-01
1,219 reads
Monday Morning SQL Break – August 1, 2016
It’s Monday and time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to...
2016-08-01
12 reads
Monday Morning SQL Break – August 1, 2016
It’s Monday and time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me...
2016-08-01
883 reads
PolyBase Is A Picky Eater – Remove Carriage Returns Before Ingesting Text
Update: As Gerhard points out in the comments, switching to ORC files solves this issue nicely. It’s not human readable,...
2016-08-09 (first published: 2016-08-01)
2,155 reads
There Is No Difference Between Table Variables, Temporary Tables and Common Table Expressions
I actually saw the above statement posted online. The person making the claim further stated that choosing between these three constructs was “personal...
2016-08-01
1,407 reads
Feasel’s Grand Analysis of the PASS 600 mile radius rule
UPDATE: Last week, PASS announced an update to the 600 mile radius announcement: “…we will be piloting the 600-mile driving radius...
2016-08-10 (first published: 2016-08-01)
1,199 reads
Using impersonation to allow a task without granting the required permission.
I use impersonation on a regular basis for a number of different tasks. This one is pretty basic but can...
2016-08-03 (first published: 2016-08-01)
2,035 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
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