(Greg Larsen) Have you ever wondered how much progress SQL Server has completed while rebuilding or creating an online resumable index?
Community
Java 12: New Features and Enhancements Developers Should Know
(Jazmine Llaguno) Oracle will soon roll out Java 12 in March 2019 and new releases will drop once every six months thereafter. The goal is to make new releases more frequent for the Java ecosystem, with certain releases earmarked as long-term support (LTS).
Creating Shortcuts By Mapping Multiple Routes On To The Same View-Component In Angular 7.2.5
(Ben Nadel) Earlier this week, I took a look at using wild card routes to create shortcuts in an Angular 7.2.5 application. That first approach worked; but, it required me to manually parse some of the more complex shortcuts using Regular Expression.
.NET Core Opinion 10 – Move More Code Out of Startup
(K. Scott Allen) In a previous opinion, we looked at the responsibilities of the Startup class in ASP.NET Core. A consistent problem I run across in code reviews is the amount of code that gravitates into the Startup class, making the entire file cluttered and not well factored.
Redirect Code in .NET Core
(Peter Vogel) There are four Redirect help methods built into your .NET Core Controllers that you can use to tell a client that a resource exists … but not at this URL.
SQL SERVER – Cannot Drop the Assembly ‘ISSERVER’, Because it Does not Exist or You do not Have Permission
(Pinal Dave) As they say – There are more ways than one to skin a cat. In this blog we will find another method to fix an error which you might see during SQL upgrades – Cannot drop the assembly ‘ISSERVER’, because it does not exist or you do not have permission.
Binary log encryption at rest
(João Gramacho) Starting in version 8.0.14, MySQL server can encrypt all new binary and relay log files on disk. In order to do so, you just need to enable the new binlog_encryption option (and also ensure that you have a keyring).
Oracle ASM and Thin Provisioning – How To Reclaim Space
(Chris Buckel) It came to my attention last November that I had crossed the one year anniversary since my last post on flashdba.com. I was so surprised that I immediately decided to write a new post, which took another three months.
Unique Indexes Force Hints To Be “Ignored” Part I (What’s Really Happening)
(Richard Foote) As I was compiling my new “Oracle Diagnostics and Performance Tuning” seminar, I realised there were quite a number of indexing performance issues I haven’t discussed here previously.
Partitioning — 13c : Merging Partitions
(Hemant K Chitale) The reverse of SPLITting a Partition is to MERGE two adjacent partitions.