SQL Server and SDS


Purple Blue Nebula Graphic

How to Compute Disorder for Machine Learning Decision Trees Using C#

Using a decision tree classifier from a machine learning library is often awkward because it usually must be customized and library decision trees have many complex supporting functions, says resident data scientist Dr. James McCaffrey, so when he needs a decision tree classifier, he always creates one from scratch. Here's how.

C#, .NET and SQL Server Make List of Top In-Demand Programming Skills

Microsoft-centric technologies are featured prominently in a new examination of the top in-demand programming skills published by careers site Dice.com.

Blue Speed Lines Blurred Graphic

How to Do Machine Learning Perceptron Classification Using C#

Dr. James McCaffrey of Microsoft Research uses code samples and screen shots to explain perceptron classification, a machine learning technique that can be used for predicting if a person is male or female based on numeric predictors such as age, height, weight, and so on. It's mostly useful to provide a baseline result for comparison with more powerful ML techniques such as logistic regression and k-nearest neighbors.

Blue Kelp Image

Microsoft Data Analysis: .NET for Jupyter Notebooks, DataFrame for .NET

With the maturation of the open-source, cross-platform .NET Core initiative, Microsoft has been upping its data science analysis tooling lately, previewing .NET Core with Jupyter Notebooks functionality and a DataFrame type for .NET for easier data exploration.

Research Says SQL Server Faster on Azure than on AWS

Research firm GigaOm compared throughput performance between SQL Server on Azure Virtual Machines and SQL Server on AWS EC2, finding the former enjoyed a definite speed edge.

Microsoft Ships Entity Framework Core 3.1 and Entity Framework 6.4

As with .NET Core 3.1, these are relatively uneventful shipments -- most notable for long term support (LTS) licensing -- without a bunch of fancy new features or functionality included, as the dev teams focused on firming up existing code.

Blue Speed Lines Blurred Graphic

Solution Architect Details What's New in Entity Framework Core 3

Solution Architect Jim Wooley details the ins and outs of Entity Framework 3.0 -- with an emphasis on breaking changes -- in a presentation at the Live! 360 conference in Orlando.

How to Do Naive Bayes with Numeric Data Using C#

Dr. James McCaffrey of Microsoft Research uses a full code sample and screenshots to demonstrate how to create a naive Bayes classification system when the predictor values are numeric, using the C# language without any special code libraries.

Visual Studio Code SQL Server Tool Gets IntelliCode, Object Explorer

The mssql extension for Visual Studio Code, used to support SQL Server connections and T-SQL editing, has been updated with IntelliCode functionality and a new Object Explorer, among other new features.

Microsoft Details LINQ Overhaul in New Entity Framework Core 3.0

The new Entity Framework Core 3.0 GA release includes a new LINQ implementation that Microsoft explained in an announcement post.

Release Candidates Out for Entity Framework Core 3.0 and Entity Framework 6.3

After shipping Preview 9 versions of Entity Framework Core 3.0 and Entity Framework 6.3 a couple weeks ago and saying, "These are the last planned previews before we release the final versions later this month," Microsoft this week belied that with new Release Candidate builds.

Entity Framework Core 3.0 Finalized, LINQ Workarounds Published

As with other "Core 3.0" products, Entity Framework is basically done at this point as the big final release is less than two weeks away, and Microsoft has provided some workarounds for the problematic LINQ implementation in the new and final preview.

Previews Released for Entity Framework Core 3.0 and Entity Framework 6.3

Microsoft has shipped the eighth previews for Entity Framework Core 3.0 and Entity Framework 6.3, with the dev team continuing its efforts to revamp problematic LINQ functionality.

How to Update Members of a Collection with LINQ

Sometimes it's just cool to take a walk through some technology to find all the different ways you can solve a problem -- sort of "Fun with the .NET Framework." Here's a look at all the ways that Peter could think of to update an object in a collection ... some of which may be foolish.

How To Code Modern Neural Networks Using Python and NumPy

Data scientist Dr. James McCaffrey begins a series on presenting and explaining the most common modern techniques used for neural networks, for which over the past couple of years there have been many small but significant changes in the default techniques used.

Subscribe on YouTube