Power BI – Checking Query Folding With View Native Query
A really great feature that was silently added into June update of the Power BI Desktop is a feature called...
2016-07-03
1,094 reads
How to retrieve Cell Properties from a SSAS MDX query using SSIS
Scenario
This is a short article where I want to share something I discovered recently. I worked on an SSIS package...
2016-07-14 (first published: 2016-07-02)
1,965 reads
Security VC Webinar: TLS 1.2 and SQL Server
The PASS Security virtual chapter hosted a great webinar on Thursday. Amit Banerjee from Microsoft’s SQL Server Tiger Team (b|t)...
2016-07-02
892 reads
Possible Infinite Recompile Was Detected for SQLHANDLE
On one of my SQL Server instances, I see a lot of these infinite recompile messages in the SQL log....
2016-07-01
2,293 reads
Long Term Pebble Classic Review
I got a Pebble Classic watch for Christmas a few years ago, in Dec 2014 to be clear. That’s (as...
2016-07-01
540 reads
June 2016 Release of Power BI Desktop is Here!
Last night at approximately 9:28 PM EST the June 2016 release of Power BI Desktop dropped, which you can download...
2016-07-01
699 reads
Glasswire: (Giveaway Included) Networking Monitoring even a caveman could use
Giveaway details at the bottom for those interested
Dealing with development & sql servers, I like to know what type of network...
2016-07-01
1,472 reads
Power BI Row Level Security
In the June update of the Power BI Desktop there were some really cool features that were added. I’d encourage...
2016-07-01
1,220 reads
I am a Microsoft Data Platform MVP
My First Microsoft SQL Server MVP Award
Today, I have achieved an SQL Someday moment. I am excited to share some exciting...
2016-07-01
594 reads
I’m a Data Platform MVP for the third year in a row
I’m extremely honored to be named Microsoft Data Platform MVP for the third year in a row! I thank the...
2016-07-01
302 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