Category Archives: SQL Server

Introduction to R Services and R client – SQL Server 2016

Introduction After some time using R and SQL server as two different tools (not 100% true because I already have imported data from SQL Server into R Studio), now Microsoft is offering as part of the SQL Server 2016 R … Continue reading

Posted in Analytics, Business Intelligence, R, SQL Server | Tagged , , , | 1 Comment

Export data to Hadoop using Polybase – Insert into external table

Introduction This post is a continuation of Polybase Query Service and Hadoop – Welcome SQL Server 2016 One of the most interesting use cases of Polybase is the ability to store historical data from relational databases into a Hadoop File System. … Continue reading

Posted in Big Data, hadoop, SQL Server | Tagged , , , , | 14 Comments

Polybase Query Service and Hadoop – Welcome SQL Server 2016

Introduction One of the coolest features of SQL Server 2016 is Polybase. Already available for Parallel Data Warehouse, this functionality is now integrated in SQL Server 2016 and allows to combine relational and non-relational data, for example, query data in … Continue reading

Posted in Big Data, Business Intelligence, Data Processing Engines, hadoop, SQL Server | Tagged , , , | 2 Comments

Deploy SSIS Packages across servers

Background Recently I had to deploy a set of SSIS packages stored in the msdb of a development server into a test server. I should mention that a SSIS package could be stored in the file system, in a package … Continue reading

Posted in Business Intelligence, SQL Server | Tagged , , , | 3 Comments

Store file names and modified dates in a table without a Foreach Loop Task – SQL Server – SSIS

Last week I received a request from the project manager. I had to improve the performance of an SSIS package that reads a collection of files from a source folder, and then stores their name, extension, location and modified date. … Continue reading

Posted in Business Intelligence, SQL Server | Tagged , , , , | 4 Comments