Choose the Second One
Steve talks software design and architecture today with an interesting idea: design it twice.
PostgreSQL in action with Opensearch
Learn about using Opensearch with PostgreSQL to improve performance and quickly return results to your users.
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
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.
Communication, For Incidents and Life
Many years ago, I was on call for a production system. This was common for me since I was one of several production DBA’s for the company. It was a normal weekend for me, and I got up and started playing with my kids. They were heavily into trains, and we were laying out our […]
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.
Take the 2027 State of the Database Landscape Survey
Share your view on the database landscape and you could win USD$500.
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.
Training the next generation
Many years ago, I started at a smaller-sized company. About 150 employees; it was a SaaS company that provided survey software. It was growing quickly, and I was the primary DBA. I was hired not only to be a DBA, but to build a DB team to handle many of the issues the company faced […]
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
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
Vidalista Tablets – Reliable ED Solution for Men
Vidalista is a trusted platform to purchase Vidalista tablets, a popular and effective treatment...
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers