Opinions, tips, and news orbiting Microsoft
First published on MSDN on Aug 18, 2016
Authored by Rangarajan Srirangam
Authors: Rangarajan Srirangam, Mandar Inamdar
Contributors and Reviewers: John Hoang, Sanjay Mishra, Alexei Khalyako, Soura… Continue reading Migrating data to Azure SQL Data Warehouse in practice
First published on MSDN on Aug 17, 2016
Authored by Sanjay Mishra
Reviewed By: Dimitri Furman
DBCC CHECKDB is a common database maintenance task. It can take up significant amount of system resources… Continue reading SQLSweet16!, Episode 6: DBCC CHECKDB with MAXDOP
First published on MSDN on Aug 11, 2016
Authored by Sanjay Mishra
Reviewed By: Denzil Ribeiro, Kun Cheng
Deleting all rows from a given partition is a very common operation on a partitioned table, es… Continue reading SQLSweet16!, Episode 5: TRUNCATE Selected Partitions
First published on MSDN on Aug 09, 2016
Reviewed by Panagiotis Antonopoulos, Jakub Szymaszek, Raghav Kaushik
Always Encrypted
is one of the compelling features in SQL Server 2016 and in Azure SQL DB which provid… Continue reading Using Table Valued Parameters with Always Encrypted in SQL Server 2016 and Azure SQL Database
First published on MSDN on Aug 03, 2016
Authored by Mike Ruthruff
Reviewed by: Denzil Ribeiro, Mike Weiner, Arvind Shyamsundar, Sanjay Mishra, Murshed Zaman, Peter Byrne, Purvi Shah
SQL Server … Continue reading Changes in SQL Server 2016 Checkpoint Behavior
First published on MSDN on Jul 28, 2016
Arvind Shyamsundar, Lee Woods
Reviewed by Jeff Papiez, Mike Weiner, Troy Moen, Suresh Kandoth
It has been a while now since SQL Server 2016 has been
generally availab… Continue reading Installing SQL Server 2016 RTM? You must do this!
First published on MSDN on Jul 21, 2016
Arvind Shyamsundar
Reviewed by: Gjorgji Gjeorgjievski, Sunil Agarwal, Vassilis Papadimos, Denzil Ribeiro, Mike Weiner, Mike Ruthruff, Murshed Zaman, Joe Sack
In a
… Continue reading Real World Parallel INSERT…SELECT: What else you need to know!
First published on MSDN on Jul 12, 2016
Authored by Sanjay Mishra
Sanjay Mishra, Arvind Shaymsundar
Reviewed By: Joe Sack
SQL Server 2016 has several new features with SQL Server
… Continue reading SQLSweet16!, Episode 4: SQL Server R Services makes you a smarter T-SQL Developer