Deploying Row Level Security with SQL Compare
Row Level Security (RLS) is a great new feature in SQL Server 2016. It’s been in Azure SQL Databases for...
2016-07-29 (first published: 2016-07-25)
1,299 reads
Monitor Query Performance
Blog post #7 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel. Read about it here.
Sooner or later when you’re working...
2016-07-28 (first published: 2016-07-25)
2,630 reads
Blogger Questions: What should I blog about?
Over the last four years I’ve blogged almost 400 times. It’s become a refuge, a resource, a source of pride,...
2016-07-25
436 reads
Fourth Week in July
This is the fourth week of four of my July training programming and this week we have two courses that...
2016-07-25
342 reads
Speaking at SQL Server Geeks Annual Summit 2016
I am very happy and proud to share the news that I will be speaking in SQL Server Geeks Annual...
2016-07-25
423 reads
Learn About SQL Server Master Data Services 2016
SQL Server 2016 comes up with the new release of Master Data Services (MDS). In it, some new features have...
2016-07-28 (first published: 2016-07-25)
2,476 reads
Happy Birthday Power BI!
Today marks one years since Power BI was officially released. It’s been an amazing ride and I’d like to thank...
2016-07-24
500 reads
Descriptive Statistics with SQL and R – II
In the previous post I looked into some very basic and common measures of descriptive statistics – mean, median and mode,...
2016-07-24
632 reads
CISL 1.3.0 is released
I am extremely proud to share with everyone the news that the long-awaited and quite overdue release of the CISL...
2016-07-24
448 reads
Happy Birthday Power BI
Well today marks the one year anniversary since the initial release of Power BI. We all have watched this product...
2016-07-24
828 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