Day 6 – Lost in Space
This is the sixth installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...
2013-12-30
1,208 reads
Last Weeks Top “Reading” Links #64
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2013-12-30
1,183 reads
Kissing 2013 Goodbye
The end of the year is here, which means it’s time to look back and review my goals and reflect...
2013-12-30
1,224 reads
SSRS Interactive Sorting a Matrix
Sorting a matrix report can be done interactively. To perform interactive sorting, your report you will need a cell to...
2013-12-30
1,871 reads
Memory Timeouts
Recently I was asked to investigate a timeout issue that was causing SSIS package executions to fail.
The timeouts seemed to...
2013-12-30
1,331 reads
A New Year is Right Around the Corner
If you read my 2013 Year In Review you may be here today wondering why I haven’t posted anything despite...
2013-12-30
1,575 reads
Final December Giveaway!
Today I'm giving away the book Professional SQL Server 2012 Internals and Troubleshooting. If you live outside the continental US,...
2013-12-30
513 reads
Day 5 – Peer Identity
This is the fifth installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...
2013-12-29
9 reads
Day 5 – Peer Identity
This is the fifth installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...
2013-12-29
719 reads
Deleting Duplicate rows using CTE
Many times we caught in a situation where we have a table where there is no primary or unique column...
2013-12-29
59,420 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
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
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...
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