Robin Lester
A blog about data
Creating a Document's Keyword Wordcloud with Azure Cognitive Services and R
In this post we will look at how to utilize the Azure Cognitive Services APIs from R to add this...
Author: RobinLester Date: 09/21/2017
SQL Server to Azure SQL Database data movement options and considerations with changing schemas and triggered refreshes
In this post we will look at the problem where we need to move the data at irregular intervals from...
Author: RobinLester Date: 08/04/2017
Data Factory Scheduling
Often questions arise on how to correctly schedule Azure Data Factory pipelines. In this post we...
Author: RobinLester Date: 04/29/2017
Azure Data Factory - using a Stored Procedure as a destination
Azure Data Factory allows data to move from a multitude of sources to a multitude of destinations. A...
Author: RobinLester Date: 04/03/2017
Improving query performance with OPTION (RECOMPILE), Constant Folding and avoiding Parameter Sniffing issues
OPTION (RECOMPILE) when used in the correct manner can give a performance boost though Constant...
Author: RobinLester Date: 08/10/2016
Index Maintenance - Fragmentation should not be your only concern
Index fragmentation is not the only consideration when constructing an index maintenance plan. This...
Author: RobinLester Date: 08/04/2016
Getting started with Hortonworks 2.4 in Hyper-V
Currently there is no 2.4 Hortonworks sandbox available for Hyper-V. If like me you spend a lot of...
Author: RobinLester Date: 07/26/2016
Page Compression and the 4038 Length Limitation
While it is well documented that when applying page compression to a table only in-row data will be...
Author: RobinLester Date: 06/07/2016
An Introduction to U-SQL in Azure Data Lake - Part 2
There has been a certain amount of speculation on what the U in U-SQL stands for. Some have...
Author: RobinLester Date: 05/25/2016
Architecting a Big Data Project in Azure
The aim of this post is to give a very brief overview of the technologies in Azure that can comprise...
Author: RobinLester Date: 03/09/2016
SQL Checkpoint Scaling Observations
A recap on what a checkpoint does Essentially a checkpoint operation writes dirty pages to disk....
Author: RobinLester Date: 03/05/2016
An Introduction to U-SQL in Azure Data Lake
Azure Data Lake Analytics is a Big Data analytics service. It differs from HDInsight principally in...
Author: RobinLester Date: 01/04/2016