Latches Oracle
Hello everyone, today we are going to talk about latches, an Oracle lock in memory. What are Latches? Latches provide a low-level serialization mechanism that protects shared data structures in …
Blog
SQL Server dynamic restore script
Hello everybody, today we are going to share a very useful script for server migrations and database moves. Sooner or later, database professionals have to deal with moving databases between …
Connectivity to Oracle database using TNSPING
Hello everyone, today we are going to talk about an Oracle tool that we use to know if we have connectivity with the instance of the Oracle database to which …
Oracle 12 IDENTITY Columns
Hello everyone, today we wanted to discuss with you a feature of Oracle 12.1 that is very powerful and rarely used, the IDENTITY columns. This functionality is implemented in most …
Import logs from SQL Server to RStudio
Hello everyone, today we are going to talk about how to import records from SQL Server to RStudio. For this, we will make use of the RODBC package. As its …
Count Distinct and Window Functions
In today’s example we are going to see how to solve the following error using Count Distinct and Window Functions. It is an error that we have had with some …