What is SQL Server IntelliSense
IntelliSense was introduced with SQL Server 2008. With this feature, we can now write TSQL Code in a more practical
How To Fix The SQL Plan in Oracle Databases
In some cases in Oracle databases, the optimizer may make the wrong decision and cause this query to run with
How To Visualize Data with Kibana(Create a Dashboard with Kibana)
In this article we will create a simple dashboard with Kibana. First we need to connect to Kibana and create
How To Move CSV or TXT to Elasticsearch
In this article, we will move a csv file we created, to elasticsearch with logstash. You can also move TXT
How To Debug TSQL Queries
Since SQL Server 2008, we can debug our TSQL queries as in Visual Studio. In this way, we can see
Displaying Errors in Oracle Services With ADRCI
ADRCI (ADR Command Interpreter) can be used to display errors in services such as Oracle database, grid, asm, listener. In
How To Find Unused Indexes in SQL Server
Each database administrator wants to detect and delete unused logins. By default in SQL Server, the last time the login
How To Move All Objects of a Schema to a Different Tablespace
To move all objects in a schema to a different schema, the following steps must be followed. The following queries
How To Check Page Verify Option of Databases Using Policy Based Management
Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we
ORA-20001: Statistics Advisor: Invalid task name for the current user
During the 12c database creation process , you can see ORA-20001 error in the alert log file when the “SYS.ORA