Nov 27, 2011
Summary: There are so many databases in today’s market, raging from different editions and suppliers. How do you know which is the best one for you? Types of DBMS include Desktop, Server, Web-enabled, Cloud DBAAS, and Open Source. MySQL and PostgreSQL would be under Open Source category. The article provides an overview of Pro & [...]
Nov 20, 2011
DBAs(Database Administrators) need to be more proactive on projects and learn how to present their values to the management. 1. Larger companies normally have different teams to work one project. As a result DBAs must collaborate with co-workers from all different background and solve different issues. Sometimes issues could be so overwhelming that DBAs can [...]
Nov 13, 2011
Sumamry: This article presents some of the most common methods of hacking a website. I have condensed this article review to SQL injection only. SQL Injection(Previously mentioned during the lecture): Enter SQL code into web forms, login fields, address fields, or anywhere that enables the users to interact with the database. The concept is that [...]
Nov 7, 2011
Summary: Database security should be one of the top concerns for any business. This article introduced 10 “Best Practices” for database security from their over 1,000 installation experience. 1. Establish a baseline: The main is to run a evaluation of the current security level and used for future comparison. It provides the ability to track [...]
Oct 30, 2011
Summary: This article explains the steps to acquire data from databases. It first used Access as an example, which already support the import feature when using excel. Users simply click on the Data tab -> Get External Data group from access and navigate to the database file, and click on the table. If an user wants [...]
Oct 23, 2011
Summary: Cloud computing has definitely been a hot topic within the recent IT industries. However, due to its nature it is very easy to confuse Cloud computing with other previous introduced technologies. As the matter of fact, many analysts have different definitions toward “Cloud computing. Some people define it as a updated version of utility [...]
Oct 16, 2011
Summary: SAP has been an ERP solution for almost 40 years now. SAP was introduced as an Accounting system named R1 40 years ago. It was used for many multinational European companies due to the advantages in soft- real time business application, multi – currency and multi language features. SAP has been mainly developed in [...]
Oct 9, 2011
Summary: SQL is a strong tool that can perform amazing calculations. However in order for it work properly the first requirement would be neat, clean, formulated SQL codes. As much as 75% of poor relational performance is caused by “bad” SQL and application code. Here are some suggested tips: 1. Think relationally in stead of [...]
Oct 9, 2011
Summary: On Thursday, October 6th, Google has announced a relational database for its cloud- hosted App Engine. It is currently only available to the selected develops to review and test the software. One of the highlights is an import/export feature that can transfer the MySQL database to the Google Cloud SQL, offering the developers the [...]
Oct 9, 2011
Summary: SQL server is a very powerful relational database system that can provide powerful calculations. Cloud computing is the up coming new star which many companies not only use it to maintain its competition, but also rely on it to perform the business operation. Microsoft came out with the idea of combining the two together [...]
