(Denny Cherry) Recently on Twitter I saw a question about what index maintenance you should be doing on your ColumnStore Indexes when it comes to maintenance.
Other News
Using Background-Attachment CSS To Create A Sticky IFrame Advertising Background In JavaScript
(Ben Nadel) Over the weekend, while Googling around, I landed on a page that happened to have a Google advertisement embedded in the content copy.
The SQL Server Defensive Dozen – Part 3: Authentication and Authorization in SQL Server
(randomnote_1) In order to secure and harden SQL Server it is important to control who and/or what can authenticate to the system and what they have access to. This will satisfy regulatory needs such as the Secure Technical Implementation Guide (STIG).
Tips for using indexes in SQL Server 2017 (Part 2)
Tips for using indexes in SQL Server 2017 (Part 2) If you create a composite (multi-column) index, try to order the columns in the key so that the WHERE clauses of the frequently used queries match the column(s) that are leftmost in the index. The order of the columns in a composite (multi-column) index is very important. The index will...
Setting up Basic Master-Slave Replication in MySQL 8
(Shree Nair) Since April 19th, when MySQL 8.0 became Generally Available (GA), the MySQL community has been abuzz with excitement over all of the new features and improvements.
Integration Testing made Simple for CRUD applications with SqlLocalDB
(Tim Sommer) Using SqlLocalDB to allow simple automated Integration Testing in both greenfield and brownfield projects.
Java Lambda Streams and Groovy Clouses Comparisons
(Alex Staveley) This Blog post will look at some proverbial operations on List data structure and make some comparison between Java 8/9 and Groovy syntax.
IBM Cloud and Db2 News – August 2018 Edition
(Henrik Loeser) This Summer I have been away few days here and there. Once back, I tried to catch up with changes for IBM Cloud and its services as well as with Db2.
ASP.NET Core 2.1: Razor UI as Class Library
One of the new features of ASP.NET Core 2.1 is, Razor UI as a class library. It makes easier to build and include Razor based UI in a library and share it across multiple projects.
More on Microservice Architectures and Performance
(John Maenpaa) In last week’s article, I wrote a little about microservice architectures and how that trend can impact performance. Now, I want to dive a bit deeper into an example where an application design that used to be efficient can become overly expensive.