Immunizations – Not Just for Kids
It’s the ‘get your flu shot’ time of the year, which is also a good time to review your immunizations....
2015-12-22
642 reads
How to Compare Tables in SQL Server
One of our customers has recently asked me the following question (I changed just the business case):
The Problem
“I have a...
2015-12-22
551 reads
Fixing Truncation Issues with T-SQL Flex
If you’ve worked with SQL Server for any length of time, you’ve run into this error:
Msg 8152, Level 16, State...
2015-12-21
1,068 reads
Goodness-of-Fit Testing with SQL Server, part 3.2: D’Agostino’s K-Squared Test
By Steve Bolton
…………In the last edition of this amateur series of self-tutorials on goodness-of-fit testing with SQL Server, we discussed...
2016-01-04 (first published: 2015-12-21)
2,121 reads
Monday Morning SQL Break – December 21, 2015
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2015-12-21
455 reads
Thanks to Rodney & Karla
Sometime in the next couple weeks Rodney & Karla Landrum are moving from Orlando to Pensacola (home). I’m happy for them...
2015-12-21
623 reads
Learning R: Hard Lessons
I’ve always found the best way to learn a new programming language is to start building stuff, solving problems, using...
2015-12-21
971 reads
What is the current database context?
Every now and again it can be very helpful to know what the current database context is when you are...
2015-12-21
679 reads
Use Compression to Combine Data Quality and Performance
We’ve been using the wrong data types for all the wrong reasons. DBAs, developers, data architects, etc. have all been...
2015-12-21
991 reads
Demystifying the Type 2 Slowly Changing Dimension with Biml
Most data warehouses have at least a couple of Type 2 Slowly Changing Dimensions. We use them to keep history...
2015-12-21
999 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