SQL Server and SDS


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.

Two New Features in SQL Server Management Studio

Microsoft has updated its SQL Server Management Studio to version 17.3, adding two features along with various minor enhancements and bug fixes.

Microsoft, AWS Team Up for 'Gluon' Deep Learning Library

The new joint project provides an open source deep learning library "to more easily and quickly build machine learning models without compromising training performance."

Build Your DOM Additions with Angular and TypeScript

Here’s how, in Angular, you can use directives to dynamically modify HTML in Views without polluting your business logic.

Neural Network L2 Regularization Using Python

Our data science expert continues his exploration of neural network programming, explaining how regularization addresses the problem of model overfitting, caused by network overtraining.

SQL Server 2017 Debut Highlights Ignite Conference

SQL Server 2017 will officially hit general availability on Oct. 2, Microsoft announced today at its Ignite conference in Orlando, Fla.

How Microsoft Graph Provides an 'Internet of Your Things'

It can't help with your teen's geometry homework, but it can make your life as a developer in the Microsoft ecosystem much easier, said Microsoft exec Mark Stafford, who explained just how that works in today's Visual Studio Live! keynote address in Chicago.

Working with JSON in SQL Queries

SQL Server 2016 lets you treat JSON objects like rows in a table, allowing you to use data from AJAX queries in joins, updates and any other SQL statement you can think of.

What's New with Python in the Latest Visual Studio Preview

Just before Stack Overflow deemed it the "fastest-growing major programming language," Microsoft conveniently detailed updates for using Python in the new Visual Studio 15.4 Preview 1.

Angular Q&A: Components, Getting-Started Tips (and that 'Total Rewrite' Thing)

Noted database expert and author Ted Neward discusses his favorite features of Angular and explains how to get started with the popular platform for building Web, mobile Web, mobile native and desktop apps.

Subscribe on YouTube