PSConfAsia 2016
I have just got back to the UK from Singapore following the amazing PSConfAsia conference. I must say that Matt,...
2016-10-24
534 reads
A Sub-Query Does Not Hurt Performance
The things you read on the internet, for example, “don’t use a sub-query because that hurts performance.”
Truly?
Where do people get...
2016-10-24
1,532 reads
Power BI Custom Visuals Class (Module 22 – Force-Directed Graph)
In this module you will learn how to use the Force-Directed Graph Power BI Custom Visual. The Force-Directed Graph allows...
2016-10-24
871 reads
Monday Night Networking Dinner Tonight
If you are attending the PASS Summit, or even in the Seattle area, we have a SQL Server pro networking...
2016-10-24
488 reads
Synchronous vs Asynchronous
You’ll hear these terms thrown around in programming all the time, but what do they mean and why do we...
2016-10-24
787 reads
Reading a SharePoint 2007 List from SSIS 2016
It's been a while, but since I now get to play with SQL 2016 full time, I have new things to talk about! One of major difficulties that any technology...
2016-10-24
49 reads
Reading a SharePoint 2007 List from SSIS 2016
It's been a while, but since I now get to play with SQL 2016 full time, I have new things...
2016-10-24
744 reads
Seattle SQL Pro Workshop 2016
Free workshop on SQL Server leading up to Summit 2016 that will provide attendees an alternate means to increase affordable learning opportunities during the week.
Related Posts:
Seattle SQL Pro Workshop...
2016-10-24
9 reads
Seattle SQL Pro Workshop 2016
Seattle SQL Pro Workshop 2016
You may be aware of an event that some friends and I are putting together during...
2016-10-24
555 reads
Query Store – Part 2 - Configuration Settings
Introduction to Query Store covered here.
Now for the second part on “How to Configure?”
Query Store is configured at the...
2016-10-24
988 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