Text Mining Loch Ness Monster Sightings
Text Mining with RapidMiner for Loch Ness Monster Sightings
Text mining involves pulling root words from text in a system. In...
2016-02-11
501 reads
DocumentDB Tutorial 2 – Working with Documents
Join Eitan Blumin in the next video of his DocumentDB Tutorials. This time learn how to work with the documents...
2016-02-18 (first published: 2016-02-11)
2,089 reads
Moving to Open Live Writer
I’ve used Windows Live Writer for almost as long as I’ve been blogging (mid 2007 or so). It’s worked well...
2016-02-11
787 reads
SQL Server Security Principals Lightning Round Presentation
Thanks for attending tonight's joint meeting of the Baton Rouge .NET/SQL/PowerBI User Groups, which was sponsored by Idera!
I presented a...
2016-02-10
385 reads
Azure SQL Database monitoring
Even though an Azure SQL Database stores all data on the Azure cloud, it does not mean that your options for managing...
2016-02-10
761 reads
CROSS APPLY v InLine Functions
While working on the Advent of Code problems in SQL, I ran across something interesting. Day 4 involves hashing, which...
2016-02-10
2,169 reads
How Bad Are Your Indexes?
In my last post "Copying SSIS packages With DTUTIL" I described a "gotcha" where the dynamic management views (DMVs) had...
2016-02-10
3,125 reads
Leadership and the Data Professional
Many traits make up data professionals and the many who find themselves in leadership roles. The traits being shared in...
2016-02-17 (first published: 2016-02-10)
1,814 reads
Changing to simple recovery to clear the log.
Clearing out a full transaction log is a common problem. A quick search will find you dozens of forum entries...
2016-02-10
578 reads
View Getting Started with Power BI and Time Calculations with Dustin Ryan is Now Available!
Earlier today I had the pleasure of speaking with the PASS Business Intelligence Virtual Chapter on getting started with Power...
2016-02-09
923 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