Database Administrator

What is Database Administrator DBA? Database Administrator (DBA. This position has different meanings for different people. A small software development studio has broader responsibilities than a large company with a highly detailed division of

In practice, the libdata1 file of the Zabbix-Server database MySQL is too large. Today, the root space of our zabbix-server machine is insufficient. I found that the libdata1 file under/var/lib/mysql/is too large, which has reached 41 GB. I

Impdp terminate ORA-7445 due to fatal errors [kpodpals] Basic ElementsThe day before yesterday, I finally successfully exported all the data to the user. Today, the user told me that the exported data cannot be imported. First, I asked the user what

Install and configure MongoDB in Ubuntu 16.04 LTS MongoDB is a high-performance NoSQL database. Compared with relational databases, it also provides high performance and high flexibility. Here we will explain how to install and configure the MongoDB

How does SQL Server modify the auto-increment column value and corresponding solutions? A special task encountered in today's work is to change the values of the two auto-incrementing columns.Since the SQL Server platform has previously migrated the

Basics of connecting OCI to Oracle in Linux ---- configuring Instant Client to connect to oracle Database Some time ago, a brother posted a post on my blog about how to use OCI to link oracle Database Configuration methods, A lot of things in that

Data warehouse design purpose and data warehouse design purpose The purpose of data warehouse design or the criteria for measuring success: 1. The data warehouse must make the information of the Organization easy to access. 2. The data warehouse

Redis beginners (1) -- Understanding Redis and redis beginners The official Redis website defines Redis as "Redis is an open source, BSD licensed, advanced key-value cache and store". We can see that Redis is a key-value system, it can be used to

Chapter 2 User Authentication, Authorization, and Security (5): use a fixed server role, authenticationSource: Workshop Without the consent of the author, no one shall be published in the form of "original" or used for commercial purposes. I am not

Principles of database systems (I)-basic concepts of database systems and concepts of Database Systems Concept Model: (1) express the overall logical structure of the data, which is a comprehensive description of the data involved in the entire

Hadoop big data basic training course: the only full HD version of the first season, hadoop Training CourseHadoop big data basic training course unique HD full version first seasonThe full version of 30 lessons was born Link:

Note that the download is a binary version, not a Windows Installer. Http://www.enterprisedb.com/products-services-training/pgbindownload X86 download http://get.enterprisedb.com/postgresql/postgresql-9.2.4-1-windows-binaries.zipX64 download

Oracle 10g AND Oracle 11g manual database creation case -- Oracle 11g System Environment: Operating System: RedHat EL6 Oracle: Oracle 10g and Oracle 11g Manual database creation is relatively easy to implement. In this case, we will make a simple

Oracle 10g AND Oracle 11g manual database creation case -- Oracle 10g System Environment: Operating System: RedHat EL6 Oracle: Oracle 10g and Oracle 11g Manual database creation is relatively easy to implement. In this case, we will make a simple

1. Memory Optimization tableIn-memory OLTP is a memory-optimized database engine that is integrated into the SQL Server engine.OLTP in memory has been optimized for OLTP. There are many restrictions on the external applications of Transact-SQL

MySQL command line Export Database, mysql command line Export MySQL command line to export the database:1. Go to the bin folder under the MySQL Directory: directory from cd MySQL to the bin folderFor example, if the command line I entered is cd C: \

SQL Server uses scripts to create updatable subscriptions for distribution services and transaction replication, and SQL server scripts [Create a local distributor] /************************ [Use local distribution server configuration release ]****

ERROR 1418 (HY000): This function has none of DETERMINISTIC, no SQL, or reads SQL DATA..., hy000deterministic Create function today CREATE FUNCTION `func_get_split_string_total`(f_string varchar(1000),f_delimiter varchar(5)) RETURNS int(11)BEGIN

BKJIA exclusive Article] Steps for joining SQL Server in DB2: 1. Install DB2 2. Install the IBM DataDirect ODBC driver 3. Install the link connector Or install InfoSphere DB2InfoSphere DB2 is a restricted DB2 version, which uses a link connector to

BKJIA: From DB2 9.7, you can use the following query to check indexes not used in DB2: SELECT INDSCHEMA, INDNAME, TABNAME      FROM SYSCAT.INDEXES   WHERE  LASTUSED = '01/01/0001';  The LASTUSED column tells you the last access time of