Working Remotely
It's too quiet in the house.
So I headed out to get some lunch and work at Paradise Bakery. They have...
2009-05-04
396 reads
Backing Up Asymmetric Keys
I've been tech editing a book about SQL Server encryption and this series of blog posts looks at some interesting...
2009-05-04
9,548 reads
Notes on SQLSaturday #15
I drove up on Friday night for the speaker dinner, getting there after a busy day trying to catch up...
2009-05-03
422 reads
Do You Have What It Takes?
I was engaged in a conversation recently where the topic under discussion was "What defines an "A" class player?" Others...
2009-05-02
382 reads
Published, Again!
I have written two new articles and they are going to be published, not on SSC but on SSWUG. I...
2009-05-02
1,286 reads
Up and Running
I’ve neglected my weather station for a few weeks. Lots of work, high winds, and snow have slowed me down.
Finally...
2009-05-01
406 reads
Lost in the Chaos
This morning I had an 8am call with the owners of my company and a consultant that was proposing some...
2009-05-01
447 reads
New Community Resource for IT Pros - Server Fault
Not too long ago the developer community got a fantastic resource called Stack Overflow. It's a question and answer site,...
2009-05-01
1,074 reads
Featured Blog: The HOBT by Aaron Alton
I've been trying to feature a blog each month and for April (one day late!) it's Aaron Alton. HOBT stands...
2009-05-01
494 reads
Transparent Data Encryption - A hole?
Transparent Data Encryption (TDE) sounded like a really cool feature when I first heard of it. Encrypt your database without...
2009-05-01
525 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