(Steve Smith) Writing any significantly complex software application involves the use of encapsulation boundaries and abstractions.
Other News
Strange MongoDB Error When Incrementing A Document Property In Lucee CFML 5.2.9.31
(Ben Nadel) Yesterday, I ran into a really strange error when trying to increment a numeric value on an in-memory MongoDB document in Lucee CFML 5.2.9.31.
MySQL Encryption: Talking About Keyrings
(Robert Golebiowski) It has been possible to enable Transparent Data Encryption (TDE) in Percona Server for MySQL/MySQL for a while now, but have you ever wondered how it works under the hood and what kind of implications TDE can have on your server instance?
Beginners Guide to List of Values in Oracle APEX
(David Peake) This first in a series of blog posts on List of Values examines the different ways you can allow end users to select data from a list of allowed values.
Where does the log writer spend its time on?
(Frits Hoogland) The Oracle database log writer is the process that fundamentally influences database change performance. Under normal circumstances the log writer must persist the changes made to the blocks before the actual change is committed.
Trimming down on OCI CLI output with a query in the RC file
(Trent) Oracle Cloud Infrastructure has a command client, which leverages their REST API. One thing you can do to streamline your usage is to make use of an RC file.
Azure Data Factory Get Metadata Example
(Fikrat Azizov) In a previous post (Lookup activity), we discussed Lookup activity to read the content of the database tables or files. ADF also has another type of activity: Get Metadata activity, which allows reading metadata of its sources. We are going to explore the capabilities of this activit
SpaceVIL Framework. Cross-Platform GUI with .NET & JVM
(Roman Sedaikin) I’ll tell you about the SpaceVIL framework, its capabilities and a brief story of its creation.
Bridges Between Servers
Many times as you build out environments, you’re left pulling information from different SQL Servers and different sources, so you can assemble it in a common location. This may be the case where you’re pulling information from a SQL Server, a MySQL server, Oracle and other systems, so you can create reporting and analytics runs at the information. These bridges […]
Tips for using full-text search in SQL Server 2019
Tips for using full-text search in SQL Server 2019 Make full-text index population during periods of low database access. Because full-text index population takes some time, these updates should be scheduled during CPU idle time and slow production periods. Reduce the full-text unique key size. To create a full-text index, the table to be indexed must have a unique index....
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here