(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.
Other News
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).
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.
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.
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.
Thoughts On The New Power Query Source In SSIS
(Chris Webb) Yet more evidence that Power Query is taking over the world: there’s a new Power Query data source for SQL Server Integration Services in the latest version of SSDT. Here’s the blog post announcing it (the actual announcement is halfway through):
Database Models and Relational Algebra – Part 5
THE RELATIONAL CALCULUS In relational calculus, a query is conveyed as a formulary plan which contains a number of variables as well as an expression concerning these variables. It is up to the Database Management System (DBMS) to convert these non – technical queries into the same, well-organized, effective and procedural queries. The concept of relational calculus was first planned...
.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.
When Will My SQL Server Online Resumable Index Rebuild or Create Operation Complete?
(Greg Larsen) Have you ever wondered how much progress SQL Server has completed while rebuilding or creating an online resumable index?