(Anthony Giretti) As part of an ASP.NET Core 2.1 application, middleware makes up the processing chain (pipeline) of HTTP requests. They interact on the response and the HTTP request.
Community
Data Masking: An Imperative for Compliance and Governance
(Craig S. Mullins) For those who do not know, data masking is a process that creates structurally similar data that is not the same as the values used in production.
Generate A Java Thread Dump Programmatically Using ColdFusion
(Ben Nadel) As I’ve been getting used to managing an application within a larger, Kubernetes (K8) based platform, I’ve found myself needing to do much more programmatic introspection of the ColdFusion application and its underlying JVM (Java Virtual Machine).
Adding Blazor to Existing HTML+JavaScript Pages
(Peter Vogel) If you’re thinking about Blazor at all, you have to be wondering if it’s possible to integrate Blazor into existing pages.
SQL SERVER – Script level upgrade for database ‘master’ failed because upgrade step msdb110_upgrade.sql encountered error 926, state 1, severity 25
(Pinal Dave) I have helped many clients in upgrade failures via my On-Demand consulting and I am amazed to see various ways which can break SQL Server upgrade.
Persistence of autoinc fixed in MySQL 8.0
(Fernando Laudares Camargos and Trey Raymond) The release of MySQL 8.0 has brought a lot of bold implementations that touched on things that have been avoided before, such as added support for common table expressions and window functions.
‘Hidden’ Efficiencies of Non-Partitioned Indexes on Partitioned Tables Part III” (Ricochet)
(Richard Foote) In Part I and Part II of this series, we looked at how Global Indexes can effectively perform “Partition Pruning” when the partition keys are specified in SQL predicates, by only using those index entries that have a Data Object of interest stored within the index Rowids.
Running orachk as part of TFA with support tools bundle
(Martin Bach) I have previously written a number of posts about OSWatcher integration in Tracefile Analyzer (TFA) w/support tools bundle (available from My Oracle Support Document ID 1513912.1).
SQL data classification – Add sensitivity classification in SQL Server 2019
(Rajendra Gupta) SQL Server 2019 offers powerful new features to help in safeguarding your data and complying with various privacy regulations, which we’ll be covering in this article
How to Aggregate an Archive Log’s Deltas into a Snapshot with SQL
(lukaseder) A customer of my popular SQL training (which you should book!) has recently challenged me to optimise a hierarchical query that merges an archive log’s deltas in order to obtain a snapshot of some record at a given point in time.