RMOUG Training Days in Denver
Next week I’m heading to the Lowry Conference Center in Denver for the RMOUG Training Days. The Rocky Mountain Oracle User Group has put this on for years, and...
2023-02-07
24 reads
Daily Coping 7 Feb 2023
Today’s coping tip is to go to bed in good time and allow yourself to recharge. I need this reminder. Lately I’ve struggled to sleep well, through the night,...
2023-02-07
18 reads
Tales From The Field Weekly Wrap Up for the Week of 01-31-2023
Hello Dear Reader! After a weekend with a lot of activities, it was a down week here at Casa Balls. Woke up and walked a lot. I'm still not...
2023-02-06
43 reads
Creating a Flyway Desktop Shadow Database in PostgreSQL
In order to generate migrations, we need to configure Flyway to use a shadow database. This post looks at that process. This is part of a series of working...
2023-02-08 (first published: 2023-02-06)
132 reads
Query Store Data Cleanup
Microsoft supplies quite a few knobs to control how Query Store performs data cleanup. You can set your cleanup various ways, and, they interact. Let’s talk about how and...
2023-02-22 (first published: 2023-02-06)
283 reads
Daily Coping 6 Feb 2023
Today’s coping tip is to get back in contact with an old friend. This is something I don’t do too often, but I have done a few times. I’ve...
2023-02-06
20 reads
Rotating a Certificate Used by TDE
In terms of encryption, Key Rotation is the process of replacing your encryption keys on a periodic basis. This is considered good practice and is required by many security...
2023-02-20 (first published: 2023-02-06)
310 reads
Daily Coping 3 Feb 2023
Today’s coping tip is to ask other people about things they’ve enjoyed recently I asked the question on Twitter and on Facebook, looking for interesting responses from friends. The...
2023-02-03
14 reads
Daily Coping 2 Feb 2023
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m struggling with some negative thoughts outside of work. This year as I coach older girls,...
2023-02-02
17 reads
Deadline for Microsoft MVP contributions is 20 March 2023
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31 March each year to provide the list of their annual contributions. For 2023, the deadline...
2023-02-20 (first published: 2023-02-01)
151 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