#PGSQLPhriday 006: What I Wish I Knew While Learning PostgreSQL
Well, for those who don’t know me, I’m just barely started on my PostgreSQL journey. So, what the heck can I contribute to this conversation? Not much, but I...
2023-03-03
35 reads
Daily Coping 3 Mar 2023
Today’s coping tip is to send an encouraging note to someone who needs a boost. I met someone at a conference years ago and kept in touch. For some...
2023-03-03
32 reads
Daily Coping 2 Mar 2023
Today’s coping tip is to make plans with a friend or loved one. I don’t like making plans, preferring to somewhat flow with life and make decisions close to...
2023-03-02
24 reads
JC Bootcamp Stories – Denisa
Od minulého roku jsme spustili náš 4-týdenní Joyful Craftsmen Bootcamp pro budoucí Data Engineers. Jedná se o intenzivní studium přímo u nás v Joyful Craftsmen HUBu, které posouvá datové...
2023-03-02
35 reads
Shutting Down Coping Tips
It’s been nearly 3 years of Daily Coping Tips here at the Voice of the DBA. I started these when the pandemic hit and the world shut down. I’ve...
2023-03-01
40 reads
Documentation vs Automation
Originally, I was going to write a post on troubleshooting SQL Server. This is because I’m writing up and reviewing a lot of documentation at my current job. I’ll...
2023-03-08 (first published: 2023-03-01)
461 reads
Adding a Computed Column–#SQLNewBlogger
Recently I needed to add a computed column to a table and realized that I didn’t remember the syntax. This short post show how to do this. Another post...
2023-03-10 (first published: 2023-03-01)
477 reads
Daily Coping 1 Mar 2023
Today’s coping tip is to call a friend to catch up and really listen to them Actually a friend pinged me to ask about a call recently. I made...
2023-03-01
20 reads
30 Interview Questions for a Database Administrator and Developer
This blog post summarizes the type of technical questions I would ask candidates for a Microsoft SQL Server data platform administrator and database developer role.Hopefully this helps both candidates...
2023-03-08 (first published: 2023-02-28)
1,344 reads
Daily Coping 28 Feb 2023
Today’s coping tip is to thank three people you feel grateful to and tell them why. This is something I tend to do privately, thanking people who’ve impacted my...
2023-02-28
16 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
Alamat BCA KCP Sudirman Mansion Telp:0821-8200-233
Telp/WA 62 8218200233 Sudirman Mansion, JL Jenderal Sudirman, Kav. 59 No.77 Lt. G No....
Alamat BCA KCP Tebet Barat 2 Telp:0821-8200-203
Telp/WA 62 8218200203 Jl. Tebet Raya No.25 B Blok CI, RT.1/RW.2, Tebet Tim., Kec....
Alamat BCA KCP Setiabudi Atrium Telp:0821-8200-174
Telp/WA 62 8218200174 Setiabudi Atrium, Plaza Setiabudi, Jl. H. R. Rasuna Said No.Kave 62...
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