server

2014, New Year For SQL Server {1}

The next step in Microsoft’s Relational Database Management System looks promising for efficiency and speed in transaction processing. Microsoft recently held a community technology preview for the massive project and this is what was found. SQL Server 2014 will come with their new In-Memory Online Transaction Processing (OLTP) feature called Hekaton that is a built in part of the database system. Hekaton works by selecting data that is being read or written more frequently and moves it into the server’s working memory. It allows for the priority data to be quickly accessed and ready for transactions or updates on the fly. By enabling this Hekaton optimization, it detects which data should be used by the working memory and optimizes the specified data into main memory. Integrity of the data is maintained by writing any transactions to a separate log file in case of system outages. Beyond just the increased speed, companies can expect to see a saving in cost as Hekaton would reduce the computational requirements necessary to get data processing done, which would require less servers and hardware.

read more...

Node.js {4}

           (Image obtained from http://nodejs.org/logos/)

 Node.js was developed in 2009 by Ryan Dahl it was created to address issues with efficiency of traditional  platforms which took far too long to communicate over the network, spending magnitudes of more time processing web requests and responses than other parts of applications. “Node.js is a platform built on Chrome’s JavaScript runtime for easily building fast, scalable network applications. Node.js uses an event-driven, non-blocking I/O model that makes it lightweight and efficient, perfect for data-intensive real-time applications that run across distributed devices” (nodejs.org, 2013).

read more...

Covering ASP.net in the Curriculum {1}

Colleges need to teach students about new software and how to use them. There can be infinite opinions on the amount of lecturing on old versus new technology, but most can see that a mixture of both new and old is mostly beneficial for the student. The authors recommend instructing on “traditional mainframe as well as the Internet client/server environments.” Both Wallace and Wolf foresee an integration of the mainframe and web based technologies. Although the article is from 2006, it is still relevant today.

read more...

Server Side Scripting Languages {Comments Off on Server Side Scripting Languages}

My article is written by a columnist, Gary Roberts, who compare and contrasts the most popular scripting languages used to create dynamic service oriented web sites. He discusses how server-side scripting can be implemented and the software architectures involved. The comparison touches on the balance between security, productivity and service concerns. LAMP, a Linux based server running Apache, MySQL, and PHP or Perl, would ultimately require an “significant investment in knowledge acquisition.” On the other hand, Microsoft IIS, active server pages would be “the path of least resistance” because ASP would be easier to learn when compared to PHP or Perl. This is not to be confused with ASP.NET, which is a bit more difficult to learn but would be valuable to learn if you were to pursue a sizable project. The author selects Cold Fusion as his language of choice based on the ability for it to run on Microsoft, Linux, and Unix systems. In addition, it is considerably easy to learn. Ultimately, the choice of a server-side scripting language would be ranked by taking into consideration of cost, convenience, and ability to adopt or implement the technology.

read more...

Sessions What is it {6}

When we were doing the project this past week I heard a bit about sessions and I really did not get what it was all about so that is what I am going to do my article abut this week so I can learn a little more about what session is and what it is all about. Session is kind of like a cookie but is actually not stored on the users browser like a cookie would do. A cookie can keep a lot of information such as user name and password so when you use session it does not keep the information. It is like a token it alles access and passing of information while the user has the browser open. But once you close the browser you will lose the session and will have to re log in when you come back to the site because your information is not stored on the computer.

read more...

How Data Binding Works {2}

Data binding is the process that retrieves data from a given data source and associates it to attributes of the User Interface elements. Data binding gets data from the middle tier of an application and displays it in a nice looking html format. When you use data binding expressions with ASP.Net controls, behaviors are attached to the controls life cycle through the Data Binding event handlers. As developers of our web pages we have the power the trigger data binding events for individual controls or if we want to we can make it trigger all controls within the page. If you want to call for data binding you would use, <%# … %> and the data binding expression will update themselves if you do not want to call data bind, you can create a new page class that overrides the on load method. Data binding expressions can only be used with ASP.Net control markup and require you to call to the Data bind method.

read more...

Synchronizing database on mobile devices {2}

This article relates to the synchronization between mobile devices and databases. Since mobile technology as advanced and equipment have led to the emergence of a new computing environment and a variety of small sized mobile devices such as smartphones and PDAs that has been popularized. The problem is that mobile devices do not have much computing power and they rely on batteries; constant access to network is difficult due to narrow bandwidth. Mobile devices need to download the database when connected and then work off-line and by doing so there are inevitable inconsistencies between the server-side database and the mobile database. Commercial DBMS vendors offer solutions to maintain the database synchronized between the two devices however these solutions are dependent of the server-side database using dependent information such as metadata. Because of these restrictions, the extensibility, adaptability and flexibility of mobile business systems are markedly decreased. The article suggests the implementation of SAMD (Synchronization algorithms based on message digest) which resolves synchronization problems using only standard SQL queries. The SAMD makes the images at the table of the server-side database and the mobile database using a message digest algorithm; then the images and the message digest values are saved in the message digest tables on both sides. The images are compared and select the rows needed for synchronization. The SAMD would provide extensibility, adaptability and flexibility.

read more...

MySQL gets an upgrade from Oracle {Comments Off on MySQL gets an upgrade from Oracle}

The one thing that has become in a business is the importance of databases. We understand how everything is and how it flows, however, the ease to make the SQL statements can get kind of hairy. For Oracle, they have launched this new version MySQL Cluster. This new feature is actually going to be open source and is a lot easier to use. The two new features that are provided are combing the best of both worlds of NoSQL and SQL databases. ” It can rival the fast key value operations of NoSQL, while still offering the ability to do complex queries of a regular SQL databases” is how they they described it. With the open source, it can prove to be a advantage in the sense that anything is possible for this type of SQL, however, this upgrade can prove fatal for potential hackers who can get the code of how databases are filled. The main feature that is going to be great is the Memcached API. This is because this will make searches and performances go faster and as mentioned Facebook uses this software. This will make the input of data a lot easier.

read more...

Cloud Computing Data Storage and Security {Comments Off on Cloud Computing Data Storage and Security}

The article written by Lara Farra describes the benefits in contrast to the risks of cloud computing. Cloud computing is described to be a method of moving data that was previously stored in your own personal computer to be stored in someone else’s servers in order to reduce hardware costs or to access them on any device with an internet connection. Despite the convenience of cloud computing, the author points out three major flaws in the system: security, server availability, and privacy. Many of these concerns are related to hackers who are expected to pose a major threat to the security of the client’s data, as cloud computing servers are growing to become serious targets for hackers who want to extract people’s information. The lack of laws regarding cloud computing also fails to set a suitably high standard for these data storage companies, and also allows for the government to easily attain information through these servers.

read more...

SQL Incorporation into Blackberry {2}

Mobile devices have been part of our lives ever since the smart phones were created.  It’s found a way to help us organize our lives, find information, and keep people from forgetting people’s phones numbers.  Idera, who spoke to blackberry systems, has created something called, “SQL Mobile Manager 3.0″ that can create and manage SQL servers and administration.  This a great way for business people to be able to manage their accounts on the go.    To be able to access Microsoft SQL Server it has opened up the limitless abilities of a business owner.

read more...