Being MVP for the #11 straight year is something unique! Thank you!
The first week of July has just started. So oficially we have started vacations and the team has already plans to attend Data Platform Summit in Bangalore in August (more here).
But now let’s dig to some very good articles.
Loading partitions incrementally using SSIS
Well, partitioning could be a tough task. In this article it has been discussed that sometimes it is not practical to load partitions completely especially if you have the partition very big.
Tips for Better Presentations
Last week I have shown you an excellent post written by Peter Myers about how ti be a recognizable speaker. This time I have found Brent‘s post about doing better presentations.
What’s new in SQL Server 2019 preview
SQL Server 2019 CTP 3.1 is now available for download. There is a lot about big data clusters but I like that you see recommendation for MaxDOP and Max Server Memory during setup
Public Preview of Shortest Path on SQL Server 2019
Use SHORTEST_PATH inside MATCH to find the shortest path between any 2 nodes in a graph or to perform arbitrary length traversals. Great introductory blog post with an explanation
Updating Statistics on Secondary Replicas of the Availability Groups
Niko did a great job explaining in details this not-so trivial topic!
At the end – End of support is coming for #SQLServer 2008 and 2008 R2. Explore the reasons why you should upgrade: http://msft.social/igk0Ga
Cheers,
Damian