Even if the password_verify_function limit of a profile is changed in Oracle databases, it does not change as requested and changes to “FROM ROOT”. The …
Read More »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 way. So where can we …
Read More »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 the wrong query plan. If …
Read More »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 an Index pattern. For more …
Read More »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 files to elasticsearch in the …
Read More »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 which variable gets what value …
Read More »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 all ADRCI-defined homes, you can …
Read More »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 was logged is not stored …
Read More »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 prepare the queries required for …
Read More »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 want in our systems, to …
Read More »