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-6a42c7f6d6a56560293086/] [crayon-6a42c7f6d6a5c878947797/] or [crayon-6a42c7f6d6a5e300737383/] or [crayon-6a42c7f6d6a5f956768218/] …

  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 …