Is it time for SQL Server to have Isolated Transactions?
SQL Server allows nesting of Transactions –in a sense. In truth, there is only one Transaction, with each ‘nested transaction’...
2009-03-10
801 reads
Blog Posts
Microsoft March Security Bulletin Release
This month there were 3 security bulletins released and 1 re-released:
Microsoft Security Bulletin Summary for March 2009
First, let's tackle the...
2009-03-10
1,213 reads
PASS Connector Editorial for March 11, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-03-10
588 reads
The Kindle Alternative - Humor
Kind of funny. I saw this on Twitter the other day from @DanNunan and then someone sent it to me...
2009-03-10
772 reads
[Off-Topic] Eleven Year-Old Making a Difference
Those who know me personally know that I grow my hair out to donate for kids. I have donated a...
2009-03-09
1,018 reads
Book Review: Murach's SQL Server 2008 For Developers
I received a review copy of Murach's SQL Server 2008 For Developers a couple months back and just finished up...
2009-03-09
1,191 reads
Netbooks - Hands On Review
The other day I was wandering around Best Buy and noticed that they had a few netbooks for sale. I...
2009-03-09
1,353 reads
Book Review: Big Red - Voyage of a Trident Submarine
I've grown up reading Tom Clancy and probably most of you have at least seen Red October, so this book...
2009-03-08
430 reads
Building Reports, 2.0 Style
I’m getting my first taste of the new SQL Report Builder 2.0, and so far I’m enjoying the upgrade. Report...
2009-03-08
2,394 reads
MVP Summit 2009 -A Most Excellent Adventure
For many of us, one of the high points of being an MVP is attending the annual MVP Summit hosted...
2009-03-07
416 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
Question of the Day
RegEx Functions II
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') AND BusinessEntityID IN (7,8)See possible answers