Database Administrator

• MongoDB STARTUP configuration 1. startup Item mongod -- help 1.1 Use the config configuration file to start the database and change the port to 8888. Mongodb. conf file Dbpath = D: \ app \ upload data Port = 8888 Start File Mongod.exe -- config

/* Author: Jiangong SUN */ I 've encountered a problem when I do a SQL bulk copy from a table in staging to the same table in production. Should t for a same column has different types. So when I synchronize the data, I have the following error:

FIRST_VALUE and LAST_VALUE in SQL SERVER FIRST_VALUE and LAST_VALUE See the following SQL statements: WITH testas (select 'Happy col' as name, 10 as score union all select 'Happy col' blog ', 15 union all select 'Happy col ', 20 union all select

A role is a set of related permissions. The main purpose of a role is to simplify permission management. Once the permissions of this set exceed the minimum requirements of users, it may bring security risks to the database. Role password Test In

3. Develop applications1. sort by strokes of the Last Name: Select * From TableName Order By CustomerName Collate Chinese_PRC_Stroke_ci_as // From less to more --> Test data: [a] if object_id ('[a]') is not null drop table [a] go create table [a] ([

  $ Topas-PTopas Monitor for host: jhhost Interval: 2 Thu Aug 26 16:23:57 2010DATA TEXT PAGE PGFAULTSUser pid ppid pri ni res space time cpu % I/O OTH COMMANDOracle 324076 1 102 20 1293 4827 1293 0 0

Today, we found a bug in the project, that is, about field sorting. I wanted to get the result as follows: However, the result is as follows: Put the A1 fan to the last one: It is determined that it is not a plug-in problem, it must be an SQL

In order to install the cluster, the study took 2 days to complete, so the study experience was recorded for your reference, to avoid repeated detours, the installation is divided into the following stages:Environment Description: CentOs6.5 +

At the beginning, I never understood why 12306 of the many functions should be separated. For example, the query function of 12306 of the remaining tickets is separated from the ticket purchasing function. In fact, I should consider it with a

Environment SQL Server 2012 + CentOS 6.3 Problem description Only the production database can log on, query, and create temporary tables. If you do not have the permission to import data (such as Excel files, txt files, and SQL scripts), you must

To view the client information (mainly IP addresses) connecting to the database, you can use the v $ session view, which contains several fields related to the client information: OSUSER VARCHAR2 (30) Operating system client user name

Problem 1: the command line starts mysql and the "System Error 5, Access Denied" error occurs.Problem description: Sometimes mysql is started using the command line"System Error 5: Access Denied".Problem analysis: the reason is the current user'sThe

Impdp import data, ORA-39082 ORA-39083 error number, the object cannot compile after the import can be compiled object to try: alter view view_name compile; if the error: Use show errors to locate the source of the problem, whether it is a

To connect to mysql through the command window in cmd, you only need to input mysql-uroot-p123456 in the command line. The prompt "mysql is not an internal or external command" appears ". The solution is to add C: \ Program Files \ MySQL Server 5.6 \

[Oracle @ slave ~] $ Cat/etc/sysconfig/i18nLANG = "zh_CN.UTF-8"[Oracle @ slave ~] $ Echo $ LANGZh_CN.UTF-8[Oracle @ slave ~] $ Echo $ NLS_LANG [Oracle @ slave ~] $ Sqlplus/nolog SQL * Plus: Release 11.1.0.6.0-Production on Sat Oct 30 13:24:10

The Endeca product system contains a lot of content. Previously, we introduced the most ignored but important content of IAS. This article mainly introduces the installation process of the EndecaETL tool: 1. Install the EndecaETL client on the

The partition index is a global partition index and a local partition index, and a global non-partition index (that is, a common index) is added. A total of three types of indexes are added. The organizational structure and application scenarios of

I recently spent some time learning Redis and recorded the entire process for future study. What is Redis? on the official website, Redis is completely open-source and free. It complies with the BSD Protocol and is an advanced key-value persistence

DBA work summary   For more than a year, I have respected and respected the leaders to unite my colleagues, obey the rules and observe the discipline, learn professional knowledge, and work diligently. Summary of the past, in the knowledge structure,

I. Stored Procedure PurposeIt is used to execute an operation, named PL/SQL block, and can receive passed parameters and be called.Brief IntroductionNamed PL/SQL BlockAcceptable parametersCan be called repeatedlyUsed to perform an operationStored