Multi-tenant databases in the cloud
For companies that sell an on-prem software solution and are looking to move that solution to the cloud, a challenge...
2016-07-20
1,185 reads
The new SQL Server Management Studio
Ok, so this is old news I know, but I’ve had a busy couple of months and am only getting...
2016-07-20
1,387 reads
Want to be able to read your database between restores?
When restoring a database there are times when it would nice to restore a bit, check what’s been restored so...
2016-07-20
779 reads
Day 1: Agile Fundamentals: Scrum, Kanban, Lean and XP
It's week 3 of my jammed packed training schedule this July. This week I'm producing course 918 Agile Fundamentals: Scrum,...
2016-07-20
673 reads
SSRS 2016 Book Nearly Done… My Brain is now Jell-O
(first excerpt from the upcoming book) “Professional SQL Server 2016 Reporting Services and Mobile Reports” from Wrox Press is content...
2016-07-20
520 reads
Extended Event Help Queries
When working with Extended Events, there are times when a little more information is, well, helpful. You know you want to use extended events to try and monitor...
2016-07-19
12 reads
Extended Event Help Queries
Enjoy this article re-publication from my original work at SQL Solutions Group.
When working with Extended Events, there are times when...
2016-07-19
671 reads
SQL – MultiServer SQL Inventory – PowerShell
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...
2016-07-19
762 reads
Adding the ReadyRoll Extension in VSTS
As I’m doing a little development with ReadyRoll, I’m documenting some of the things I learn about the product.
A few...
2016-07-19
704 reads
T-SQL Tuesday #080–Round Up
The roundup is finally here, and cheers to all of you who participated. We had a great turnout this month...
2016-07-19
360 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