Buffer Pool Extension is a feature that was introduced in SQL Server 2014. With this feature, SQL Server uses the disk we specified for …

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 …

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. …

  In this article I will share an example about data pump usage. First we start with export. EXPORT: [crayon-69826d9d1ff5d007679056/] [crayon-69826d9d1ff65902659559/] or [crayon-69826d9d1ff67675843206/] or [crayon-69826d9d1ff69035729953/] …

  If the connection breaks  and timeouts occurs due to network problems and you cannot convince your network team, you can monitor events between client …

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 …

  Sometimes you may want to execute a script in more than one instance. It is a solution to connect to each instance individually, but …

  Sometimes you may need to restart one of the Always On servers. In such a case, you will need to failover the Availability Group …

  Sometimes you may need to restart one of the servers you use Always ON. Suppose you have 2 servers and that you have 10 …

  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 …