Database Administrator

SQL Server 2014 installation Diagram SQL Server 2014 Enterprise Edition, business intelligence edition, and Standard Edition support the following operating systems: Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, and Windows

Oracle 11G R2 replicuard construction in CentOS 5.11 Datagard is a disaster tolerance solution for Oracle Enterprise Edition. It is widely used in enterprises and I will record the setup process for backup.Host Name database version Instance name

Phpmyadmin creates database users (local, any host) and phpmyadmin DatabasesPhpmyadmin User Creation You can use phpmyadmin to create a database user and Set permissions. Both User Creation and permission configuration are simple. Root User It

Database Link of IT Ninja Turtles: database of Ninja Turtles -CREATE public database link test_link connect to scott identified by tiger using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521) (CONNECT_DATA

WAS cluster series (3): Build a cluster: Step 1: prepare files, was Cluster Note: "pointing track" is "Click order", which is the effect after clicking Environment Project point Metrics WAS version 7.0 Operating

CentOS installation mysql *. rpm prompt conflicts with file from package solution, centos. rpm Install MySql 6.5 in CentOS 5.6 Decompress file: tar xvf MySQL-5.6.19-1.linux_glibc2.5.x86_64.rpm-bundle.tar Release the following files: MySQL-embedded-5.

Today is, in the database recovery when a long-time violation of the ora-600 [2662] error, the special sorting is as follows: Problem description: The system tablespace is deleted by mistake. The database is restored to the starting state by

How to Use kettle's official website to find out how to set the carte service, kettlecarte Original Works are from the "Deep Blue blog" blog. Be sure to indicate the source when reprinting. Otherwise, you have the right to pursue legal liability for

SQL Server database email, SQL Server database The mail sending function provided by SQLserver allows you to easily send information in the database to relevant personnel. For example, you can send the warning information to the management personnel

When you build a Postgresql test environment and encounter a problem during installation, execute configure The following error is reported during the process: configure: error: readline library not found. The colleague said that the system has been

MongoDB basic (5) backup restoration and Export Import, mongodb Export See the official document: MongoDB Backup Methods The original snapshot of the operating system is used for Backup and restoration. After the Backup is successful, the

SQLite tutorial (III): Introduction to data tables and views, sqlite View 1. Create a data table: The syntax rules and usage of this command are basically the same as those of most relational databases. Therefore, we use examples to demonstrate the

Oracle 11g RMAN: Interpretation of the command for creating dg in Active Database Duplication for standby database, rmanduplicationIf the production-based duplicate replication is not manually configured with pfile (set memory, process, dg-related

SQL Server trigger and SQL Server triggerSQL Server triggers A trigger is a special type of stored procedure, which is different from the stored procedure we introduced earlier. A trigger is triggered by an event and automatically called for

Oracle Core Technology notes (this book is not carefully read, so you need to read it later ~~), Oracle Core TechnologyOracle Core Technology jump to: navigation, search Directory Start 1 2redo and undo 3. Transactions

Install Oracle12cR1 on Oracle Linux 6.5 in VirtualBox, oraclevirtualbox My Oralce Linux 6.5 is running on VirtualBox. Basic settings is 4G memory, 50G hard-disk, auto partition when install OL6.5.   ** Following series of operations need root

Atitit. Software dashboard (4) -- db database subsystem-monitoring, atitit -- db Atitit. Software dashboard (4) -- db database subsystem-Monitoring Connections ::: Deadlock table list: Basic deadlock list (recent records, time, SQL, etc) 3. Monitor

The advantage of parallel query is that it can process query jobs through multiple threads, thus improving the query efficiency. The SQL Server database provides the parallel query function for database servers with multiple CPUs to optimize the

When the system fails, data logs can be used to restore data to solve database faults. As an SQL Server database administrator, it is important to understand the role of data log files and how to use them to solve common database faults. Since the

Transaction processing is a key issue for all large database products. database vendors have spent a lot of energy in this aspect, different transaction processing methods may cause huge differences in database performance and functions. Transaction