I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to...
2019-07-02 (first published: 2019-06-18)
633 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2019-07-01 (first published: 2019-06-18)
1,627 reads
Let’s use the Azure portal to build a globally distributed Cosmos DB. Before doing this, why would you ? what are the benefits? Regional based. By this I mean...
2019-06-18
66 reads
Watch this week’s episode on YouTube. A long time ago I built an application that captured user input. One feature of the application was to compare the user’s input...
2019-07-03 (first published: 2019-06-18)
1,088 reads
Watch this week's video on YouTube
A long time ago I built an application that captured user input. One feature of the application was to compare the user's input against...
2019-06-18
44 reads
Watch this week's video on YouTube
A long time ago I built an application that captured user input. One feature of the application was to compare the user's input against...
2019-06-18
36 reads
I’m trying Trello this year to manage both SQLSaturday and our other events. Part of that is giving the whole team visibility of the work that remains to be...
2019-06-18
84 reads
Not really, but sort of. The beauty of containers, at least in a dev/test environment, is the ability to spin them up while you need them and then throw...
2019-07-04 (first published: 2019-06-17)
554 reads
Bump Nuspec Version
Bumping the version of the nuspec file requires a little tweaking and I got some help from the slack powershell community to ensure I handled the xml...
2019-06-17
89 reads
If you are being serious in your role, then the amount of times you grant permissions to the public role should either be a) never, b) when you want...
2019-06-17
16 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