Behavior of ORDER BY + UNION Can Be Confusing
This is an interesting example and it exposes a quirk with the concept of a UNION, which is, that the...
2015-06-10 (first published: 2015-06-08)
3,390 reads
Animated Graphics Depict The Fallen of World War II
In an amazing application of visualization techniques, this production is a depiction of the casualties and affects of war. Starting...
2015-06-07
208 reads
Animated Graphics Depict The Fallen of World War II
In an amazing application of visualization techniques, this production is a depiction of the casualties and affects of war. Starting...
2015-06-07
420 reads
See You Next Weekend at SQL Saturday Houston!
Looking forward to speaking next weekend at SQL Saturday Houston 2015 on June 13!
If you haven't already registered for this...
2015-06-05
513 reads
New Course: Building Better SSIS Packages–Denver and Boston
Earlier this week, I confirmed two full-day seminars I’ll be delivering in conjunction with SQL Saturday events this fall. I’ve...
2015-06-05
697 reads
006 – Personal Trainer - WaterOx Consulting
Reading Time: 5 minutesDo You Have a Personal Trainer? In WOxPod!, episode # 006 –...
The post 006 – Personal Trainer appeared first...
2015-06-05
501 reads
SSC Editorial: Should Salary Information Be Confidential?
I’m expecting Should Salary Information Be Confidential? to draw a wide range of comments. I’m curious to see if many will be...
2015-06-05
362 reads
SQL Server – Capture Execution Plan of a Currently Running Query/Process SPID
DBAs most often face scenarios where they need to capture graphical execution plan of a query currently running on a live production instance because...
2015-06-05
1,112 reads
SQL Server – How to Calculate Length and Size of any field in a SQL Table
Recently I came across a situation where queries are loading extremely slow from a table. After careful analysis we found...
2015-06-04
712 reads
Why NULL Placement Matters
Not those Benjamin’s
Benjamin Franklin once said, “A place for everything and everything in it’s place“. While I assume that he...
2015-06-10 (first published: 2015-06-04)
3,169 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