Find Missing SQL Server Data with NOT EXISTS
After years of writing T-SQL a certain way, changing can be tough. When comparing tables for missing rows, developers often use LEFT JOIN.
No Defaults Passwords Ever
Steve doesn't see a reason why we should have default passwords on systems ever.
Eight Minutes
When I was at the Small Data 2025 conference, one of the speakers was talking about their work with AI technologies. This person uses it a lot in their day job, often to complete tasks that they would have struggled to work on in the past, mostly because of time constraints, but also a lack […]
SQL Server Privilege Escalation via Replication Jobs
Learn how attackers can exploit SQL Server replication cleanup jobs to escalate privileges from db_owner to sysadmin
Faster Data Engineering with Python Notebooks: The Fabric Modern Data Platform
In this next article on the Fabric Modern Data Platform, we use the Polars library in Python to improve our data engineering.
JSON Has a Cost
JSON has become a very popular data format used in many software applications. However, it's not magic.
Power BI – Download, Install and Create Your First Report
Power BI Desktop is Microsoft’s platform for analytics and visualization. The product has been around for over ten years, making it a mature feature-rich choice for business intelligence reporting and actionable insights. How do you get started downloading, installing, and configuring Power BI desktop?
An SSIS Upgrade
SSIS is still in use by many customers. Steve discusses a few changes to SSIS in SQL Server 2025.
Semantic Search in SQL Server 2025
Learn how we can search text values in SQL Server 2025 using the new AI capabilities.
Common SQL Server Problems: Invalid Object Name
Learn why SQL Server shows ‘Invalid object name’ errors and how to fix them.
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline
Comments posted to this topic are about the item From SQL Server On-Premises to...
Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
Question of the Day
Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers