A blog with focus on technology, internet, mobile phone, IT Security, databases, open source, operating systems, Servers, news and life style
Posts Tagged ‘database’
Tweet If you need to change your database name either this is because the original name was based on some project or it was because of you restored your other database and at the time just gave it a temporary name or you missed to change name of your restored database, but later you need [Continue]
Tweet PHP is an opensource server side scripting language and it is a widely used. The Apache web server provides access to files and content over HTTP OR HTTPS protocol. A misconfigured server side scripting language can create all sorts of problems. So, PHP should be used carefully. Here are twenty five php security best practices [Continue]
Tweet In relation to PHP programming language, MySQL is the old database driver, and MySQLi is the Improved driver. MySQLi takes advantage of the newer features of MySQL 5. Lifted verbatim from the php.net site: Embedded server support Object-oriented interface Support for Prepared Statements Support for Multiple Statements Support for [Continue]
Tweet Database administrators experience regular slowdowns on their SQL Server databases. The I/O subsystem is a key factor when it comes to SQL Server performance since database pages are constantly moved in and out of the buffer pool. Also the transaction logs and tempDB generate significant I/O traffic. Therefore you have to ensure that your [Continue]
It is great to be able to build small utilities on top of an excellent RDBMS. Thank you MySQL. This is a small but complex utility to perform online schema change for MySQL. We call it OSC and the source is here (Code is also available at bottom).
Some ALTER TABLE statements take too long form the perspective of some MySQL users. The fast index [Continue]