Operationalize your machine learning project using SQL Server 2016 SSIS and R Services

With the release of CTP3 SQL Server 2016 and its native In-database support for the open source R language (SQL Server R Services), users can now call both R and RevoScaleR functions and scripts directly from within a SQL query and benefit from multi-threaded and multi-core in-DB computations. The R integration brings the utility of…


Error Column Improvements for SSIS Data Flow (Updated for RC2)

Most of the SSIS data flow components allow customers to log the rows with errors to a dedicated error output, which can help customers to investigate and diagnose the root cause of the error. Error output has two 4-byte int columns (ErrorCode and ErrorColumn), which indicate the error code and the id of the error column….


SQL Server Data Tools (SSDT) Preview update for August 2015 is available for download

 This release is the first in the following ways: 1.First release of SSDT that includes all the BI tools like IS, AS, RS (AS/RS will come later) 2.First release of IS designer public preview for sql server 2016. 3.First release of IS designer that is independent from AS/RS installation. 4.First lighter weight installer instead of…