TSQL Tuesday #68: What is my configuration?
It’s T-SQL Tuesday again and this month Andy Yun (b/t) is our host and he has asked us to “Just...
2015-07-21 (first published: 2015-07-14)
1,447 reads
SQL Server and Defaults
What is that default setting? SQL server does a fantastic job of having numerous settings at the server level and at the database level predefined for you. Additionally, the...
2015-07-14
17 reads
SQL Server and Defaults
What is that default setting?
SQL server does a fantastic job of having numerous settings at the server level and at...
2015-07-14
610 reads
Database Version Control Workshops
We’ve got more Workshops coming this fall from Redgate Software to help you get the most out of our tools...
2015-07-13
760 reads
What was I thinking? Deleting myself from localdb?
Was testing a batch file to add a user to a localdb instance. Assumed that my user as admin on...
2015-07-13
512 reads
T-SQL Tuesday #68: Just say No to Defaults
It’s the second tuesday of the month and you know what that means! T-SQL Tuesday time! If you don’t know...
2015-07-17 (first published: 2015-07-13)
2,428 reads
Azure SQL Database – Adding a Login
I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few...
2015-07-13
764 reads
PASS Summit 2015 – Guess What?
Quick run the other way! PASS Summit will never be the same! Why? Well, because for the first time in the history of me, I have been selected to speak...
2015-07-13
8 reads
PASS Summit 2015 – Guess What?
Quick run the other way!
PASS Summit will never be the same!
Why?
Well, because for the first time in the history of me,...
2015-07-13
606 reads
Paging in SQL Server 2012
Paging is one of the most highly required features during application development process. Microsoft has introduced various features since the...
2015-07-16 (first published: 2015-07-13)
2,867 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