A small social media poll from Visual Studio guru Mads Kristensen split respondents over whether the IDE should add more database tooling, while the discussion quickly turned to existing SQL project support, SDK-style SQL projects and the broader state of Microsoft's database developer tooling.
Dr. James McCaffrey presents a complete end-to-end demonstration of quadratic regression, implemented from scratch, with pseudo-inverse training, using the C# language. Compared to standard linear regression, quadratic regression is better able to handle data with a non-linear structure and interactions between predictor variables. Compared to other types of training, pseudo-inverse does not require any parameters that must be determined by trial and error.
- By James McCaffrey
- 05/01/2026
Microsoft's Data API Builder is designed to help developers expose database objects through REST and GraphQL without building a full data access layer from scratch. In this Q&A, Steve Jones previews his upcoming Visual Studio Live! San Diego 2026 session on how teams can use the tool with SQL Server and PostgreSQL to accelerate app development.
Dr. James McCaffrey presents a complete end-to-end demonstration of quadratic regression, with SGD training, implemented from scratch, using JavaScript. Compared to standard linear regression, quadratic regression is better able to handle data with a non-linear structure, and data with interactions between predictor variables.
- By James McCaffrey
- 03/11/2026
Dr. James McCaffrey presents a complete end-to-end demonstration of decision tree regression from scratch using the C# language. The goal of decision tree regression is to predict a single numeric value. The demo implementation doesn't use pointers (references) for simplicity and does not use recursion for better maintainability and customization.
- By James McCaffrey
- 02/17/2026
Dr. James McCaffrey presents a complete end-to-end demonstration of quadratic regression, implemented from scratch, with SGD training, using C#. Compared to standard linear regression, quadratic regression is better able to handle data with a non-linear structure, and data with interactions between predictor variables.
- By James McCaffrey
- 01/21/2026
Learn how to supercharge your GenAI apps with PostgreSQL and Azure AI. Lino Tadros shows how PGVector and AI Extensions in VS Code turn PostgreSQL into an intelligent foundation for high-performance GenAI systems--solving common RAG pitfalls like irrelevance and hallucination.
At the upcoming Visual Studio Live! Las Vegas developer conference, SQL expert Denny Cherry will share essential indexing strategies to boost performance in SQL Server databases--from 2000 to 2025. Here, Denny explains more about his session in which .NET devs can learn best practices, common mistakes, and how to optimize apps with smarter indexing.
Expert consultant Greg Shulz said next-generation data visualization requires modernizing the full pipeline from data preparation through AI-governed analytics to interactive, story-driven presentation in order to reduce mean time to insight.
Once-buzzy OData continues to move forward at Microsoft, with new .NET 10-aligned tooling previews and an ODataX proposal aimed at easing adoption while preserving the protocol's enterprise-strength querying model.
Dr. James McCaffrey presents a complete end-to-end demonstration of ANOVA (analysis of variance) using JavaScript. ANOVA is a classical statistics technique where the goal is to determine if the unknown means (averages) of three or more groups are likely to all be equal or not, based on the variances of samples from the groups.
- By James McCaffrey
- 11/03/2025
Veeam detailed how it built a semantic search engine on Azure Cosmos DB to deliver fast, AI-powered data discovery across billions of backup items.
Dr. James McCaffrey presents a complete end-to-end demonstration of Tsetlin Machine binary classification using the C# language. Tsetlin Machine models have characteristics of propositional logic, rule-based systems, and finite state automata. Tsetlin Machine systems require predictor values to be binary encoded and therefore the systems are very flexible and computationally efficient in terms of each operation, but computationally expensive in terms of number of operations.
- By James McCaffrey
- 10/15/2025
Managing SQL Server across hybrid and multi-cloud environments has long posed a challenge for database administrators. To help meet that challenge, Gilda Alvarez will explain the nuts and bolts at the upcoming Live! 360 dev/tech conference
Dr. James McCaffrey presents a complete end-to-end demonstration of linear regression with two-way interactions between predictor variables. Standard linear regression predicts a single numeric value based only on a linear combination of predictor values. Linear regression with interactions between predictor variables can handle more complex data while retaining a high level of model interpretability.
- By James McCaffrey
- 10/01/2025