SQL Profiler ...Error ...Click OK to terminate program
Hi to everyone! I decide to write it in my blog here about this problem because really don't have any...
2009-08-27
1,306 reads
Analysis Services Memory Limits
I attended a presentation recently from Steven Wright of SQL Sentry on Analysis Services (SSAS) memory management and it was...
2009-08-27
3,826 reads
Work Habits
I enjoy woodworking as a hobby and as I try new things I find that my work habits during the...
2009-08-26
1,579 reads
Access Denied, Not Possible
What’s going on here?
When trying to open Default Trace files on Windows 7 and SQL Server 2008 I got the...
2009-08-26
1,211 reads
Intel Calpella Launch At End of September?
According to Gizmodo, Intel is due to launch the next generation Centrino mobile platform, known as Calpella at the end...
2009-08-26
602 reads
Would You Like to Do Technical Reviews of Articles for PASS’s SQL Server Standard?
If you haven’t heard yet, PASS has started commissioning articles to be published in the new PDF version of the...
2009-08-26
711 reads
TSQLScripts.com – The Rebirth and the Script of the Week
About two years ago I started www.TSQLScripts.com, and initially the response was great. Within two weeks I had received about...
2009-08-26
618 reads
PASS Call for Nominations
The call for nominations for the PASS Board of Directors is open until Sep 3rd and I want to reiterate...
2009-08-26
1,296 reads
Building a Better Blog - Next week during the 24 hours of PASS
I've got a new presentation on blogging slated for next week during the 24 hours of PASS. The event is...
2009-08-26
821 reads
Corruption in sys.dependencies
The second type of corruption I want to look at is that of missing references in sys.sql_dependencies. This typically appears...
2009-08-26
450 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