Microsoft Office suites and products are one of the most popular Office productivity application suite in many companies and corporations. Microsoft Office套件和产品之一，最热门的办公室生产力应用套件，在许多公司和企业。 However, Microsoft Office is expensive, overly priced at best.不过， Microsoft Office是昂贵，过于售价为最佳。 Microsoft Office comes with many advanced features that one may never use or need, and with user friendly interface. Microsoft Office的附带许多进阶功能，一个可能永远不会使用或需要，并与用户界面友好。 If you willing to sacrifice some bloated features, there are plenty of complete replacement alternative for Microsoft Office, which has slowly gaining market share.如果您愿意牺牲一些臃肿的特点，有很多完全取代其他的Microsoft Office ，这已慢慢获得市场份额。 Best of all, the alternative Office suites are free, and possess all features you ever need to use, including compatibility and support for Microsoft Office file formats.最重要的是，替代，办公套房绝对是免费，自由，并拥有所有的功能，你以往任何时候都需要使用，包括兼容性和支持Microsoft Office文件格式。

Continue reading Free Microsoft Office Alternatives or Replacements » » »继续阅读免费的Microsoft Office替代品或替代» » »

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.当连接到一个实例的Microsoft SQL Server 2005数据库，其中包括的SQL Server 2005 Express ，开发版和企业版，为验证或存取和检索和更新数据，该可能出现下列错误讯息。 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.问题的发生，无论是连接源自远程计算机或SQL Server的本地计算机本身，可造成的任何程序，如SQLCMD实用工具，用于连接到SQL Server 。

Sqlcmd: Error: Microsoft SQL Native Client: An error has occurred while establishing a connection to the server. SQLCMD可以：错误：在Microsoft SQL本土客户：发生错误，而建立一个到服务器的连接。 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.当连接到SQL Server 2005中，这样的失败可能造成的事实，即根据默认设置SQL Server不允许远程连接。

Continue reading Error Has Occurred While Establishing A Connection To SQL Server 2005 Which Does Not Allow Local and Remote Connections » » »继续读时发生错误，同时建立一个连接到SQL Server 2005不容许本地和远程连接» » »

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.在Oracle数据库中，可能出现下列错误讯息时，一不正确SQL语句是使用，在SQL Plus或在任何地方发送SQL查询到的数据库，如存储过程或外部程序。

PL/SQL: SQL Statement ignored PL / SQL的： SQL语句忽视
PL/SQL: ORA-00947: not enough values PL / SQL的货存状况： - 00947 ：没有足够的价值观

Continue reading Oracle PL/SQL ORA-00947 Not Enough Values Error » » »继续读甲骨文PL / SQL的库存- 00947没有足够的价值观错误» » »

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.当数据库系统管理员安装的Microsoft SQL Server 2005 ，并创建一个数据库引擎的几个实例，将有问题的时间和努力，以消除和卸载这些多个数据库实例的元件和相应的SQL Server服务。 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.当使用者尝试卸载了Microsoft SQL Server 2005或删除数据库实例组件使用添加和删除程序或卸载或更改一个程序（ Vista中）在控制面板中，只有一个SQL Server 2005数据库引擎可以被选中。 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.后卸载已完成，当用户试图运行SQL Server 2k5卸载彻底清洁，消除任何其他实例或组件，行动就会失败与错误讯息说，卸载程序的快捷方式进入是无效的，并询问如果您想要删除该链接。

Continue reading Uninstall and Remove Multiple Database Instances of Microsoft SQL Server 2005 » » »继续读卸载并删除多个数据库实例的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. MySQL数据库服务器生成的二进制日志文件为每交易数据库，提供了管理员没有禁用或评论，指出“在本机登录斌”参数在my.cny配置文件。 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.虽然二进制日志，或者也称为logbin主要用于MySQL数据库复制的目的，但有时，你可能需要检查或阅读的内容二进制日志以文本格式，如mysqlbinlog实用工具能派上用场。

Continue reading How to Read MySQL Binary Log Files (BinLog) with mysqlbinlog » » »继续阅读如何阅读MySQL的二进制日志文件（ binlog ）与mysqlbinlog » » »

MySQL is a very popular free yet powerful database system. MySQL中是非常受欢迎的免费而强大的数据库系统。 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.因此，执行健康检查和数据库的优化MySQL服务器经常是一项重要任务。

Continue reading Check and Optimize MySQL Database Automatically with Crontab/Cron » » »继续阅读检查和优化MySQL数据库自动与crontab /玉米» » »

Oracle database does not provide an easy user interface to rename a datafile of tablespace, nor database administrator can easily move or relocate the datafile to another location or directory that different from original location on creation of database. Oracle数据库不提供一种简单的用户界面，来重新命名datafile的表，也不是数据库管理员可以轻松地移动或迁移datafile到另一个位置或目录不同，从原来的位置上建立数据库。 The rename or move place task has to be performed via Oracle SQLPlus command line interface.该重新命名或移动的地方，任务是要通过演出，甲骨文sqlplus命令行界面。 However, if the operation is performed when the tablespace which owns the datefile is online, error will occur.不过，如果运作时执行表，其中拥有datefile是在线，错误会发生。

Continue reading How to Rename or Move Oracle Tablespace Datafile to Another Location » » »继续阅读如何重新命名或移动甲骨文表datafile到另一个位置» » »

Accident may happens, even though it’s costly one.意外可能发生，即使它的代价之一。 This is especially the case in Oracle database, which stores the database objects physically in data files on hard disk.这是个案，尤其是在Oracle数据库中，存储数据库对象身在数据文件的硬盘。 Fast hand administrators may accidentally delete some of the datafiles, or the datafiles may get corrupted or unreadable on hard disk failure.快速，一方面管理员可能会不小心删除部分的datafiles ，或datafiles可能损坏或无法读取的硬盘失败。 You may get also some missing datafiles after database recovery process.您可能会收到也有一些失踪datafiles后，数据库恢复的过程。 In any case, missing a or a few datafiles will cause Oracle database to fail to startup, rendering the whole DB inaccessible.在任何情况下，缺少一个或少数几个datafiles会导致Oracle数据库无法启动，使整个分贝无法使用。

Continue reading How Drop Tablespace and Recover Oracle Database When Accidentally Delete Datafile » » »继续阅读如何下拉表和恢复Oracle数据库时，不小心删除datafile » » »