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 …
OCI CLI: Installation and configuration on Linux
Hello everyone. Today we are going to talk about the installation and configuration of OCI CLI on Linux. This OCI tool will be useful to have installed if you are …
Recovery mode in SQL Server
Hello everyone, today we are going to talk to you about several ways to get recovery mode in SQL Server . Each recovery mode has its pros and cons. That …
Simulate a backup in SQL Server without taking up disk space
Hello everyone, today we are going to talk about a simple trick that can be useful in various situations. It is about simulating a backup in SQL Server . We …
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 …