Feb 20, 2012
The article talks about to be good performance of database is starts with a proper formulated SQL. According to Mullins, 75% of poor relational performance is caused by “bad” SQL and application code. For those people are new to programming especially for relational database environment it is very hard to remember and determine the problem [...]
Feb 20, 2012
Just five years ago, the Smithsonian Institution started collecting data about every living thing on earth. The planet has an approximate 1.9 million species of living organisms on earth. Currently the researchers have collected around 40% of the total species. The database includes observations such as describing the nocturnal behavior of the flying lemur, and maps [...]
Feb 20, 2012
For this week’s blog I found an article from the Journal of Management Information Systems. The article presented an interesting question in research and development. When working in a dynamic environment like in the Information Technology industry, new technologies are vital to the survival of your company. The problem is new technology involves expensive research [...]
Feb 20, 2012
With cyber crime on the rise, database administrators must do everything they can to prevent data from being compromised. This article introduces a new product called ActiveCrypt DBDefence which is designed to lock down database log files inside 32 and 64 bit systems on SQL Server 2000, 2005, and 2008. The enterprise eidition of DBDefence [...]
Feb 20, 2012
This article shows an example of an application of Database Technology based on XML used for nuclear fuel calculation. Originally the nuclear fuel calculation software was based on the “ancient” FORTRAN language. It compares the old file system with the database system which gives it a few advantages. Such as Data sharing and low redundancy. Then introduces [...]
Feb 20, 2012
2012 is going to be a big year for Microsoft’s SQL server. It going to get a huge overhaul and cloud support this year. The explosive increase of data is forcing SQL server to change the way of managing and storing data. Up and coming solid state drive usage have spike recently as a new [...]
Feb 20, 2012
In the article that I read, James Cohen goes over a massive web attack dubbed the “LizaMoon.” The attack was made possible due to an SQL Flaw in which malicious code was injected into the SQL databases that ran many websites. This would then direct users browsers to a new site where a fake antivirus [...]
Feb 20, 2012
This article is about how the new edition of Joomla has now made it possible to use Microsoft SQL Server, PostGreSQL, and MySQL. This multi-database support has become a great plus for business owners that use Joomla for their websites. There won’t be as much hassle by being limited to just one database structure. This [...]
Feb 20, 2012
The article I read this week dealt with how financial services customers are benefiting from Windows Server OS and Microsoft Server SQL. A company called, Skandinavisk Data Center (SDC), which services more than 150 banks is hoping to save around 20 million dollars annually by switching from its mainframe platform to Windows Server OS and [...]
Feb 20, 2012
The article, “Writing SQL Statements That Use Joins to Combine Data from Multiple Tables”, is briefly related to our this week class materials which are combining data from multiple tables by using joins. Where clause is used to bring data from more than one table into a set of query. If it does not include [...]
Feb 20, 2012
Database Administrators are one of the most sought after jobs for CIS majors once they graduate. In the article that I chose today, the author sets up a guide on how to become an effective DBA, while also doing a good job with pointing out common problems that are found within DBA’s that tend to [...]
Feb 20, 2012
This week I have chosen another peer-reviewed article discussing new business intelligence (BI) functionality and management features that will be or has been implemented into SQL already. Referring to the “mini-release” as code name Kilimanjaro, this release has the potential to really innovate the way businesses apporach SQL and it’s DBMS capabilities. Some of the [...]
Feb 20, 2012
Any database that does no support the SQL language is known as an NoSQL database. NoSQL was inspired and created based off Lotus notes, a program that was co-created by Lotus founder Mitch Kapor and Microsoft chief architect Ray Ozzie as a personal productivity tool. Lotus notes was never thought to be a database application; [...]
Feb 20, 2012
My article is talking about a group of hackers that managed to hack into one of Apple’s servers. The anonymous group was able to infiltrate into the server that Apple used to process technical support follow-up surveys. With the attack, they were only able to retrieve 27 user names and passwords, and from what Apple [...]
Feb 20, 2012
Imagine a world where your thoughts control your actions are determined before your body even receives the signal. You simply issue a mental command and the path to that command’s conclusion is instantly given to you. Sound cool? Well that’s unfortunate, because such a thing does not exist. But what does exist is a database [...]
Feb 20, 2012
In this article the author talks about SQL injection and how it’s been around for more than a decade and many companies do not know how to deal with it or not even implementing solutions to fix this widespread problem. SQL injection is a code injection technique that exploits vulnerability in websites software where arbitrary [...]
Feb 19, 2012
This article from Information Week looks into the best rated data center networking vendors, new technology, and what companies are looking to do with regards to their datacenters. According to their vendor evaluation, over 70% of the companies surveyed will “likely have newly designed networks within three years.” This is [...]
Feb 19, 2012
The article that i read was about how automated web attacks are on the rise. The article says that on average web applications are attacked by hackers roughly once every two hours while automated attacks are averaging about 25,000 attacks per hour. That is one attack every 7 seconds. This shows how much more devastating [...]
Feb 19, 2012
This article talks about the advantage of using SQL AZURE for shipping any suitable applications to the cloud. The company will minimize data redundancy and save a lot of space for storage when they move any applications that are suitable to the cloud server. Besides that, it will increase high availability and patching. Therefore, the [...]
Feb 19, 2012
The article I read talks about the basics of database design including normalization, relationships and cardinality. It is important to create an entity relationship diagram (ERD), but sometimes it is ignored or overlooked when developing an application. Developers can use an accurate data model as an important reference tool. Effective database design can help developers [...]
0 
0 
4