Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

  Sometimes we need to change Collation after we have done SQL Server Installation. I will do my warning from the beginning. After changing Collation, …

  Guarantee security on Data is a key element and auditing is one of them. FGA provides a flexible way to achive this goal. With …

  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 …

  The File Table uses the technology of File Stream. It keeps file system data as a table. That is, you can access the data …

  Cellcli can be used to change e-mail alert settings on cell servers.   To find out the current situation: [crayon-6767f40347776971597889/]   To change: [crayon-6767f4034777a340735610/] …

  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 …

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 …

  The File Stream structure keeps the BLOB objects (document, image, video, etc.) integrated with the database on the NTFS File system on the server. …

  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 …

  Following query will verify if any DBQL rule exists: locking table DBC.DBQLRuleTbl for access [crayon-6767f40347f74569342442/]   Note: View DBC.DBQLRules OR DBC.DBQLRulesV can also be …