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.
2026-01-19
Articles
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
2026-01-16
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.
2026-01-14
1,841 reads
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?
2026-01-14
Semantic Search in SQL Server 2025
Learn how we can search text values in SQL Server 2025 using the new AI capabilities.
2026-01-12
3,111 reads
Common SQL Server Problems: Invalid Object Name
Learn why SQL Server shows ‘Invalid object name’ errors and how to fix them.
2026-01-12
T-SQL in SQL Server 2025: Encoding Functions
Learn about these new binary encoding and decoding functions in SQL Server 2025.
2026-01-09
2,451 reads
Generating Shape Bound Random Points in SQL Server
Random number generation is vital in computer science, supporting fields like optimization, simulation, robotics, and gaming. The quality, speed, and sometimes security of the generator can directly affect an algorithm’s correctness, performance, and competitiveness. In Python, random number generation is well-supported and widely used. In this article, we will look how to we can use SQL to do this.
2026-01-09
PowerShell Day By Day: The Pipeline
In this article, I wanted to discuss the PowerShell (PoSh) pipeline, which was confusing to me at first and took some time to get used to working with. I had used one in Linux before, but the PoSh one is more powerful, but also slightly different. Hopefully I can demystify some of the concepts for […]
2026-01-07 (first published: 2020-12-31)
6,140 reads
Using Python notebooks to save money in Fabric: The Fabric Modern Data Platform
In this next article, we look at how notebooks using Python can be cheaper than Spark notebooks.
2026-01-07
2,398 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers