Making an Impression
The job market is tough and Steve has some advice today on how you approach your career.
MiniMax m3 and SQL Server
Learn how you can download and run a local model to help with your SQL Server work.
Strip double quotes from an import file in Integration Services SSIS
When loading data using SQL Server Integration Services (SSIS) to import data from a CSV file, every single one of the columns in the CSV file has double quotes around the data. When using the Data Flow Task to import the data I have double quotes around all of the imported data. How can I import the data and remove the double quotes?
What Did Healthy Look Like?
Every cloud migration plan has a cutover date but very few have a record of what healthy looked like before the move, and that’s the gap that lands on your desk two weeks later.
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.
Blogs
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
SQL Server Vector Support II
Comments posted to this topic are about the item SQL Server Vector Support II
Great Things
Comments posted to this topic are about the item Great Things
Troubleshooting Slow Queries That Already Have an Index
Comments posted to this topic are about the item Troubleshooting Slow Queries That Already...
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers