SQL Server and SDS


Blue Squares Floating Small

Weighted k-Nearest Neighbors Regression Using C#

The main advantages of KNNR are simplicity and interpretability, says Dr. James McCaffrey of Microsoft Research in presenting this full-code, step-by-step tutorial.

Microsoft Previews 'Python in Excel'

Integrating the data science darling programming language with the super-popular spreadsheet program means analysts will no longer have to jump through so many workaround hoops or use third-party add-ins.

Kernel Ridge Regression Using C#

KRR is especially useful when there is limited training data, says Dr. James McCaffrey of Microsoft Research in this full-code, step-by-step tutorial.

New Microsoft Sandbox Uses Natural Language LLMs for SQL Queries

The open source project lets developers and data pros to use its Semantic Kernel SDK to experiment and test the abilities of LLMs to generate SQL queries based on natural language expressions.

Linear Ridge Regression Using C#

Implementing LRR from scratch is harder than using a library like scikit-learn, but it helps you customize your code, makes it easier to integrate with other systems, and gives you a complete understanding of how LRR works.

Gaussian Process Regression Using the scikit Library

Dr. James McCaffrey of Microsoft Research offers a full-code, step-by-step tutorial for this technique, especially useful when there is limited training data.

SQL Server 2022: Ledger, DDM and T-SQL Enhancements

While ledger is a game-changer for security, SQL Server 2022 also introduced new functionality around Dynamic Data Masking (DDM), T-SQL enhancements and more.

Nebula

Regression Using scikit Kernel Ridge Regression

Dr. James McCaffrey of Microsoft Research presents a full-code, step-by-step tutorial on this regression technique, which is especially useful when there is limited training data.

Space

Binary Classification Using a scikit Neural Network

Machine learning with neural networks is sometimes said to be part art and part science. Dr. James McCaffrey of Microsoft Research teaches both with a full-code, step-by-step tutorial.

Even SQL Server Developer Tools Gets an AI Copilot

Microsoft, apparently trying to enhance every product it has with an AI-powered Copilot, announced a new one for the latest release of SQL Server Developer Tools (SSDT) in Visual Studio.

Microsoft Deep Learning Alternative: On-Device Training for ONNX Runtime

"As opposed to traditional deep learning (DL) model training, On-Device Training requires efficient use of compute and memory resources."

Gaussian Naive Bayes Classification Using the scikit Library

Dr. James McCaffrey of Microsoft Research says the main advantage of using Gaussian naive Bayes classification compared to other techniques like decision trees or neural networks is that you don't have to fine tune model parameters.

.NET 8 Preview 4 Boosts Native AOT, Blazor 'Streaming Rendering'

Microsoft's fourth preview of .NET 8 continues to boost native native Ahead-of-Time (AOT) compilation, while Blazor gets streaming component rendering.

Classification Using the scikit k-Nearest Neighbors Module

Dr. James McCaffrey of Microsoft Research uses a full-code, step-by-step demo to predict the species of a wheat seed based on seven predictor variables such as seed length, width and perimeter.

Regression Using a scikit MLPRegressor Neural Network

Dr. James McCaffrey of Microsoft Research uses a full-code, step-by-step demo to show how to predict the annual income of a person based on their sex, age, state where they live and political leaning.

Subscribe on YouTube