T-SQL Tuesday #99 – Door #1
This months T-SQL Tuesday is hosted by Aaron Bertrand and the topic is Dealer’s Choice. Aaron gives us the choice...
2018-02-13
506 reads
This months T-SQL Tuesday is hosted by Aaron Bertrand and the topic is Dealer’s Choice. Aaron gives us the choice...
2018-02-13
506 reads
This months T-SQL Tuesday is hosted by Aaron Bertrand and the topic is Dealer’s Choice. Aaron gives us the choice...
2018-02-13
330 reads
All of the materials for my Biml session for DataMinds.be can be downloaded from Github:
the slidedeck (it’s only 12MB :))a...
2018-01-25
347 reads
First blog post of the year and I’d like to take the opportunity to wish everyone the best, professionally and...
2018-01-08
360 reads
After years of having to deal with Connect – the feedback platform of Microsoft – it is announced a successor has been...
2017-12-18
1,151 reads
After years of waiting, a book about Biml has been published! It’s conveniently titled “The Biml Book” (subtitled Business Intelligence and...
2017-12-04
885 reads
In October 2017, I completed the capstone project of the Microsoft Professional Program for Data Science. I’ve blogged about this...
2017-12-01 (first published: 2017-11-21)
3,155 reads
I’ve blogged a while back on how SSIS 2017 was finally here. Not much has changed; there is still no...
2017-11-30
1,816 reads
For some reason I attract all kinds of misery when working with Master Data Services. Today I was trying to...
2017-11-15
2,796 reads
I have a new installation of SQL Server 2017, along with an instance of Analysis Services Tabular 2017. I tried...
2017-10-30
1,524 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