SQL Server and SDS


Logistic Regression Using Python

The data doctor continues his exploration of Python-based machine learning techniques, explaining binary classification using logistic regression, which he likes for its simplicity.

VS Code Tool Integrates with Azure Data Lake for Big Data Analytics

Microsoft updated its Visual Studio Code extension for working with the Azure Data Lake for Big Data analytics in the cloud, furthering integration of the extension's data exploration tool among other new features and improvements.

Managing Temporal Data in SQL Server 2016 and Azure SQL Database

SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of the history of your data. Here's how to retrieve that historical data.

Tracking History in SQL Server 2016 and Azure SQL Database

SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of changes to your data. Here's how to both create those tables and alter existing tables so they track the history of your data.

Neural Network L1 Regularization Using Python

The data science doctor continues his exploration of techniques used to reduce the likelihood of model overfitting, caused by training a neural network for too many iterations.

New for VS Code: Support for JUnit, HDInsight PySpark, Python and R for Azure Data Lake

Microsoft's Visual Studio Code team ships new releases monthly, but new features are also continually being provided via other means, such as extensions. Here's a look at some brand-new functionality just announced this week.

New Realm .NET Caters to Mobile Dev Platform's 'Fastest Growing Segment'

Realm has boosted the Microsoft stack capabilities of its mobile development platform, catering to C# coders and .NET developers, who constitute the platform's fastest growing segment of users.

Retrieving and Updating JSON Objects in SQL Server 2016

With SQL Server 2016, you can store JSON objects in your rows. Here’s how to work with JSON objects, including how to update them once you’ve found them.

Building the Object Model You Want with Entity Framework

When it comes to inheritance, relational database theory and object-oriented programming have more in common than you might think. Understanding that overlap is critical in designing the object model that will generate the database design your application needs.

AI-Based Automatic Tuning Is New Default for Azure SQL Database

Automatic tuning assisted by artificial intelligence will be enabled by default for the Azure SQL Database service starting early next year.

Neural Network Batch Training Using Python

Our resident data scientist explains how to train neural networks with two popular variations of the back-propagation technique: batch and online.

Microsoft Updates R Distro for Big Data Analytics

Microsoft R Open, the company's enhanced, open source distribution of the R programming language especially suited for Big Data statistical analysis and data science, has been upgraded.

Microsoft Updates Entity Framework, Even as EF Core Ascends

Microsoft shipped a new release of the nine-year-old Entity Framework object/relational mapper (O/RM) runtime even as it cedes mindshare to the newer, lightweight, open source and cross-platform version, Entity Framework Core.

Tool for VS Code Enables Serverless, SQL-Based Big Data Analytics on Azure Cloud

New extension fosters analytics of various types of data stored in the Azure Data Lake using U-SQL, a blend of declarative SQL and imperative C#.

Querying JSON Data in SQL Server 2016

With SQL Server 2016, it now makes sense to store JSON objects in your database (even though there’s no JSON datatype). Here’s how to query JSON properties to find the rows you want.

Subscribe on YouTube