The JOIN statement is one of the most common operations SQL developers perform. Yet in a world ruled by Inner and Left Joins, the poor Full Outer Join is like Cinderella before the ball – allowed out on only the rarest of occasions. In an (unscientific) survey I once performed of SQL developers at one Fortune 100 firm, half of the developers had never used a Full Outer Join in production code, and the rest had used it in a tiny handful of occasions.

Choosing an AI in Sept 2025

by Steve Jones

SQLServerCentral

Artificial Intelligence (AI)

Steve talks a bit about choosing an AI model.

How to Use SQL Server Features to Cut Web App Latency in Half

by Muhammad Adnan

SQLServerCentral

Uncategorized

Discover how SQL Server features reduce web app latency. Learn key tactics to deliver faster queries and better performance in today’s web economy.

Building a Dynamic Countdown Timer in Power BI

by Additional Articles

MSSQLTips.com

Power BI

A countdown timer can be a powerful visual tool in many Business Intelligence reporting scenarios. This could be for marketing campaigns, contract expiries, and business deals with clients. Real-time countdown visuals are not natively supported in Power BI. Although, there is the Count Down Timer custom visual, which is not dynamic in its configuration.

Building AI Governance and Policies- First Steps

by dbakevlar@gmail.com

SQLServerCentral

Artificial Intelligence (AI)

AI has moved from experimental to operational in record time for many organizations. In industries like fintech, healthcare, and retail where sensitive PII (personally identifiable information) and relational databases are the backbone of daily operations, this innovation speed to adopt AI brings enormous opportunity, but also significant risks

Building a Simple SQL/AI Environment

by tsavoie@gmail.com

SQLServerCentral

Generative AI (GenAI)

This article shows a simple way to integrate a local GEnAI model into your T-SQL work.

Don't Forget About Financial Skills

by Steve Jones

SQLServerCentral

Misc

A bit of advice from Steve to ensure you do not neglect the management of your finances for the long term.

Power BI TMDL View: Benefits, Security Risks & Best Practices

by Additional Articles

SimpleTalk

Power BI

The Tabular Model Definition Language (TMDL) provides a simpler way of defining Power BI Semantic Models. Unlike the JSON-based Tabular Model Scripting Language (TMSL), TMDL uses a more accessible tab-based format for specifying DAX measures, relationships, and Power Query code.