Resolved: A Duty to Act
If you are a member of PASS, you probably got an email from our President, Thomas LaRock. I interpreted his...
2015-11-25
620 reads
SSC Editorial: Early Adopters
I wrote Early Adopters for SQLServerCentral after seeing a comment elsewhere that basically lumped all MVP’s into one category as...
2015-11-25
538 reads
Women in technology
Earlier this week a friend of mine (Lynn Swayze (Hall) (b/t)) posted this great article on women in technology. It’s...
2015-11-25
633 reads
Changing case of T-SQL Keywords
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5...
Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes some...
2015-12-01 (first published: 2015-11-24)
2,733 reads
Changing case of T-SQL Keywords
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes some internal struggle as it is actually one person...
2015-11-24
12 reads
Changing case of T-SQL Keywords
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes...
2015-11-24
50 reads
Changing case of T-SQL Keywords
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes...
2015-11-24
59 reads
SQL Server 2005 End of Support and Business Intelligence
How does the official end of support for SQL Server 2005 affect companies using Reporting Services, Analysis Services and other...
2015-12-02 (first published: 2015-11-24)
1,900 reads
We Are All Responsible
Today we all received an email from PASS's president Tom LaRock (blog/@SQLRockstar):
PASS Anti-Harassment Policy ReminderIt is unfortunate that I have...
2015-11-24
495 reads
Tuesday Morning SQL Break – November 24, 2015
It’s Tuesday time for this week’s one day late blog and twitter round-up for last week. If you haven’t already, follow me...
2015-11-24
537 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