Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Buffer Pool Extension is a feature that was introduced in SQL Server 2014. With this feature, SQL Server uses the disk we specified for …
Read More »
dbtut
About SQL Server and Comparison with Other Relational Database Management Systems
SQL Server is a relational database management system (RDBMS) that Microsoft has provided to us. You can find a lot of articles about SQL Server …
Read More »
How To Query Transaction Count in Oracle
A script that you might need during database scaling. Calculation of transaction numbers between two specific dates. This script was tested in 11gR1 and 11gR2. …
Read More »Example of Using Data Pump
In this article I will share an example about data pump usage. First we start with export. EXPORT: [crayon-6a0c6cc5277c5881779015/] [crayon-6a0c6cc5277ca853993742/] or [crayon-6a0c6cc5277cc810132587/] or [crayon-6a0c6cc5277cd060742139/] …
Read More »How To Log More Detailed Information in Oracle Listener Trace?
If the connection breaks and timeouts occurs due to network problems and you cannot convince your network team, you can monitor events between client …
Read More »
SQL Server AlwaysOn Availability Groups step by step
I will configure SQL Server AlwaysOn Availability Groups step by step in this article. First I want to tell about SQL Server Alwas ON. What …
Read More »How To Execute a Script on Multiple Instance with Registered Server
Sometimes you may want to execute a script in more than one instance. It is a solution to connect to each instance individually, but …
Read More »SQL Server Availability Group Failover Process
Sometimes you may need to restart one of the Always On servers. In such a case, you will need to failover the Availability Group …
Read More »SQL Server Availability Group Databases Synchronization Status
Sometimes you may need to restart one of the servers you use Always ON. Suppose you have 2 servers and that you have 10 …
Read More »Update Table Without Update Permission On 11gr2
I’m going to talk about a problem I tested in 11gr2 versions. Each user with a select permission in a table can update that …
Read More »