database administrator books

Administrator | data | The adjustment and optimization of database database may be one of the most important and critical tasks for a database administrator. Unfortunately, tuning and performance tuning for databases like SQL Server is not an easy task. SQL Server has severa

Oracle Database AdministratorI have already introduced daily, weekly, and monthly jobs for you, this section describes the monthly responsibilities and daily management of Oracle Database administrators, the weekly responsibilities of Oracle Database administrators, and the daily responsibilities of Oracle Database adm

Database adjustment and optimization may be one of the most important and critical tasks of a database administrator. Unfortunately, it is not easy to adjust databases such as SQLServer and adjust the performance. SQLServer has several monitoring and debugging tools, which are powerful but difficult to master. Coefficient is similar to Profiler. However,

I. jobs of the database administrator Generally, as a DBA, do the following 12 tasks Installation and configuration Capacity Planning Application Architecture Design Manage database objects Bucket Management Security Management Backup and recovery Performance monitoring and Tuning Job Scheduling Network Management High availability and high scalabilit

As an Oracle administrator, you will learn database management tools from the beginning. The following describes some basic concepts of database management tools for Oracle administrators. 1. What is Oracle Enterprise Manager. Oracle Enterprise Manager (Oracle Enterprise Manager) is a graphical database

Log on to MongoDB as an administrator and create a database In a database with a user name, even if you create a user in the admin database, you still cannot access other databases after logging on, but you can log on to the database, although users can be created in the c

1: MySQL must know: short and precise five-star recommendation This book is a small open book and is very thin. If you have an SQL foundation, you can repeat it in just a few hours. This book can solve the problem of getting started with MySQL SQL dialect. 2: MySQL technology Insider: Five-star recommendation for entry-level MySQL development books The book is thick, but the content is a little complicated. If you include the appendix of more than

Source: http://www.cnblogs.com/lyhabc/archive/2012/09/23/2698702.htmlDAC: dedicated Admin ConnectionWhen SQL Server is unable to establish a database connection due to insufficient system resources or other exceptions, you can use the system-reserved DAC to connect to the database for troubleshooting and troubleshooting. A DAC can use only limited resources. Do not use a DAC to run a resource-intensive quer

, databases.Import is to import the object and data of the file into the database using import, but the file to be used by the import must be a file exported by export, similar to the export, import is also divided into import tables, scenarios, databases.The options commonly used by IMP are:UserID: Used to specify the user name, password, and connection string to perform the export operation.Tables: Used to specify the table to perform the export ope

The computer is WIN10 64 bit, the database is Oracle 11g, log in today　　When displayed: Ora-01031:insufficient privileges, insufficient permissions.Referring to this method, my local Users and groups have ORA_DBA groups, and the group also has a system login user, and the database is also installed to use for a period of time, today only display the hint. However, the last method in the text can be logged o

mysql.user set Password=password (' Pass12345678 ') where user= "root";After the password update is complete, stop the MySQL service, then change the configuration file again, remove the skip option and restart[[Email protected] ~] #systemctl stop mariadb; [[Email protected] ~] #vim/usr/lib/systemd/system/mariadb.service execstart=/usr/bin/mysqld_safe--basedir=/ UsrOverloaded files[[Email protected] ~] #systemctl daemon-reload [[email protected] ~] #systemctl Restart MARIADBAfter the MySQL serv

the TFS environment, but all were able to fix the problem.In view of the recent failure to make a system adjustment to the server, we initially determined that this is due to database server defects caused by the problem. Finally, the solution to the problem is to install the SQL Server 2014 patch (CU4) on all database node servers.After installing CU4, adjust the AlwaysOn configuration and the problem dis

admin | data | database Database Administrator dba what is DBA database administrator, English is the DBA. This position means a different meaning to different people. A small software development studio is a much broader responsibility than a large company with a high l

The Database Administrator is responsible for establishing a configuration management database and maintaining the internal integrity or possible inter-database integrity of each database. Main activities include: Create a configuration management