Fragmented or Centralized Data

Is it better to copy and distribute data or centralize it? Steve has a few thoughts today.

Data Challenges and Travel

A few problems in travel have Steve thinking about the complexities and challenges of companies that coordinate lots of data.

Protecting Data Between Services

Microsoft is shutting down HealthVault, which means that customers need to manage their records. That's a challenge for many people.

Azure DWH part 23: Data Mining

SQL Server on-premises includes a module to create Data Mining models. We will show how to create them using ASDW.

Azure DWH part 15: PolyBase and Azure Data Lake

In this article, we will learn how to query a csv file stored in the Data Lake using PolyBase.

Data Types

Data Types

DML

Data Mining Part 39: Azure Machine Learning vs Microsoft Data Mining

In earlier chapters, we talked about the Microsoft Data Mining enemies. We will talk now about Microsoft Azure Machine Learning.

Discrete and Continuous Data in SQL

Not all data is discrete; some data types represent a continuum. In SQL, we have to approximate them and live with the special problems of handling continuous data. We need to understand the problems associated with continuous data types, when these will happen, and how it affects constraints and the results of queries. Joe Celko explains.