Jan 19
database, development, mysql No Comments
Sometimes you may need to update multiple rows of data in a table. This is no problem a lot of the time, as the fields to update may all need to be changed to the same value, in which case you might run a query like the following.
May 04
database, development, software navicat No Comments
Navicat™ is a fast, reliable and affordable Database Administration tool purpose-built for simplifying database management and reducing administration costs. Designed to meet the needs of database administrators, developers, and small and medium businesses, Navicat is built with an intuitive GUI which lets you create, organize, access and share information in a secure and easy way.
What’s new in v9:
Navicat has been my MySQL manager ever since being introduced to it by DonationCoder and I’ve never looked back. Tried a few others, for testing, over the years but Navicat has always proved to be superior.
It’s not mentioned in the upgrade information but for me v9 seems to be faster when dealing with larger databases.
Compare Navicat for yourself with their free demo…
Link: http://www.navicat.com/
Apr 13
database, development, microsoft No Comments
The SQL Server cheat sheet is a one-page A4 printable document, designed to provide a quick reference for SQL Server. A description of what is on the cheat sheet follows, or if you are impatient, you can go straight to the full size SQL Server cheat sheet.
Mar 08
database, development, mysql No Comments
On most websites, content is stored in a database and served to visitors upon request. Databases are very fast, but there’s lots of things that you can do to enhance its speed and make sure you won’t waste any server resources. In this article, I have compiled 10 very useful tips to optimize and speed up your website database.
Feb 14
database, development, mysql No Comments
Some excellent tips
Nov 25
database, development, mysql No Comments
Database operations often tend to be the main bottleneck for most web applications today. It’s not only the DBA’s (database administrators) that have to worry about these performance issues. We as programmers need to do our part by structuring tables properly, writing optimized queries and better code. Here are some MySQL optimization techniques for programmers.
Apr 20
database, mysql, open source No Comments
Oracle Corporation is to buy Sun Microsystems for $9.50 a share in a deal valued at approximately $7.4 billion, just a few weeks after a deal by IBM to buy Sun fell apart. It looks like Oracle will pay a premium of $2.81 a share, or 42%, over Sun Micro’s closing price of $6.69 a share on Friday.Oracle said the deal is valued at $5.6 billion excluding cash and debt. Oracle is calling Sun’s Java “the most important software” it has ever acquired. The deal, which is expected to close in the Summer and was unanimously approved by Sun’s board of directors, has massive implications for the future openness of Java and MySQL.
What’s going to happen to MySQL?
Mar 24
Making schema changes or adding indexes to a database with more than 10 – 20 million rows completely locks the database for hours at a time. Removing old indexes takes just as much time, and not removing them hurts performance because the database will continue to read and write to those unused blocks on every INSERT, pushing important blocks out of memory. There are complex operational procedures you can do to circumvent these problems (like setting up the new index on a slave, and then swapping the slave and the master), but those procedures are so error prone and heavyweight, they implicitly discouraged our adding features that would require schema/index changes. Since our databases are all heavily sharded, the relational features of MySQL like JOIN have never been useful to us, so we decided to look outside of the realm of RDBMS.
Link:
http://bret.appspot.com/entry/how-friendfeed-uses-mysql
Jun 03
database, live, microsoft, website No Comments
Password-protected online file storage. Always available where you need it.
Offers:
Personal
Shared
Public
Apr 12
database, development, open source No Comments
Among the advances in 5.1 are partitioning, events scheduling, row-based replication and disk-based clustering. They are fairly standard features already offered by rivals IBM, Oracle and Microsoft, but they should help MySQL compete in environments where performance and the ability to scale are critical.“One thing we’re really most proud of is, frankly, we fixed a lot of outstanding bugs in 5.0,” Urlocker said. “So 5.1 has not only greater reliability, but a performance increase of 20 percent. It will be more in some cases and less in others, but there’s a significant performance boost and scalability enhancements.”
Feb 20
myLittleAdmin for SQL Server 2005 is the first web-based management tool specially designed for MS SQL Server 2005.It lets you manage most objects of your databases and servers, including new objects such as snapshots, schemas, and credentials, etc. through a web browser. Faster than SQL Server Management Studio, its intuitive interface will seduce all users, from the DBAs to the webmasters, including the web-hosts.
Jan 16
Sun Microsystems Inc. has agreed to buy open-source software maker MySQL AB for $1 billion, beefing up the server maker’s database offerings with a company whose technology is used by some of the world’s biggest Web sites.
Jan 15
database, development, graphics No Comments
Some pretty amazing data visualization techniques:
http://…data-visualization-and-infographics/
Dec 19
database, development, mysql No Comments
Amazon SimpleDB is a web service for running queries on structured data in real time. This service works in close conjunction with Amazon Simple Storage Service (Amazon S3) and Amazon Elastic Compute Cloud (Amazon EC2), collectively providing the ability to store, process and query data sets in the cloud. These services are designed to make web-scale computing easier and more cost-effective for developers.
Pricing:
Facebook
RSS
Twitter
Recent Comments