Microsoft PM Carlos Robles previews his Live! 360 Orlando session on how recent updates to the MSSQL extension—like GitHub Copilot integration, Schema Designer, and local SQL containers—are transforming SQL development inside Visual Studio Code. Designed for developers, not DBAs, the session showcases how VS Code can streamline database work and unify application and SQL workflows in one tool.
Microsoft updated the free MSSQL extension for Visual Studio Code with public preview support for browsing Microsoft Fabric workspaces and provisioning SQL Database in Fabric from within VS Code, plus GitHub Copilot slash commands and reliability fixes; the extension also supports connecting to SQL Database in Microsoft Fabric via the standard connection experience.
Learn how to work with streaming data using Microsoft Fabric, KQL, and Real-Time Intelligence in this full-day Live! 360 workshop led by Matt Gordon (Apps Associates) and Christopher Schmidt (Microsoft). The session focuses on building real-time, event-driven solutions that deliver business value fast.
Dr. James McCaffrey presents a complete end-to-end demonstration of the kernel ridge regression technique to predict a single numeric value. The demo uses the kernel matrix inverse (Cholesky decomposition) technique for model training. There is no single best machine learning regression technique, but when kernel ridge regression prediction works, it is often highly accurate.
- By James McCaffrey
- 09/15/2025
Dr. James McCaffrey presents a complete end-to-end demonstration of the kernel ridge regression technique to predict a single numeric value. The demo uses stochastic gradient descent, one of two possible training techniques. There is no single best machine learning regression technique, but when kernel ridge regression prediction works, it is often very accurate.
- By James McCaffrey
- 09/02/2025
Microsoft’s Bradley Ball dives into the inner workings of SQL Server indexing to help developers and DBAs speak the same language, avoid common pitfalls, and boost performance with smarter, more intentional index design.
Dr. James McCaffrey presents a complete end-to-end demonstration of computing the determinant of a matrix using the C# language. In machine learning scenarios, computing the determinant of a matrix is typically used during model training to determine if a matrix has an inverse or not.
- By James McCaffrey
- 08/19/2025
At Live! 360 in Orlando this November, data & AI engineer Jean Joseph will demonstrate how to build AI-powered applications with Azure Database for PostgreSQL. His session covers vector search, embeddings, and retrieval-augmented generation (RAG) for real-world AI use cases, showing how PostgreSQL with Azure extensions can deliver semantic search, recommendations, and chatbots directly from within the database.
Dr. James McCaffrey presents a complete end-to-end demonstration of k-nearest neighbors regression using JavaScript. There are many machine learning regression techniques, but k-nearest neighbors is especially simple to implement and the results are highly interpretable.
- By James McCaffrey
- 08/04/2025
Dr. James McCaffrey presents a complete end-to-end demonstration of the kernel ridge regression technique to predict a single numeric value. The demo uses stochastic gradient descent, one of two possible training techniques. There is no single best machine learning regression technique. When kernel ridge regression prediction works, it is often highly accurate.
- By James McCaffrey
- 07/14/2025
Dr. James McCaffrey presents a complete end-to-end demonstration of linear regression using JavaScript. Linear regression is the simplest machine learning technique to predict a single numeric value, and a good way to establish baseline results for comparison with other more sophisticated regression techniques.
- By James McCaffrey
- 07/07/2025
Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demonstration of computing a matrix inverse using the Cayley-Hamilton technique. Compared to other matrix inverse algorithms, Cayley-Hamilton is very simple and as a nice side effect gives you the matrix determinant. However, Cayley-Hamilton is not suitable for use with large matrices.
- By James McCaffrey
- 06/16/2025
Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demonstration of the linear support vector regression (linear SVR) technique, where the goal is to predict a single numeric value. A linear SVR model uses an unusual error/loss function and cannot be trained using standard techniques, and so particle swarm optimization training is used.
- By James McCaffrey
- 06/03/2025
Bring AI to your database! Learn how to build smarter apps with vector search in SQL Server & Azure Cosmos DB -- no extra AI stack required.
Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demonstration of computing a matrix inverse using the Newton iteration algorithm. Compared to other algorithms, Newton iteration is simple and easy to customize, but the technique is relatively slow.
- By James McCaffrey
- 05/15/2025