PostgreSQL in action with Opensearch
Learn about using Opensearch with PostgreSQL to improve performance and quickly return results to your users.
2026-10-23
1,330 reads
Articles
How to run PostgreSQL in Docker
Get PostgreSQL running in Docker in minutes with this step-by-step setup guide. Learn to pull the image and run a container
2026-10-23
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Learn how to use CHOOSE() and IIF() to validate priorities and return easy to read messages to the user.
2026-10-21
2,307 reads
How to Create an Alert in the Microsoft Fabric Warehouse
We are building a new data platform with Microsoft Fabric and we’re using the warehouse for our “gold layer”. We don’t have real-time ingestion or analytic requirements, but we have a use case where we want to send an alert if a certain threshold is reached. Ideally, the alert is sent when a SQL query returns a result set.
2026-10-21
Take the 2027 State of the Database Landscape Survey
Share your view on the database landscape and you could win USD$500.
2026-10-21 (first published: 2026-09-28)
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
In part 4 of this series, we look at using CROSS APPLY to filter in a function.
2026-10-19
1,616 reads
What happens when your AI coding agent starts a database on its own
How to build an app through an LLM: switching from CoPilot to Claude, a directional term-lookup feature
2026-10-19
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
This article shows two scenarios, tested independently, with the full scripts and the real numbers from each run.
2026-10-16
1,883 reads
Explanation of SQL Server IO and Latches
I eventually found an explanation for this error message that, while not completely satisfactory, did lead me to diagnose wider-reaching I/O issues on the affected instance and led me to a better understanding of latching in general.
2026-10-16
Re-Seeding a Broken Log Shipping Secondary (Without Touching the Primary)
A SQL Server upgrade left a log shipping secondary unable to accept transaction logs. Re-seeding it without touching the primary or its mirror is straightforward in principle — drop, restore full + diff + log with NORECOVERY, hand back to the job — but three undocumented traps will stop you along the way. Here's what they are and how to get past them.
2026-10-14
1,009 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
How have you encouraged communication at work?
I do have a question. At work, some groups of people have an inordinate...
Alamat Telp BCA KCP Cipanas Cs 0823-7497-7784
Wa:082374977784 Jl. Raya Cipanas, Gadog, Kec. Pacet, Kabupaten Cianjur, Jawa Barat 43253
Alamat dan Kontak J&T Cargo Makassar
•Nama Mitra: J&T Cargo UPG013A •Alamat: jl. Kerung kerung no 7 A •Kota Makassar...
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers