SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships.
Here's how you can use SQL Server's OpenJson function to dismantle JSON structures into relational tables targeting either transactional systems or data warehouses.
The new Entity Framework Core 6.0 Preview 4 is described as a "performance edition," with the dev team turning from years-long concerns -- such as catching up to the old Entity Framework and adding new features -- to focus on speed.
Dr. James McCaffrey of Microsoft Research provides a code-driven tutorial on PUL problems, which often occur with security or medical data in cases like training a machine learning model to predict if a hospital patient has a disease or not.
- By James McCaffrey
- 05/21/2021
Dr. James McCaffrey of Microsoft Research provides full code and step-by-step examples of anomaly detection, used to find items in a dataset that are different from the majority for tasks like detecting credit card fraud.
- By James McCaffrey
- 04/13/2021
When training data won't fit into machine memory, a streaming data loader using an internal memory buffer can help. Dr. James McCaffrey of Microsoft Research shows how.
- By James McCaffrey
- 04/01/2021
Microsoft's data dev team recently shipped Entity Framework Core 6.0 Preview 2, which comes a couple months after a survey surprised them with indications many developers are sticking with tech that can be more than 10 years old.
Dr. James McCaffrey of Microsoft Research explains how to evaluate, save and use a trained regression model, used to predict a single numeric value such as the annual revenue of a new restaurant based on variables such as menu prices, number of tables, location and so on.
- By James McCaffrey
- 03/12/2021
The goal of a regression problem is to predict a single numeric value, for example, predicting the annual revenue of a new restaurant based on variables such as menu prices, number of tables, location and so on.
- By James McCaffrey
- 03/03/2021
The Entity Framework Core 6 dev team shipped Preview 1 this week, headed toward a debut with the larger, unifying .NET 6 umbrella platform in November.
Dr. James McCaffrey of Microsoft Research presents the second of four machine learning articles that detail a complete end-to-end production-quality example of neural regression using PyTorch.
- By James McCaffrey
- 02/11/2021
VS Code's popularity in the data science camp was revealed in a survey by Kaggle, a Google subsidiary that fosters an online community of data scientists and machine learning practitioners.
Dr. James McCaffrey of Microsoft Research presents the first in a series of four machine learning articles that detail a complete end-to-end production-quality example of neural regression using PyTorch.
- By James McCaffrey
- 02/02/2021
Dr. James McCaffrey of Microsoft Research continues his four-part series on multi-class classification, designed to predict a value that can be one of three or more possible discrete values, by explaining model accuracy.
- By James McCaffrey
- 01/25/2021
Microsoft outlined its plan for Entity Framework Core 6, which in November will take its place as the data access component of the landmark .NET 6, a long-term support (LTS) release that will mark Microsoft's transition from the Windows-only .NET Framework to an open source, cross-platform umbrella offering of all things .NET.