Data Types

by Jamal A
The article I read talks about the most important contemplations of selecting correct data types when designing a SQL Server database. It talks about how choosing a correct data type in the database design phase can have a significant impact on the efficiency and performance. According to the article, the SQL Server offers six sets of data types. First and formost commonly used data types that stores numeric information are called “The Exact Numeric Data Types” that includes: int, decimal, and money.  The next data type is called “The Approximate Numeric Data Types”, this data type are not as commonly used as the exact numeric data types. The approximate numeric data type includes: float, and real. Moving on, the next data type that is mentioned in this article is called “Date and Time Data Types”, this data types allow designers to easily work with time zones. After that, the next data type in the category is called “Character String Data Types”, it is used to store text values in Microsoft SQL Server databases, and this includes: char, nchar, varchar, nvachar, and text.  The next data type that is mentioned in this article is called “Binary Data Types”, it allows DBAs to store any type of binary data, this includes: bit, binary, varbinary, varbinary(max), and image. Finally, the last data type that is mentioned in this article is called “The Other Data Types”, it includes: cursor, sql_variant, table xml, and uniqueidentifier. read more...

Read more

Joomla incorporates MySQL

by Ermie C
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 is because the creators have only made previous Joomla versions to only incorporate MySQL.  However, with the new integration of multi-database functions, the use of PHP could allow Joomla to connect with the new database tools.  There’s a couple of new things they added also; the ability to incorporate a search engine function and something called stemming where it assumes the word that is being searched.   Then there is also auto completion.  In a nutshell, they have made the interface for Joomla, a lot more user friendly and this is what will attract new customers and keep the long lasting consumers of 1.6 million websites. read more...

Read more

Patches: >.<

by Caezar M

Summary:

In the classic story that we CANNOT do anything right the first time it was announced that a patch for ASP.NET actually doesn’t help security that much at all. Microsoft released a patch that was supposed to resolve security issues for  ASP.NET and right after a hacker published a vulnerability on how to create havoc within those servers causing massive Denial of Service (DoS). now when we normally think of DoS we think that someone using massive ammounts of infected computers to simultaniously request information from one source causing the server to crash. well….this is not as cool but infinitely more effective. so basically this patch allows for a HTTP request of ~100kb to consume 100% ….wait can i modify text in here?….. read more...

Read more

SQL Poison

by Jasmine C
This article was about how a Microsoft web-based site was attacked with an SQL injection.  An advertising site in the U.K., by the name of Autoweb, was attacked with a SQL injection that left the site extremely vulnerable.  With a single line of code,  about half a million pages were affected, the sites content was overwritten and it was knocked offline. IT staff were able to originate the IP address to China and block them. The good thing for Autoweb was that they did a daily backup, so after they were able to block the IP address, they returned to their clean data.  Autoweb contained both, their web application and their database on the same server and this was a problem because to be able to protect the database, the web application also had to be protected and vice versa.  As a result of this attack, traffic and ranking has decreased but hopefully after some changes Autoweb can regain their status. read more...

Read more

Green Servers

by Mike Y

The software development life cycle (SDLC) that is known focuses on the software and the system itsself and does not take into account of environmental factors normally associated with SDLC. Huang states that recycling at the end of the SDLC is not enough to negate the environmental impact. He include how IT has helped the environment by making it easier for the public to find out about conservation, reduced usage of traditional media (paper, CDs, etc), and fuel savings from teleconferencing. Huang states one of the reasons systems are not efficient is because of the speed of the technological progress and is more concerned with success than efficiency. An environmentally friendly SDLC should minized the use of energy, consumables (ink, paper), transportation of people and goods, maximize recyclables and renewables, durable and flexible, and transferable to be used by others. read more...

Read more

Database Support

by Peter C
Summary:

Database support cost a lot for that service. It is about $36,000 per year. The service has a 24/7 service that is there if needed. It includes monitoring – tools, add-ons, proactive supports and backups. You can purchase this database support by a yearly contract.  This support will take care of the server that you are using instead of having to manage it yourself. read more...

Read more

Amazon Web Services

by Asbed P
Amazon Web Services, which is the part of Amazon.com that does the hosting and the cloud services, has announced the launch of a new server in the US West Region, in Oregon, with a new low price.  Starting Wednesday November 23, 2011, people can choose to locate their Amazon Web Services resources in the Oregon Region, which contains “multiple redundant Availability Zones for architecturing highly available applications” much like all their other AWS Regions.  Oregon will be the second US West location, the first being the Northern California servers, that will provide businesses a low cost, low latency option for everyone.  Amazon’s plan is to continuously lower its own costs so that they can end up passing those savings onto their customers in the form of these lower priced US West Region servers.  “Since the launch of AWS over five years ago, we’ve lowered our prices over a dozen times,” is a quote from Senior Vice President Andy Jassy showing the type of attitude they have about lowering prices for everyone.  US West Oregon is the fourth Region in the US and the seventh total AWS infrastructure Region in world.  It is also priced at about 10 percent lower than the US West N California Region and has the same price as the US East N Virginia Region. read more...

Read more

Call in the Apache’s!

by Andrew N

http://pdftown.com/image/4229-apache-server.jpg

Call in the Apache’s!

Covalent Technologies, which is the seller of the open source Apache 2.0 server has finally become compatible with Microsoft’s popular .Net applications. Before Apache decided to collaborate with Microsoft, Microsoft only had IIS which is the built in web server for Microsoft applications. Since Apache will now work with Microsoft, developers will a wider range of technologies supported by Apache such as Java, Perl, or PHP. The new Apache will come with an Apache Portable Runtime which optimizes its performance for Windows technology. Although Microsoft has rejected the concept of open-source programs in the past they are learning to open up and work with it now. read more...

Read more

OnLive is almost where it needs to be.

by George A

OnLive is a cloud based gaming service. The company uses emulation on their hardware to provide games that are streamed to your computer’s web browser. This allows people who normally don’t own computers with good enough hardware to run games that have very high graphics. This is also an option for someone running Mac OS X. The user accesses the OnLive website and then downloads a small file which opens a web browser on execution. The catalog of games is shown to them. Users can rent specific games, pay monthly, play a demo for free or purchase a game for close to the original price. The save data for their games is saved on the server so that they can pick up where they left off.  The tablet application is in development. OnLive also offers the micro console which allows users to play games via their home TV and without a need for their own computer. This is priced at £69.99 and offers an HDMI output. According to the article the service run perfectly on a 10mpbs internet speed. read more...

Read more

The power of server management from anywhere.

by George A

The startup company Tellago Studios has developed software to allow server administrators to monitor servers with mobile devices such as an iPhone, Android or Windows phone. The technology called Moesion connects to a specific server and then displays this information on the browser of the phone using HTML5. This software can be used with Windows Server, SharePoint, SQL Server, IIS Web Server, and BizTalk. Security has been a main concern with the development. No data is stored from the server and all of the data is encrypted in transfer. Only the commands are logged. Moesion allows the server administrators to upload scripts directly into the server from the mobile device. The software is currently in Beta. read more...

Read more