Presentation materials: Intro to Analysis Services (SSAS)
I did a presentation last week for the Denver SQL Server User Group (www.DenverSQL.org) and the Colorado Springs SQL Server User Group...
2009-06-26
1,521 reads
Incorporating Kids Into Work
I recently attended SQL Saturday #14 in Pensacola and took my daughter along. This was the third presentation she's come...
2009-06-26
1,479 reads
My Favorite Bad Movie
My favorite bad movie is The Master Gunfighter starring Tom Laughlin of Billy Jack fame. It’s a Western, and he’s...
2009-06-25
1,505 reads
Plug for a Cool Catalog
Ran across the Levenger site while researching laptop bags and it’s branded as ‘tools for serious readers’. Some of it...
2009-06-25
1,457 reads
Exceptional DBA Award Entries Must Be In By July 10, 2009
If you have been considering entering yourself in the Exceptional DBA Awards this year, or nominating a DBA you know,...
2009-06-25
1,604 reads
How to Avoid Database Restore Issues by a Simple Script Edit - A DB Restore Work-around
During the process of applying changes to a production database - let's call it Change Management (pick your ITIL or COBIT...
2009-06-25
2,675 reads
An Android Update - TMobile G1
I still love my G1, and I got a pleasant surprise recently. I was out at dinner with my wife,...
2009-06-25
1,490 reads
Powershell + SMO Error Handling Tips
Allen White posted a helpful post on SMO error handling with Powershell. Actually the same concept equally applies to SMO...
2009-06-25
1,678 reads
Why Do I Blog?
It's late, it's been a busy day, so why bother to spend 10 or 15 minutes at night jotting things...
2009-06-24
1,499 reads
Dell Mini – The Follow Up
Back in January I posted about purchasing a Dell Mini 9, wanting to see what how it worked and a...
2009-06-24
1,381 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