Announcing Workshop for SQLSaturday Porto 2016
I am glad to share that finally today we have announced that a workshop for Sysadmins, DBAs & DevOps Engineers – called
SQL...
2016-06-27
470 reads
Perfectly Placed Parentheses
Like many other programming languages T-SQL uses parentheses () for a number of tasks. To help determine precedence, function calls etc....
2016-07-05 (first published: 2016-06-27)
2,911 reads
Retrieving the SQL Server License Key
Strangely enough its been a long time since I installed SQL in production. It’s almost always done by someone on...
2016-06-27
1,717 reads
Podcast Interview: Is the On-Premises Data Warehouse Dead?
Recently I’ve been talking a lot with clients and others about the involvement of cloud architecture in a data warehouse...
2016-06-29 (first published: 2016-06-27)
1,122 reads
IT Training: Super Duper Deal!!
In the wake of last week’s BREXIT vote and subsequent fallout, I decided to delay making this announcement until today....
2016-06-27
426 reads
SQL Server Indexing Book Giveaway – Week 4 (the late edition)
So… it’s Saturday night and I missed getting this out on Friday morning… But, in past three weeks’ posts (1, 2, 3), I talked about how I’ve got a few copies...
2016-06-26
27 reads
SQL Server Indexing Book Giveaway – Week 4 (the late edition)
So… it’s Saturday night and I missed getting this out on Friday morning…
But, in past three weeks’ posts (1, 2, 3),...
2016-06-26
731 reads
SQL Compare 12: Initial Look
I know there have been a few other folks going into more detail on SQL Compare 12 (beta), but I...
2016-06-25
472 reads
Speaking at PASS Summit 2016
There is a huge time for suspense for everyone in the Microsoft Data Platform space, whenever its time to submit...
2016-06-25
432 reads
PASS Summit 2016 – Connect, Share, Learn
Please join me and about 4000+ other technology professionals for the annual PASS Summit in Seattle, WA October 24th – 28th....
2016-06-24
546 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