MySQL是供給最動態地服務的網站動力的一个最普遍的數據庫管理系統，包括站點以成千上萬交易和訪客每天。 許多網頁和Web應用程序或者服務依靠MySQL存放將由網絡服務器檢索和讀對動態地修造網頁的內容數據訪客將讀。

繼續讀書MySQL數據庫性能調整的最佳的實踐錄影講解」」」

微軟SQL服務器是一個數據密集和盤輸入/輸出(讀和寫)密集的數據庫管理系統。 對於在一個系統以巨額或物理隨機存取存儲器的大大小，例如系統與4GB， 8GB甚至更多十億字節運行物理內存的SQL服務器，它在記憶可以配置使用地址開窗術引伸(敬畏) API提供存取對於物理內存超出定的極限在配置的虛擬內存，并且強迫所有調頁發生為快速訪問。

持續讀優選SQL服務器2000年， 2005年或者2008年在大RAM系統通過鎖頁在記憶和敬畏」」」

微軟辦公系統隨員和產品是一个最普遍的辦公室生產力應用套件在許多公司中和公司。 然而，微軟辦公系統是昂貴的，過度定價最好。 微軟辦公系統來與一個可能不使用或需要的許多先進的特點和與用戶友好的接口。 如果您願犧牲一些膨脹的特點，那裡是大量完全替換選擇為微軟辦公系統，有慢獲取市場份額。 最好所有，供選擇的辦公室是自由的，并且擁有您需要使用的所有特點，包括兼容性和支持為微軟辦公系統文件格式。

持續讀自由微軟辦公系統選擇或替換」」」

When connecting to an instance of Microsoft SQL Server 2005 database, including SQL Server 2005 Express, Developer and Enterprise editions, for authentication or accessing and retrieving and updating the data, the the following error message may appear. The problem happens no matter the connection is originated from remote computer or on SQL Server local computer itself, and can be caused by any program, such as SQLCMD utility, used to connect to SQL Server.

Sqlcmd: Error: Microsoft SQL Native Client: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

Continue reading Error Has Occurred While Establishing A Connection To SQL Server 2005 Which Does Not Allow Local and Remote Connections » » »

In Oracle database, the following error message may appear when an incorrect SQL statement is used, in SQL Plus or in anywhere that send SQL queries to the databases such as stored procedure or external programs.

PL/SQL: SQL Statement ignored
PL/SQL: ORA-00947: not enough values

Continue reading Oracle PL/SQL ORA-00947 Not Enough Values Error » » »

When database system administrator installs Microsoft SQL Server 2005 and creates a few database engine instances, there will be problem and hard time to remove and uninstall these multiple database instance components and the corresponding SQL Server services. When users try to uninstall Microsoft SQL Server 2005 or remove database instance components using Add and Remove Programs or Uninstall or change a programs (Vista) in Control Panel, only one SQL Server 2005 database engine can be selected. After uninstallation has completed, when users attempt to run the SQL Server 2K5 Uninstall to completely clean remove any other instances or components, the action will fail with error message saying the uninstaller shortcut entry is invalid and asked if you want to remove the link.

Continue reading Uninstall and Remove Multiple Database Instances of Microsoft SQL Server 2005 » » »

MySQL database server generates binary log files for every transaction to the databases, provided administrator does not disable or comment out the “log-bin” parameter in my.cny configuration file. The binary log files are written in binary format. Although the binary logs, or also known as logbin are mainly used for MySQL database replication purpose, sometimes you may need to examine or read the contents of binary logs in text format, where the mysqlbinlog utility will come in handy.

Continue reading How to Read MySQL Binary Log Files (BinLog) with mysqlbinlog » » »

MySQL is a very popular free yet powerful database system. But even in great databases, the tables may get fragmented with overhead due to continuous update, or delete and insert operation on data stored in database. Beside, it’s also possibility that the databases may get corrupted. Thus, performing health check on database and optimize MySQL server regularly is an important task.

Continue reading Check and Optimize MySQL Database Automatically with Crontab/Cron » » »