Power BI Custom Visuals Contest Round-up
It's really exciting to see the first round of entries into the Power BI Best Visuals Contest, which has been...
2015-09-22
850 reads
Costumes at the PASS Summit
tl,dr; We’re raising money for Doctors without Borders. Donate and a few of us will dress up at the Summit....
2015-09-22
685 reads
Repairing a replication subscriber
It’s a question which has come up a couple of times. If a subscriber of a transactional replication publication becomes...
2015-09-22
1,141 reads
Heading To PASS Summit 2015 – Now What?
You’ve heard about it for some time now, and you finally got the gumption to ask your boss if the...
2015-09-22
331 reads
Heading To PASS Summit 2015 – Now What?
You’ve heard about it for some time now, and you finally got the gumption to ask your boss if the...
2015-09-22
545 reads
Comparison Predicates and Event Data
Predicates are a significant component within the Extended Events Engine. This article discusses one of the pieces of the puzzle of predicates - comparison operators - also known as...
2015-09-22
29 reads
Comparison Predicates and Event Data
In the previous installment, I began covering the topic of predicates. In that article I demonstrated that there are multiple types of...
2015-09-22
842 reads
Finding Next Business Day in T-SQL
Let’s say you have a table that records transactions along with the date of when the transaction took place. Wait,...
2015-09-22
5,219 reads
Most Read: My Top 5 SQL Server Articles and Blogs
There has been some really useful blogs and articles posted over the last week or so, this is my top...
2015-09-22
532 reads
Encrypting Connections To SQL Server Using Certificates
Encrypting Connections To SQL Server Using Certificates In this post we’re going to cover configuring a connection string in .NET applications for encrypting connections to SQL Server using certificates....
2015-09-22
18 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