Layer a database into a SQL Server container
In my previous post on running SQL Server in a container I showed how you could use the Spoon (https://spoon.net)...
2015-07-08
41 reads
Layer a database into a SQL Server container
In my previous post on running SQL Server in a container I showed how you could use the Spoon (https://spoon.net) products to start an instance of SQL Server without...
2015-07-08
12 reads
Hello world!
Hi there!
Although this looks like my first blog post, it actually isn’t. This is the new place for my blog,...
2015-07-08
380 reads
Integrating Other Data Mining Tools with SQL Server, Part 2.2: Minitab vs. SSDM and Reporting Services
By Steve Bolton
…………Professional statistical software like Minitab can fill some important gaps in SQL Server’s functionality, as I addressed in...
2015-07-08
1,803 reads
Database Settings Changes – Red Handed
One of my pet-peeves (and consequently frequent topic of discussion) is finding database settings (or any setting that has changed) without knowing about it. Worse yet is finding that...
2015-07-08
20 reads
Database Settings Changes – Red Handed
One of my pet-peeves (and consequently frequent topic of discussion) is finding database settings (or any setting that has changed)...
2015-07-08
638 reads
Thoughts on the PASS BAC
I recently read PASS and Business Analytics: A Winning Combination on the PASS blog and it reminded me that I’ve been...
2015-07-08
600 reads
Get a comma separated list
I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few...
2015-07-08
3,906 reads
What is the database property “Compatibility Level”
What is the database property Compatibility Level? I don’t get asked to write about specific subjects very often but in...
2015-07-08
676 reads
AdventureworksCI Step 3 Handling data with SSDT
This is part of a series on how to take the Adventureworks database and bring it in line with modern...
2015-07-07
740 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