Daily Coping 24 Mar 2023–The Final Tip
Today’s coping tip is to discover the joy in the simple things in life. This is the last coping tip for now. It’s been 3 years, and I hope...
2023-03-24
19 reads
Experimenting with RedisGraph on Docker and Windows
I have been experimenting a bit with graph databases, trying to learn more about them. One of the platforms I wanted to experiment with was RedisGraph. This post looks...
2023-03-24 (first published: 2023-03-23)
63 reads
Resources for Adding Graph Structures to Your Database at VS Live
Thanks to everyone who attended my talk at VS Live Las Vegas 2023 on graph databases. I hope you enjoyed it, and if you have questions, please feel free...
2023-03-23
20 reads
Resources for Architecting Zero Downtime Deployments
I delivered my talk on Architecting Zero Downtime Deployments yesterday at VS Live Las Vegas 2023. It went fairly well, even though I ran some incorrect code somewhere. Apologies...
2023-03-24 (first published: 2023-03-23)
57 reads
Daily Coping 23 Mar 2023
Today’s coping tip is to focus your attention on the good things you take for granted. My life is great. I used to say perfect, but a few struggles...
2023-03-23
9 reads
SQL Bits 2023 Recap
I had an amazing time adventuring to Wales with other members of the data community last week! It was my first international conference, and I had heard so many...
2023-03-31 (first published: 2023-03-23)
273 reads
Converting Types in C#
I am not a great software developer. I’m OK, and I do know how to use Google and Stack Overflow well. Maybe my best skill is wording searches well?...
2023-04-07 (first published: 2023-03-22)
288 reads
Daily Coping 22 Mar 2023
Today’s coping tip is to appreciate your hands and all the things they do for you. I make a living with my hands. I type constantly, which is a...
2023-03-22
8 reads
FIRST Robotics Competition 2023 - World Championships!
Last week I wrote about our FRC team, asking for support in in the form of a cheering section. Today, I’m asking for more assistance for these amazing students.
Things...
2023-03-23 (first published: 2023-03-21)
103 reads
Errata for my book: Pro Encryption in SQL Server 2022
My biggest fear when my book went into production was that any factual errors had slipped through my checks and the various reviews. I had a lot of reviewer...
2023-03-21
40 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