(Paul White) The primary changes made to Cardinality Estimation starting with the SQL Server 2014 release are described in the Microsoft White Paper Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator by Joe Sack, Yi Fang, and Vassilis Papadimos.
Community
Java Challengers #5: Sorting with Comparable and Comparator in Java
(Rafael Chinelato Del Nero) Programmers frequently need to sort elements from a database into a collection, array, or map. In Java, we can implement whatever sorting algorithm we want with any type.
HTTP/2 and ASP.NET Core MVC – Protocol based content delivery
(Tomasz Peczek) Two weeks ago I’ve given a talk at DevConf conference about HTTP/2. During that talk I’ve mentioned protocol based content delivery as potential way to optimize an application for HTTP/2 users, without degradation in performance for HTTP/1 users at the same time.
Best Practices Guide for Databases on IBM FlashSystem
(Jagadeesh Papaiah) The purpose of this document is to provide best practice guidelines to design and implement IBM FlashSystem storage for database workloads.
ASP.NET Web API Versioning Strategies
(Anoop Sharma) Web API Versioning is required as the business grows and business requirement changes with the time. As Web API can be consumed by multiple clients at a time, Versioning of Web API will be necessarily required so that Business changes in the API will not impact the client that are usi
Using Visual Studio for Cross Platform C++ Development Targeting Windows and Linux
(Marc Goodner) A great strength of C++ is the ability to target multiple platforms without sacrificing performance. If you are using the same codebase for multiple targets, then CMake is the most common solution for building your software.
MySQL Adventures: How max_prepared_stmt_count can bring down production
(Bhuvanesh) We recently moved an On-Prem environment to GCP for better scalability and availability.
Using ANT to investigate JCA adapters
(Martien van den Akker) My current customer has a SOA Suite implementation dating from the 10g era. They use many queues (JMS serves by AQ) to decouple services, which is in essence a good idea.
When Even Histograms Can’t Help
(amitzil) Here is an interesting optimizer case where updated statistics and histograms cannot solve the performance problem. This might be an uncommon case, but it happened for one of my clients and this post is the result of some research on this.
How to install Oracle Database 18c XE on Linux
(Gerald) The new version of the free Oracle Database edition, Oracle Database 18c Express Edition, just got released for Linux 64-bit.