Find all the dates in a date range ? TIP #100
It’s almost one month that I didn’t write anything on the blog due to some personal reason. I am really...
2015-06-22 (first published: 2015-06-12)
2,444 reads
Notes on the June 11, 2015 ONETUG Meeting
I attended the monthly ONETUG meeting last night to do a SQL presentation focused on developers. Same location as last...
2015-06-12
381 reads
007 – Midnight DBA - WaterOx Consulting
Reading Time: 2 minutesMeet the Minion Master! In WOxPod!, episode # 007 – “Midnight DBA”...
The post 007 – Midnight DBA appeared first on...
2015-06-12
531 reads
AdventureWorksCI Step 1 planning
This is part of a series on how to take the Adventureworks database and bring it inline with modern standards....
2015-06-24 (first published: 2015-06-12)
1,329 reads
AdventureWorksCI Step 1 planning
This is part of a series on how to take the Adventureworks database and bring it inline with modern standards....
2015-06-12
43 reads
AdventureWorksCI Step 1 planning
This is part of a series on how to take the Adventureworks database and bring it inline with modern standards....
2015-06-12
47 reads
AdventureWorksCI Step 1 planning
This is part of a series on how to take the Adventureworks database and bring it inline with modern standards. How do we put a legacy SQL Server database...
2015-06-12
8 reads
Error Upon First Processing Your SSAS Database With A Service Account
This blog post is to document the easy fix to a problem that has become a rite of passage for...
2015-06-11
2,508 reads
10 Things a Database Design Company Should Do
Database design is a complex industry involving many technologies, software and specialists. The term “design” is a little bit misleading...
2015-06-11
463 reads
Using the DAC with SSMS
I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few...
2015-06-11
888 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