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

by Steve Jones

SQLServerCentral

Steve doesn't see a reason why we should have default passwords on systems ever.

Eight Minutes

by Steve Jones

SQLServerCentral

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

by Additional Articles

SimpleTalk

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

by John Miner

SQLServerCentral

Microsoft Fabric (Azure Synapse, Data Engineering, etc.)

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

by Steve Jones

SQLServerCentral

JSON

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

by Additional Articles

MSSQLTips.com

Power BI

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?