To create Availability Group(AG) Fail-over SQL Server Cluster with secondary replica we need 4 machines/VMs which are as follows Domain Controller: Machine Name: DC 192.168.1.71 …
Read More »What is File Table and Differences From File Stream
The File Table uses the technology of File Stream. It keeps file system data as a table. That is, you can access the data …
Read More »How To Change e-mail Alert Settings on Exadata cell servers
Cellcli can be used to change e-mail alert settings on cell servers. To find out the current situation: [crayon-6605da32355fb240545250/] To change: [crayon-6605da3235601714559079/] …
Read More »Fulltext Search On SQL Server
Full-text Search used to search for columns with large text, such as varchar (max). You can do the same with LIKE, but LIKE will …
Read More »ORA-04030: out of process memory
ERROR: When a query is executed, an error “ORA-04030: out of process memory when trying to allocate nn kilobytes” is being received. SOLUTION: Decrease pga …
Read More »What is File Stream On SQL Server
The File Stream structure keeps the BLOB objects (document, image, video, etc.) integrated with the database on the NTFS File system on the server. …
Read More »INSTALLATION OF CASSANDRA
Pre-Installation Setup Before installing Cassandra in Linux environment, we require to set up Linux using ssh (Secure Shell). Follow the steps given below for …
Read More »DBQL rules – QUERY LOGGING
Following query will verify if any DBQL rule exists: locking table DBC.DBQLRuleTbl for access [crayon-6605da32360a0960721883/] Note: View DBC.DBQLRules OR DBC.DBQLRulesV can also be …
Read More »Oracle IAS BIND (Address already in use)
ERROR: When opmn services are started, the following error is being received. BIND (Address already in use) x.x.x.x: 393478144 – listener BIND failed [crayon-6605da3236384322387841/] When …
Read More »How To Install SQL Server
In this article, we will install SQL Server 2014. Other versions can be installed in similar ways. Stand-Alone means installing only one instance on a …
Read More »