SQL Server and SDS


Matrix Inverse Using Cayley-Hamilton with C#

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.

Linear Support Vector Regression Using C# with Particle Swarm Training

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.

Empowering AI Applications with Vector Search in SQL Server and Azure Cosmos DB

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.

Matrix Inverse Using Newton Iteration with C#

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.

Linear Regression with Two-Way Interactions Using C#

Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demonstration of linear regression with two-way interactions between predictor variables. Compared to standard linear regression, which predicts a single numeric value based only on a linear combination of predictor values, linear regression with interactions can handle more complex data while retaining a high level of model interpretability.

Next-gen SQL Projects with Microsoft.Build.Sql

SQL development is evolving fast, and Microsoft's Drew Skwiers-Koballa will explain it all in a featured session at the VS Live! @ Microsoft HQ developer conference being held at the company's Redmond campus in August.

Nadaraya-Watson Kernel Regression Using C#

Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demonstration of Nadaraya-Watson kernel regression using the C# language. NW kernel regression is simple to implement and is especially effective for small datasets.

Linear Support Vector Regression from Scratch Using C# with Evolutionary Training

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 simple techniques, and so evolutionary optimization training is used.

Neural Network Quantile Regression Using C#

Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demonstration of neural network quantile regression. The goal of a quantile regression problem is to predict a single numeric value with an assurance such as, "The predicted y value is 0.6789 and there's roughly a 90% chance the prediction will be greater than or equal to the true y value."

Poisson Regression Using C#

Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demo of Poisson regression, where the goal is to predict a count of things arriving, such as the number of telephone calls received in a 10-minute interval at a call center. When your source data is close to mathematically Poisson distributed, Poisson regression is simple and effective.

Naive Bayes Regression Using C#

Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demonstration of the naive Bayes regression technique, where the goal is to predict a single numeric value. Compared to other machine learning regression techniques, naive Bayes regression is usually less accurate, but is simple, easy to implement and customize, works on both large and small datasets, is highly interpretable, and doesn't require tuning any hyperparameters.

Random Neighborhoods Regression Using C#

Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demonstration of the random neighborhoods regression technique, where the goal is to predict a single numeric value. Compared to other ML regression techniques, advantages are that it can handle both large and small datasets, and the results are highly interpretable.

Get Started Using .NET Aspire with SQL Server & Azure SQL Database

Microsoft experts are making the rounds educating developers about the company's new, opinionated, cloud-ready stack for building observable, production ready, distributed, cloud-native applications with .NET.

Gradient Boosting Regression Using C#

Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demonstration of the gradient boosting regression technique, where the goal is to predict a single numeric value. Compared to existing library implementations of gradient boosting regression, a from-scratch implementation allows much easier customization and integration with other .NET systems.

VS Code Python Devs Get 'Full' Language Server Mode for Pylance

Serving tens of millions of developers, Microsoft's dev team for Python in Visual Studio Code shipped a new release with three major new features, including a "full" language server mode for Pylance, which provides language-specific "smarts," including IntelliSense.

Subscribe on YouTube