Real World Parallel INSERT...SELECT: What else you need to know!
First published on MSDN on Jul 21, 2016 Arvind ShyamsundarReviewed by: Gjorgji Gjeorgjievski, Sunil Agarwal, Vassilis Papadimos, Denzil Ribeiro, Mike Weiner, Mike Ruthruff, Murshed Zaman, Joe SackIn a previous post we have introduced you to the parallel INSERT operator in SQL Server 2016.SQL Server 2016 SSIS Data Flow Buffer Auto Sizing capability benefits data loading on Clustered Columnstore tables
First published on MSDN on Feb 29, 2016 Reviewers: Joe Sack, Arvind Shyamsundar, Murshed Zaman, Sanjay Mishra The focus of this blog is to introduce SSIS changes in the Data Flow task in SQL Server 2016 that help data loading into Columnstore tables.
Bulk Insert causing duplicates in target table
We use ETL tool(C# based) which uses Bulkcopy method to do bulk insert to target table. Recently we are facing 2 Issues in our daily loads 1. Target table with no primary key - the load returns success but it inserts 5x times of the same record. It loads same records 5 times. 2. Target table with Primary Key - The load returns failure with primary key constraint but it inserts the rows into target table. DBA Team is unable to find anything in there logs ,So I am confused why this error occurs. This occurs daily in 10% of the jobs and once you rerun after 2-3 hrs the same job finishes successfully without above mentioned issues. Please suggest how can I debug this issue.Checkpoint process for memory-optimized tables in SQL 2016 and implications on the log
First published on MSDN on May 20, 2016 Reviewed by: Alejandro Saenz, Jos de Bruijn; Joe Sack, Mike Weiner,Kun Cheng, Raghavendra TK A durable memory-optimized table (created as SCHEMA_AND_DATA) will have it’s transactions recorded into the transaction log so that on failure, recovery is possible.Using SQL Always Encrypted with Azure Web App Service
First published on MSDN on Sep 15, 2016 Reviewed by: Dimitri Furman, Jakub Szymaszek, Sanjay Mishra, Kun Cheng, Mike RuthruffBackgroundA common scenario today involves migrating a web application (based on IIS) and the on-premises SQL Server database to either Azure SQL DB or Azure SQL VM.SharePoint 2016 Named Pipes
Setting up an on-premises multi-server SharePoint 2016 farm and having problems with servers disconnecting from the SQL Server 2016 database. Lots of messages in the ULS logs about Named Pipes Provider, error: 40 - Could not open a connection to SQL Server. We are using TCP/IP on default port 1433, and I've tried with and without SQL Aliases. Does the Named Pipes protocol need to be enabled on the MSSQLSERVER network configuration? This wasn't the case for SharePoint 2010 and SQL Server 2008 R2.Using Table Valued Parameters with Always Encrypted in SQL Server 2016 and Azure SQL Database
First published on MSDN on Aug 09, 2016 Reviewed by Panagiotis Antonopoulos, Jakub Szymaszek, Raghav KaushikAlways Encrypted is one of the compelling features in SQL Server 2016 and in Azure SQL DB which provides a unique guarantee that data in the database cannot be viewed, accidentally or intentionally by users who do not have the ‘master key’ required to decrypt that data.
