SQL Server and SDS


Entity Framework Core 3.0 Dev Team Struggles with LINQ in Preview 6

Entity Framework Core 3.0 Preview 6 is out, with the development team including an incomplete LINQ implementation marked by temporary limitations and intentional breaking changes, needed before it proceeds further.

In the Era of .NET Core, Microsoft Revamps SQL Server Data Access

Microsoft announced a new data access driver for SQL Server that should be the path forward for data developers in the era of .NET Core.

Naive Bayes Classification Using Python

Dr. James McCaffrey of Microsoft Research uses Python code samples and screenshots to explain naive Bayes classification, a machine learning technique used to predict the class of an item based on two or more categorical predictor variables, such as predicting the gender (0 = male, 1 = female) of a person based on occupation, eye color and nationality.

Microsoft Takes Entity Framework 6 to .NET Core

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.

'.NET for Apache Spark' Debuts for C#/F# Big Data

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.

Weighted k-NN Classification Using Python

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!

Azure Data Studio and VS Code Power Up PostgreSQL

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.

Neural Anomaly Detection Using Keras

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.

Azure Data Explorer Heads Microsoft Cloud Analytics Updates

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.

Support Vector Machines Using Accord.NET

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.

Creating the Right Database Initializer for Entity Framework

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.

ASP.NET Core: Learning the Ropes, Part 3

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.

Visual Studio Code Gets HDInsight Tools for Big Data Analytics

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.

Self-Organizing Maps Using Python

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.

Developers Request, and Get, Database Project for SQL Data Warehouse in Visual Studio

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.

Subscribe on YouTube