How to Install Microsoft R Server for Windows
Microsoft R Server, or Revolution R Enterprise (RRE) as it is formally known, for now, is basically a platform for...
2016-02-11 (first published: 2016-02-02)
3,041 reads
On the addition of useless where clauses
I remember a forum thread from a while back. The question was on how to get rid of the index...
2016-02-10 (first published: 2016-02-02)
2,419 reads
Speaking at OPASS on February 25, 2016
Last month I visited MagicPASS, this month I’ll be at oPASS and presenting again on my pattern for automating database...
2016-02-02
557 reads
Pausing PASSWatch & What’s Next
I just posted Pausing PASSWatch on the PASSWatch blog, wrapping up a project that ran about 16 months. It’s hard...
2016-02-02
614 reads
SSC Question of the Day: DBCC Error 6
My latest question of the day on SQLServerCentral is DBCC Error 6. Text of the question below:
As the on-call DBA,...
2016-02-02
2,063 reads
Book Review – Expert Performance Indexing
A few weeks back, the folks at Apress Publishing sent me a copy of the book Expert Performance Indexing in...
2016-02-11 (first published: 2016-02-02)
2,082 reads
Azure SQL DB – technical deployment
Take a look this awesome document for the Azure SQL DB technical deployment with lot of the details that you need...
2016-02-02
526 reads
Should I use option(recompile)?
This will probably be a multiple stage discussion. The notes I’m providing today were sparked off of the content located...
2016-02-02
2,162 reads
Advent of Code – Day 2 – Using Cross apply
For this post i worked on second puzzle in the Adventofcode series. This wasn’t as challenging as the first one, but...
2016-02-02
317 reads
Excel Power Map vs. Power BI Globe Map visualization
[2016-02-02] PowerMap in Excel is a great tool with good design and comprehensive user experience. I’ve started using it about...
2016-02-09 (first published: 2016-02-02)
5,878 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