Architecture Reasons for Putting BLOBs in the Database
I was participating in a Twitter Chat looking at what suggestions and recommendations for developer on how to make the...
2013-10-24
5,044 reads
I was participating in a Twitter Chat looking at what suggestions and recommendations for developer on how to make the...
2013-10-24
5,044 reads
Carolina Technology Conference:
To start things off, I'll be speaking in the morning at the Carolina Technology Conference. I have a...
2013-09-30
2,816 reads
The SQL Server Premier Field Engineer blog has a post about an issue with installing SQL Server 2008 on a...
2013-09-23
2,071 reads
There are some very good names up for this year's PASS Board of Directors. However, I wanted to write a...
2013-09-23
2,386 reads
The Dataloss list sent the following article through yesterday afternoon:
Obamacare Employee Accidentally Sends Out 2,400 Social Security Numbers
This is concerning,...
2013-09-17
2,227 reads
I've heard the argument, "I've got nothing to hide. If it helps them catch the next guy, I'm all for...
2013-09-17 (first published: 2013-09-11)
3,985 reads
Buck Woody (blog | twitter) is often seen as one of the wise men of the SQL Server community and with...
2013-09-13 (first published: 2013-09-10)
2,642 reads
Securosis has released a whitepaper on their research with regards to database denial-of-service attacks. This whitepaper is platform agnostic. It...
2013-09-11
2,041 reads
Here's a great example:
MS13-079 - Vulnerability in Active Directory Could Allow Denial of Service (2853587)
Basically, this patches a vulnerability where an...
2013-09-10
1,883 reads
Have you heard about Hadoop but don't know much about it? What about "big data?" Would you like an intro...
2013-09-09 (first published: 2013-09-03)
2,111 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