In the previous blogs we came across various encrypt functions like ENCRYPTBYKEY(),ENCRYPTBYASYMKEY(),ENCRYPTBYCERT().We also saw the corresponding decrypt functions likeDECRYPTBYKEY(),DECRYPTBYCERT(),DECRYPTBYASYMKEY(),DECRYPTBYCERT(),We shall...
2015-10-15
1,521 reads
Glad to share that I have been picked up to speak at Spanish SQLSaturday for the second time in a...
2015-10-14
403 reads
We elected new officers tonight for the Baton Rouge SQL Server User Group Official PASS Chapter, the second year in...
2015-10-14
488 reads
Best Tools for Taking Notes In Development
Developers have a lot to juggle. Do a few of these things sound familiar:
Juggle...
2015-10-14
650 reads
In case you missed it last week, there will be another SQL Saturday this weekend in Charlotte, NC. If you...
2015-10-14
525 reads
When you create a new SSDT project it is created (at the moment) as a SQL Server 2014 project which...
2015-10-14
386 reads
When you create a new SSDT project it is created (at the moment) as a SQL Server 2014 project which...
2015-10-14
45 reads
When you create a new SSDT project it is created (at the moment) as a SQL Server 2014 project which...
2015-10-14
75 reads
When you create a new SSDT project it is created (at the moment) as a SQL Server 2014 project which is annoying when you are on something else.
However, if...
2015-10-14
16 reads
------------ UPDATE: 2016-04-08 10:12 ------------
Been working through some issues with Clarify app on my personal computer, something I messed up. @trevordevore...
2015-10-14
280 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