Opinions, tips, and news orbiting Microsoft
First published on MSDN on Oct 13, 2016
In 2008, SSIS team posted a blog about
loading 1TB data in 30 minutes,
and after 8 years, hardware and software are rapidly improved, now we are doing similar experiment with only on t… Continue reading Using SSIS to load 1TB data into SQL Server in 30 mins, with simplified settings
First published on MSDN on Aug 01, 2016
Different approaches to inject data into Azure SQL Data Warehouse
For the SQL Data Warehouse customers, the primary objective when migrating data is to populate their SQL Data Warehouse d… Continue reading Different approaches to inject data into Azure SQL Data Warehouse
First published on MSDN on Jul 28, 2016
Hi all,
I am pleased to announce that the SSIS 2016 PDW connector for SQL Server 2016 with AU5 is now available for download!!
https://www.microsoft.com/en-us/download/details… Continue reading SSIS 2016 PDW connector for SQL Server 2016 with AU5 is now available for download!!
First published on MSDN on Jul 22, 2016
Hi All,
We are pleased to announce that an updated version of SQL server Integration Services Feature pack for azure is available now for download. This release mainly has following… Continue reading Update for SQL server Integration Services Feature Pack for Azure with support to Azure Moon cake and New Blob Storage account
First published on MSDN on Jun 16, 2016
Hi all,
With the SSIS 2016 officially released in May 2016, I am now pleased to announce that the Microsoft Connectors 4.0 for Oracle and Teradata is also available for SSIS 2016. W… Continue reading Microsoft Connectors 4.0 for Oracle and Teradata is now available for SSIS 2016!
First published on MSDN on Apr 19, 2016
We recently released the multi-version support (also known as One Designer) in SSDT 2015, which allows SSIS developers to author, execute, deploy and debug multiple versions of SSIS package from … Continue reading Getting your SSIS custom extensions to be supported by the multi-version support of SSDT 2015 for SQL Server 2016
First published on MSDN on Mar 14, 2016
The SQL Server documentation team is working to improve the documentation, to help you be successful with and gain more value from SQL Server. Please consider taking this
… Continue reading SQL Server 2016 Documentation Survey
First published on MSDN on Mar 04, 2016
Validate XML documents and get rich error output by enabling the
ValidationDetails
property of the XML Task. For more info, see
Validate XML wi… Continue reading Validate XML with rich error output in the XML Task