Autonumerics: get the latest embedded in Oracle, MySQL, and SQL Server
Hi friends!!! In today’s post we are going to work with Autonumerics in Oracle, MySQL and SQL Server . We will see how to obtain the last value of the …
Replication in SQL Server: max text repl size
Hello everyone. In today’s post we are going to see how to increase the value of max text repl size in SQL Server. This value is specific to replication in …
Change location of control files in Oracle
Hello everyone, we are going to comment on one of the actions that as DBAs we are going to have to perform sometime if we work in database environments Oracle …
SQL Server 2019 Indexes
Hi again, everybody! Today we are going to see a feature of SQL Server 2019 regarding indexes. We will see how to use it and how it can be useful …
Cloning from dbca in command mode
Hello everyone, how are you doing? Today we are going to talk again about a feature of Oracle 19c that can be useful when creating new databases. This functionality allows …
Automatic Indexing. New Oracle functionality
Hello everyone. Today we are going to talk about a new feature of Oracle 19c that we believe can be very useful. The functionality is called Automatic Indexing and is …