Making Forums Work
I saw this post about Why I Dislike Newsgroups from Tom Larock and he did a pretty good job of...
2009-04-27
1,036 reads
When a Community Rallies!
I have been a bit lax these past few days, but I have been having a bit of a writers...
2009-04-27
1,455 reads
Notes on SQLSaturday #13
I drove up on Friday with my friend Kendal Van Dyke. Long drive from Orlando, just over 8 hours. Arrived...
2009-04-27
666 reads
Asymmetric Keys in SQL Server
I've been tech editing an encryption book for SQL Server. It's long overdue, and I think it will be a...
2009-04-27
2,717 reads
SQL Quiz 4: Leadership
I'm finally getting around to answering this one originated by Chris Shaw (@SQLShaw), as I was tagged by Jack Corbett...
2009-04-27
741 reads
Visiting West Palm Beach SQL Group on April 29, 2009
I'm going to West Palm Beach on Apr 29th to visit Scott Klein and his group. I'll be doing a...
2009-04-26
629 reads
Patterns & Practices SIG starting up in Columbia, SC
C# MVP Chris Eargle (@kodefuguru on Twitter), who is also an INETA community champion and president of the Columbia Enterprise...
2009-04-24
1,010 reads
Moving Forward with Nuclear
We use a lot of power in our computing infrastructure. And while I’m mindful of the concerns over safety, environment,...
2009-04-24
898 reads
SQL Server Security Basics: Why Would I Use SQL Server Authentication?
The standard best practice answer when it comes to connecting to SQL Server is to use Windows authentication. However, SQL...
2009-04-24
3,823 reads
PASS Summit Sessions Submitted
It's official – I've submitted my abstracts for the 2009 PASS Summit and received my confirmation. Now I wait to see...
2009-04-24
670 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
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
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
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