In this next installments of the Modern Fabric Data Warehouse, we look at tools for developers.

Testing is Becoming More Important

by Steve Jones

SQLServerCentral

Testing is going to be even more important in the age of AI.

SQL Server 2025 CREATE EXTERNAL MODEL and AI_GENERATE_EMBEDDINGS Commands Explained

by Additional Articles

SimpleTalk

Uncategorized

Now that SQL Server 2025 has finally been released to the public, I was finally able to test and learn a lot about this command (named CREATE EXTERNAL MODEL), and I want to share my knowledge with you here. If you’re new to the world of AI, don’t worry, we’ll start with the basics and evolve to where this command fits in!

Can You Let Go of Determinism

by Steve Jones

SQLServerCentral

As Steve uses AI more, it seems determinism isn't something you get out of many LLMs.

Downtime Caused by the Postgres Transaction ID Wraparound Problem

by Chandan Shukla

SQLServerCentral

PostgreSQL

Learn about transaction ID wraparound in PostgreSQL, which caused a problem for the author.

Real-time On-prem SQL Server Data in Excel – Over the Internet

by Cláudio Tereso

SQLServerCentral

Learn how you can combine Power BI and Excel to share data from your local SQL Server across the Internet to Excel on a client machine.

Microsoft Fabric and MQTT for Real-Time IoT Data Ingestion and Analytics

by Additional Articles

MSSQLTips.com

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

Microsoft Fabric is a unified platform for data integration, data engineering, real-time intelligence, and advanced analytics. Fabric is known for providing an integrated way of working with your data, connecting to many diverse types of sources and across the data landscape. How do we get started ingesting and analyzing real-time data streamed over the MQTT protocol?