(Bill Vientos) Are you using IBM’s Authority Collection tool to find possible security exposures? If not, you should be! Now you can use IBM Db2 Web Query to quickly and easily analyze the large amount of collection detail.
Other News
Ineffective Java
(Ashley Frieze) Perhaps I can be replaced by a robot for code review. There are some bits of feedback I find myself giving over and over again. Here are some of my least favourites:
Dynamically Loading Assemblies at Runtime in RazorPages
(Rick Strahl) I’ve been working on some standalone tools that are generically serving static content as well as ASP.NET Core content from an arbitrary folder.
CRUD Using GRPC, EF Core, And ASP.NET Core (Part – 2)
(Bipin Joshi) In Part -1 of this article you created EmployeeCRUD service definition using Protocol Buffer language. The EmployeeCRUD.proto file and EF Core model is now ready.
Safe Navigation Operator Works In Comparison Expression Even When NULL In Lucee CFML 5.3.3.62
(Ben Nadel) While there is a version of the Lucee CFML syntax that treats null as a first-class citizen, null has, historically, been a tricky value to work with in the ColdFusion world.
Save Space on MySQL data with Column Compression
(Aakash Muthuramalingam) Recently, One of our client reached our Remote DBA team with a requirement to reduce the size of the table as it is having many text columns with huge number of records.
Ansible tips’n’tricks: executing a loop conditionally
(Martin Bach) When writing playbooks, I occasionally add optional tasks. These tasks are only executed if a corresponding configuration variable is defined. I usually define configuration variables either in group_vars/* or alternatively in the role’s roleName/default/ directory.
Impact of Force Logging
(Bobby Durrett) I am working on upgrading an Oracle database from 11.2.0.4 to 19c and migrating it from HP Unix to Linux. This 15-terabyte database is too large to copy from the old to the new system during our normal weekend downtime window.
SQL Developer Web Updates for Oracle Autonomous Database
(Jeff Smith) As of this past Friday, the 15th of November, the ORDS tier portion of Oracle Autonomous Database (Serverless) – which covers both the commercial and Always Free versions of both Data Warehouse and Transaction Processing shapes, was updated to version 19.2.1.
SQL SERVER – Getting Second Row from Table
(Pinal Dave) The other day during one of my old clients sent me an email about if I know any trick to get the second row from the resultset. I know why he was asking this question as I had worked with him before Comprehensive Database Performance Health Check.