SQL Server and SDS


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.

Image Classification Using Keras

Creating a custom image classification model is challenging, but the existence of neural network libraries like Keras has made it doable. Here's how, with many code samples and a full project download.

Enabling Enterprise AI for Everyone with SQL Server

Microsoft believes artificial intelligence is so powerful it should be "democratized" so organizations and developers of all types can use it to transform and improve their business practices.

ASP.NET Core: Learning the Ropes, Part 2

Eric Vogel provides many code samples to show how to use Entity Framework Core for an ASP.NET Core MVC application.

Sentiment Analysis Using Keras

Custom sentiment analysis is hard, but neural network libraries like Keras with built-in LSTM (long, short term memory) functionality have made it feasible. Step into the Data Science Lab with Dr. McCaffrey to find out how, with full code examples.

Subscribe on YouTube