Microsoft announced Entity Framework 6.3 Preview, which takes the traditional open source object-relational mapping (ORM) framework to the .NET Core space, joining Entity Framework Core as an option for leveraging the upcoming .NET Core 3.0.
Almost four years after the debut of Apache Spark, .NET developers are on track to more easily use the popular Big Data processing framework in C# and F# projects.
Need to predict the political party affiliation (democrat, republican, independent) of a person based on their age, annual income, gender, years of education and so on? Our resident data scientist Dr. James McCaffrey shows a technique that can help with that and much more -- with code!
- By James McCaffrey
- 04/10/2019
With the March update of Azure Data Studio, Microsoft added preview support of the popular PostgreSQL database, along with a new PostgreSQL extension for the Visual Studio Code editor.
Our resident doctor of data science this month tackles anomaly detection, using code samples and screenshots to explain the process of finding rare items in a dataset, such as discovering fraudulent login events or fake news items.
- By James McCaffrey
- 03/04/2019
Microsoft has beefed up several data analytics offerings in its Azure cloud platform, including the general availability of Azure Data Explorer and Azure Data Lake Storage.
The Data Science doctor delves into supporting vector machines, software systems that can perform binary classification such as creating a model to predict the gender of a person based on their age, annual income, height and weight.
- By James McCaffrey
- 03/04/2019
If you want to treat your database design as an "implementation detail" that just falls out of getting your object model right, then Entity Framework gives you four choices. Picking the right one, however, may mean creating your own.
Eric Vogel uses code samples and screenshots to demonstrate how to create and use the views and controller for an ASP.NET MVC Core CRUD application.
Microsoft announced HDInsight Tools for Visual Studio Code is now generally available, letting coders do Big Data analytics right from within the cross-platform, open source code editor.
Dr. James McCaffrey of Microsoft Research uses a full project code sample and screenshots to detail how to use Python to work with self-organizing maps (SOM), which let you investigate the structure of a set of data.
- By James McCaffrey
- 01/15/2019
Promising that developers can "save weeks of development effort," Microsoft today answered their request for database project support in Visual Studio to target Azure SQL Data Warehouse projects.
If someone tells you that LINQ doesn't support subqueries ... well, they're not wrong. But they're also not entirely correct, either. With LINQ you can meet many of the goals of SQL subqueries including the ability to build complex queries out of simpler ones.
The October release of Azure Data Studio includes preview support for SQL Server 2019 and more.
The Data Science Doctor explains how to use the reinforcement learning branch of machine learning with the Q-learning approach, providing code on how to solve a maze problem for an easy-to-understand example.
- By James McCaffrey
- 10/19/2018