Archive for the 'Databases' Category存档为'数据库'类别

MySQL Database Performance Tuning Best Practices Video Tutorial MySQL数据库性能调整的最佳做法视频教程

Tuesday, July 29th, 2008 周二, 2008年7月29日

MySQL is one of the most popular database management system that powers the most dynamically served website, including sites with millions traffic and visitors everyday. MySQL的是其中一个最流行的数据库管理系统的权力最动态服务的网站,包括网站上拥有数以百万计的交通及旅客每天。 Many web pages and web applications or services rely on MySQL to store contents data which will be retrieved and read by web servers to dynamically built the web pages that visitors will read.许多网页和Web应用程序或服务的依赖于MySQL的存储内容,数据将检索和阅读的网页伺服器,以便动态建立网页的访客,会读。

Continue reading MySQL Database Performance Tuning Best Practices Video Tutorial » » »继续阅读MySQL数据库性能调整的最佳做法视频教程» » »


Optimize SQL Server 2000, 2005 or 2008 in Large RAM System by Locking Pages in Memory and AWE优化SQL Server 2000中, 2005年或2008年在大型的RAM系统的页面锁定在内存和敬畏

Saturday, June 7th, 2008 周六, 2008年6月7日

Microsoft SQL Server is a data-intensive and disk I/O (read and write) intensive database management systems. Microsoft SQL Server的是一个数据密集型和磁盘I / O (读写)密集的数据库管理系统。 For SQL Server which is running on a system with large amount or big size of physical RAM memory, such as system with 4GB, 8GB or even more gigabytes of physical memory, it can be configured to use the Address Windowing Extensions (AWE) API to provide access to physical memory in excess of the limits set on configured virtual memory, and force all paging to take place in memory for faster access.对于SQL Server是运行于系统与大量或大尺寸的物理RAM记忆体,如系统与话又说回来, 8 GB的,甚至需要更多的GB的物理内存,它可以配置为使用地址窗口扩展(敬畏)空气污染指数提供获得物理内存在超过设定的范围就设定虚拟记忆体,并迫使所有传呼服务商采取的地方,在内存以便快速访问。

Continue reading Optimize SQL Server 2000, 2005 or 2008 in Large RAM System by Locking Pages in Memory and AWE » » »继续阅读优化的SQL Server 2000 , 2005或2008年在大型的RAM系统的页面锁定在内存和敬畏» » »

Free Microsoft Office Alternatives or Replacements免费的Microsoft Office替代品或替代品

Sunday, November 25th, 2007 周日, 2007年11月25日

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替代品或替代» » »

Error Has Occurred While Establishing A Connection To SQL Server 2005 Which Does Not Allow Local and Remote Connections发生错误的同时,建立连接到SQL Server 2005不容许本地和远程连接

Wednesday, October 31st, 2007 周三, 2007年10月31日

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不容许本地和远程连接» » »


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

Tuesday, October 23rd, 2007 周二, 2007年10月23日

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没有足够的价值观错误» » »

Uninstall and Remove Multiple Database Instances of Microsoft SQL Server 2005卸载和删除多个数据库实例的Microsoft SQL Server 2005

Sunday, October 14th, 2007 周日, 2007年10月14日

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 » » »

How to Read MySQL Binary Log Files (BinLog) with mysqlbinlog如何阅读MySQL的二进制日志文件( binlog )与mysqlbinlog

Saturday, October 6th, 2007 周六, 2007年10月6日

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 » » »

Check and Optimize MySQL Database Automatically with Crontab/Cron检查和优化MySQL数据库自动与crontab /玉米

Friday, September 21st, 2007 周五, 2007年9月21日

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 /玉米» » »