Dino Esposito explains JSON-to-rowset native support in SQL Server 2016 and provides a realistic perspective of data query when you have JSON data stored in the database.
- By Dino Esposito
- 01/23/2018
The lightweight, cross-platform offering combines functionality found in tools like SQL Server Management Studio and the Visual Studio Code editor in order to help data developers and operations pros work with SQL Server, Azure SQL Database and Azure SQL Data Warehouse on Windows, Mac or Linux machines.
Microsoft has shipped a new release for R Open -- its enhanced distribution of the open source R programming language -- along with a release candidate for its latest TypeScript edition.
The data doctor continues his exploration of Python-based machine learning techniques, explaining binary classification using logistic regression, which he likes for its simplicity.
- By James McCaffrey
- 01/08/2018
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.
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.
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.
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.
- By James McCaffrey
- 12/05/2017
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.
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.
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.
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.
Automatic tuning assisted by artificial intelligence will be enabled by default for the Azure SQL Database service starting early next year.
Our resident data scientist explains how to train neural networks with two popular variations of the back-propagation technique: batch and online.
- By James McCaffrey
- 10/31/2017
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.