Free Essay

Unit 1 Research Paper

In:

Submitted By mikeym87
Words 1606
Pages 7
Michael Malate
June 23, 2013
SP2520
Unit 1 Research Assignment 1: Exploring Programming Languages

From the looks of it there seems to be 14 different revisions of the SQL standard. * SQL Server version 1.0: SQL Server version 1.0 is a 16 bit server modeled in the year 1989 for supporting OS/2. * SQL Server version 1.1: SQL Server version 1.1 is also a 16 bit server designed in the year 1991 to support OS/2. * SQL Server version 4.2: SQL Server version 4.2 was released in the year 1992. SQL 4.2 is bundled with IBM OS/2 1.3 version. * SQL Server version 4.21: In the year 1993, Microsoft server 4.21 came into existence. SQL 4.21 was the first version of SQL Server that supports Windows NT. * SQL Server version 6.0: In 1995, SQL Server version 6.0 was introduced. After Windows NT, Sybase and Microsoft parted and worked on their individual design. SQL Server version 6.0 was the chief version aimed in provision of Windows NT by Microsoft. * SQL Server version 6.5: SQL Server version 6.5 got released in the year 1996. * SQL Server version 7.0: SQL Server version 7.0 was the rewritten version from Sybase legal code. The code name of SQL Server version 7.0 is Sphinx. SQL Server version 7.0 was introduced in 1998. In 1999, SQL Server version 7.0 with OLAP tools came into site. * SQL Server version 8.0 / SQL Server version 2000: SQL Server version 2000 was the first one made of IA-64 architecture. Several advancements have been made in SQL Server version 2000 which improved its performance. Later in the year 2003, SQL Server version 2000 with 64-bits was released. * SQL Server version 9.0/ SQL Server version 2005: SQL Server version 2005 was released in October, 2005. SQL Server version 9.0/SQL Server version 2005 offers enhanced support for XML data apart from relational data and also IDE tools, an ETL tool, an OLAP server and many more. * SQL Server version 2008 or SQL Server version 10.0 version: SQL Server version 2008 was released on August 6, 2008. SQL Server version 2008 or SQL Server version 10.0 included full text search functionality, new file stream data type, two different storages for spatial data and many others. * SQL 10.25: SQL Azure or SQL 10.25 was introduced in the year 2010. * SQL Server version 2008 R2: A feature for master data management was included in SQL Server version 10.5 or SQL Server version 2008 R2. * SQL Server version 11: SQL Server version 11, code named Denali CTP1 was released on 8thNovember 2010. SQL Server version 11 is enhanced with vertipaq column oriented DB technology. * SQL Server 2012

______________________________________________________________________________

The new SQL Server 2012 features include the following:

Version Components and Numbering:

The following concepts are useful in understanding the behavior of SQL Server for side-by-side instances of SQL Server.
The standard product version format for SQL Server is MM.nn.bbbb.rr where each segment is defined as:
MM - Major version nn - Minor version bbbb - Build number rr - Build revision number
In each major or minor release of SQL Server, there is an increment to the version number to differentiate it from earlier versions. This change to the version is used for many purposes. This includes displaying version information in the user interface, controlling how files are replaced during upgrade, applying service packs, and also as a mechanism for functional differentiation between the successive versions.
Components shared by all versions of SQL Server
Certain components are shared by all instances of all installed versions of SQL Server. When you install different versions of SQL Server side-by-side on the same machine, these components are automatically upgraded to the latest version. Such components are usually uninstalled automatically when the last instance of SQL Server is uninstalled.
Examples: SQL Server Browser and Microsoft SQL Server VSS Writer.
Components shared across all instances of the same major version of SQL Server
SQL Server versions that have the same major version share some components across all instances. If the shared components are selected during upgrade, the existing components are upgraded to the latest version.
Examples: Integration Services, Master Data Services, SQL Server Management Studio, SQL Server Data Tools (SSDT), and SQL Server Books Online.
Components shared across minor versions
SQL Server versions that have the same major.minor version shared components.
Example: Setup support files.
Components specific to an instance of SQL Server
Some SQL Server components or services are specific to an instance of SQL Server. These are also known as instance-aware. They share the same version as the instance that hosts them, and are used exclusively for that instance.
Examples: Database Engine, Analysis Services, and Reporting Services.
Components that are independent of the SQL Server versions
Certain components are installed during SQL Server setup, but are independent of the versions of SQL Server. They may be shared across major versions or by all SQL Server versions.
Examples: Microsoft Sync Framework, SQL Server Compact.
For more information about SQL Server Compact installation, see Install SQL Server 2012 from the Installation Wizard (Setup). For more information about how to uninstall SQL Server Compact, see Uninstall an Existing Instance of SQL Server (Setup).
Using SQL Server Side-By-Side with Previous Versions of SQL Server

You can install SQL Server on a computer that is already running instances of an earlier SQL Server version. If a default instance already exists on the computer, SQL Server must be installed as a named instance.
Microsoft SQL Express features: * SQL Server Configuration Manager * Replication * Advanced Query Optimizer * SMO/RMO * Integration with Visual Studio 2005 * Service Broker * SQL CLR * Multiple Active Result Sets
Limits of Microsoft SQL Express: * SQL Mail * Fail-over clustering * Distributed partitioned views * VLA protocol support * Log shipping * Parallel DBCC * Parallel Create Index * Enhanced Read Ahead and Scan * Indexed views * Partitioned views
Oracle Express Features: * Direct Path Load API * External tables * External procedures * Advanced Queuing * Basic Replication * Distributed queries * Distributed transactions * Generic Connectivity
Limits of Oracle Express: * Advanced Security Option * interMedia * Messaging Gateway * Oracle Change Management Pack * Oracle Clusterware * Oracle Configuration Management Pack * Oracle Connection Manager * Oracle Data Guard * Oracle Data Mining * Oracle Diagnostic Pack * Oracle Enterprise Manager * Oracle Fail Safe * Oracle Label Security * Oracle Names * Oracle OLAP * Oracle Partitioning * Oracle Real Application Clusters * Oracle Spatial * Oracle Streams (Apply process only) * Oracle Tuning Pack * Oracle Workflow * Oracle Workspace Manager * Ultra Search
DB2 Express Features: * Bi-temporal data management using the time travel query feature. * Always on Transactions using High Availability and Disaster Recovery (HADR) to minimize data loss. * Enhanced security through Row and column and Label based access control features. * Flexible application development and management, including an integrated tools environment,and SQL compatibility features to help you develop, manage, migrate and standardize diverse data assets. * Future proof versatility with NoSQL Graph Store and IBM Mobile database synchronization and support.
Less
Bi-temporal data management * Provides the infrastructure for time-aware analytics to run time-specific queries. This helps reduce the operational complexity of collecting and analyzing time-based data. * Allows data to be queried as currently exists at any points in the past, or as it will be at some point in the future.
Always on Transactions * Helps ensure that critical databases remain available around the clock. HADR allows rapid failover from a primary or standby server and requires little time to set up. * Allows multiple HADR standby databases. * Multiple standby setup helps to protect your data while keeping it highly available, with a single technology. * Supports replication at the schema level. This means that any newly created table is set up for replication.
Enhanced security * Includes label-based access control to help you secure data access and control security risks. * Offers row and column access control to help you regulate data access at the row level or column level, or both. This feature can be used to complement the table privileges model.
Flexible application development and management * Includes IBM Data Studio, which provides an integrated, modular environment for database development and administration of IBM DB2 for Linux, UNIX and Windows. * Enables you to create and manage heterogeneous database environments to help increase productivity. * Includes a SQL compatibility feature to help simplify and reduce the risk of database migration. For applications running on comparable Oracle databases, requires few or no code changes to run on DB2.
Future proof versatility * Includes IBM Mobile Database, a relational database that runs on your mobile device, to help you manage data on mobile and embedded devices. * Together with IBM solidDB and its advanced replication and universal cache capabilities, you can synchronize data between mobile devices and IBM databases. * Using NoSQL Graph Store, provides an optimized way to store and work with graph triples inside DB2. * Allows you to store graph triples with the added benefits of ACID compliance, data compression, parallel execution, load balancing, backup and recovery and advanced security.
In comparison they are all great choices to have for small or even more than an average size business. It’s all up to preference and what features will be taken more advantaged of with the needs and resources of the company.

References
Rapid Programming: http://www.rapidprogramming.com/questions-answers/What-are-the-different-versions-of-SQL-Server-and-when-was-it-released--638
MSDN: http://msdn.microsoft.com/en-us/library/ms143694.aspx
MSDN: SQL Server Express Features: http://msdn.microsoft.com/en-us/library/ms165636(v=sql.90).aspx
BC Burleson Consulting: http://www.dba-oracle.com/t_xe_features_oracle_express.htm

Similar Documents

Premium Essay

Unit 1 Research Paper 1

...Friday class 6-10 pm Unit 1 research paper 1 Computers are an amazing tool that we as a people have developed. Computers help people in so many ways it almost seems like life would be impossible without them. Computers are used in pretty much every aspect of life in today’s world. The technology of computers is amazing and it just continues to get more powerful every day. Computers have had an impact in just about every industry in the world. Computers made medical procedures so much easier. Now doctors can do surgery using cameras and computers. This makes it easier for the doctor and results in less mistakes and better recovery. The patients receive smaller openings when receiving computer integrated surgery. The doctor can move a lot more accurately and cut more accurately with this technology. Another way that computers have impacted the world is by harnessing the power of the internet. The internet is a great tool for everybody. It makes studying and researching a lot easier for students. It also helps people communicate. Communication has never been easier. People in the United States can talk to somebody across the world with a click of a button. This also means people are more aware of what goes on throughout the world. Computers are also in cars. Google has developed a car that can drive itself. This is huge because the computer can actually drive your car for you. According to Technology review.com “Google’s cars have successfully driven more than 700,000 miles...

Words: 402 - Pages: 2

Premium Essay

Unit 1 Research Paper

...Christopher Hernandez GS 1145 Introduction: Mobile Technology has evolved rapidly over the past few years. A standard mobile device has gone from mobile phone to a hand held gaming system, web browser and GPS navigation device. Not to mention the ever so popular tablet computers. Summary of key findings: Mobile Technology has led to anyone being reachable at anytime, day or night. It has literally shrunken the world to the palm of your hand. Although convenient I believe it has led to a people becoming Anti- social. Due to the lack of personality it has become common for people not to know how to react to real world problems. The environmental impacts of mobile technology are overwhelming. It is estimated that 61 percent of the world population owns some type of mobile device. It leaves us with 140 million phones being dumped in landfills. Not to mention the cardboard packaging and foam going to waste increasing the amount of trash. Keeping a mobile device on person makes it easier than ever to contact 911 in case of an emergency immediately. With no need to waste time trying to locate a phone to use. It is estimated that 70 percent of 911 calls are made from a mobile device. Even in non emergencies, for example a car emergency mobile devices make requesting help much easier. Conclusion: We are already seeing a slow down in the advancement of mobile technology. Not because a lack of technology, But a lack...

Words: 331 - Pages: 2

Premium Essay

Unit 1 Research Paper

...Christopher Hernandez GS 1145 Introduction: Mobile Technology has evolved rapidly over the past few years. A standard mobile device has gone from mobile phone to a hand held gaming system, web browser and GPS navigation device. Not to mention the ever so popular tablet computers. Summary of key findings: Mobile Technology has led to anyone being reachable at anytime, day or night. It has literally shrunken the world to the palm of your hand. Although convenient I believe it has led to a people becoming Anti- social. Due to the lack of personality it has become common for people not to know how to react to real world problems. The environmental impacts of mobile technology are overwhelming. It is estimated that 61 percent of the world population owns some type of mobile device. It leaves us with 140 million phones being dumped in landfills. Not to mention the cardboard packaging and foam going to waste increasing the amount of trash. Keeping a mobile device on person makes it easier than ever to contact 911 in case of an emergency immediately. With no need to waste time trying to locate a phone to use. It is estimated that 70 percent of 911 calls are made from a mobile device. Even in non emergencies, for example a car emergency mobile devices make requesting help much easier. Conclusion: We are already seeing a slow down in the advancement of mobile technology. Not because a lack of technology, But a lack...

Words: 331 - Pages: 2

Free Essay

Gs1140 Unit 1 Research Paper 1

...Unit 1 Research Paper 1: Paradigm Shift Introduction In the past, virtual reality technology was thought of by many as a gimmick, and the hope for it to become a mainstream technology was discarded as products did not work as how the public envisioned. However, the proper technology is now available to make virtual reality just that: a reality. The entertainment industry is on the verge of a monumental paradigm shift that will completely transform the way these entertainment mediums are experienced. The typical experience of video games is one with a controller with joysticks that are used to control where the playable character is looking along with a monitor or television screen in front of the player. Today, this scenario is so typical that the detachment between the player and what is happening on the screen is something considered to be normal in the experience. In the next couple years however, this detachment will be largely erased as working virtual reality headsets become available to consumers across the world. Summary of Key Findings One notable product in the field of virtual reality technology is the Oculus Rift. What makes this product and others like it different from the virtual reality fad that permeated the entertainment industry a few decades ago? The Rift uses 360 degree low latency head tracking, an integral part of the complete virtual experience. In previous VR headsets, the latency, or delay, between a player’s head movement and the visual representation...

Words: 658 - Pages: 3

Free Essay

Unit 2: Research Paper 1

...Unit 2: Research Paper 1 GS1140 The speed limit is 65 mph and I’m at a stand-still! Why must this happen every morning and afternoon? Traffic will always be an ongoing problem. The more the population grows, the more congested our roads get with more vehicles. Besides leaving hours before traffic starts to avoid traffic jams there has to be another solution. Some solutions include: employee parking cash-out, tolls for single use carpool lanes, and tolls during high peak hours on freeways. An employee cash-out can reduce the amount of vehicles on the road by giving an incentive not to drive (Bullokk, 2011). Companies would give a certain amount each month to the employee who participates in the program. Through data mining, the decrease in the demand of parking can be obtained. The information needed to gather this would be: the number off employees in the program, the financial incentive amount, and the amount of time the incentives were given at separate but equal intervals (Bullock, 2011). A decrease in cars on the road would limit the amount of traffic on the road and also free up precious parking space. Tolls for single use carpool lanes will also benefit in decreasing traffic. The carpool lane is mostly always free of traffic during rush hours which is good for carpoolers, but also counter intuitive. The carpool lane turns into a wasted lane if people are not taking advantage of carpooling. Sensors can be placed in cars to automatically charge the fare for...

Words: 373 - Pages: 2

Premium Essay

Unit 2 Research Paper 1

...Cindy Vargas GS 1140 Unit 2 Research Paper 1 The issue that I want to bring to the table is that our prisons in the United States are filling quickly with repeat offenders. If there was a way to rehabilitate the prisoners why not take it? It would appear from the research that I’ve done that our prison system is geared more towards punishment than rehabilitation. Throughout this paper I will discuss the program I think we need to help reduce the overcrowding of prisons and the return of previous criminals. The Department of Justice data shows that around 730 in every 100, 000 people are incarcerated in the U.S. We currently have 2.2 million people behind bars equal to the size of Houston, Tx. (Natasha Lennard, 2012). My proposition is to adopt the Israeli rehabilitation program into our justice system. Israel is a small country of a population at about 8 million people. This small country has 32 prisons and only estimated 18, 000 people incarcerated. Their recidivism of repeat offender rates are amongst the lowest in the word (Matt Lebovic, 2012). At Hermon prison in Galilee still has the same security measures that you expect from a prison. The way that they treat the inmates and the way the inmates interact with each other is what makes this program so special. The inmates aren’t called inmates they are called “residents”, they walk around the prison as if were a college campus. The unrestricted access to each other is what helps them integrate back into society. They...

Words: 750 - Pages: 3

Free Essay

Unit 2 Research Paper 1

...Erick Pertell Unit 2 Research Paper 1: Experiment Problem Solving Theory My SOLUTIONS to STOP and PREVENT bullying 1.) STOP bullying... Parents should change the way they parent their children at home If you see someone that is being bullied, tell an authority figure Be confident Ignore the bully and walk away Do not engage in fights When in an uncomfortable situation, have friends to back you up.  Your strength is in numbers. Find friends that share your interests or have also been bullied.  A great way to make new friends is by sharing something in common with others.  You can make new friends by getting involved in school and extracurricular activities. 2.)To PREVENT bullying from starting... Start a friendship club Compliment Week (Make people feel good about themselves) Have a "Sit with Someone you Don't Know Day" and meet new people and make new friends Take pledge to stop bullying Hold school assemblies informing students of what bullying is Counselors (Talk to counselors about what can be done to prevent people from bullying) Donate to Anti-Bullying Organizations --------------------------------------------------------------------------------------------------------------------------------- 3. What Schools Can Do To Stop Bullying: Hold assemblies showing students how to deal with bullying.  Also show the consequences. Hire professional therapists to help students cope with bullying. Have a "bully hotline" where students can share their problems...

Words: 684 - Pages: 3

Free Essay

Gs1140 Unit 1 Research Paper 1

...3D Printing: Impacting Our Future 3D Printing, also known as additive manufacturing, is a technology that has been around for a while already, but in recent years technological advances have made it significantly cheaper and more attainable for many people. You can print 3D images designed on a computer with a 3D modeling program, or you can scan an object with a 3D scanner to be replicated. To print the model of the digital file the program hypothetically slices the image into a bunch of different horizontal layers. There are a few technologies used for 3D printing, the most widespread technologies are Selective Laser Sintering (SLS), and Fused Deposition Modeling (FDM). In the SLS method a high powered laser melts and fuses tiny particles of metal, plastic, ceramic, or glass powder until the desired shape is achieved. In the FDM process a continuous feed of metal or plastic wire is fed through a heated nozzle melting the material briefly while it forms the object. One major impact that 3D printing could impact the future is bio-printing, or the replication of human bodily tissue through 3D printing. If you’re in need of a new kidney, instead of waiting for a compatible donor, the doctor, in theory, would be able to go to his computer load up kidney.obj press ctrl + p and within minutes begin the operation. There are many more ways the technology could help the medical fields of study, such as reproducing human bones or blood vessels. Artificial limbs could...

Words: 680 - Pages: 3

Premium Essay

Prog Research Paper Unit 1

...1970’s Dartmouth Basic- was created by John Kemeny and Thomas Kurtz on May 1, 1964. Basic stands for Beginners All-purpose Symbolic Instruction Code . The aims of the BASIC system were: to develop a system and language that was friendly, easy to learn and use, to introduce computing as an adjunct to other courses, to operate an open access policy (i-programmer.info, 2010). Pascal- was created by Niklaus Wirth in 1972. He wanted a language suitable for teaching but for teaching computer science. It is best described as a simplified version of Algol. It was simplified both to make it easier to learn and to make it easier to compile (i-programmer.info, 2010). C- Was created by Ken Thompson iin the form of B and tweaked by Dennis Ritchie and renamed C in the 1970’s. It was the original code Unix was written in. Its function was for ease of use (i-programmer.info, 2010). Forth- was created by Charles H Moore in the 1970’s. The motivation behind this language was for both interactive execution of commands and the ability to compile sequences of commands for later execution (i-programmer.info, 2010). PLEX (Programming Language for EXchanges)- was created by Goran Hemdahl at Ericsson in the 1970’s. It is a special-purpose, pseudo-parallel and event-driven real-time programming language dedicated for AXE telephone exchanges, It is a propriatary language (i-programmer.info, 2010). 1980’s Atari ST BASIC – Atari commissioned MetaComCo to write a version of BASIC that...

Words: 1761 - Pages: 8

Premium Essay

Nt1310 Unit 1 Research Paper

...Task 1: Speech is the ability humans have developed to communicate between themselves with the sound produced by their mouth and nose. There are two types of speech sounds: The voiced and unvoiced one. A voiced sound is created when air pass through our vocal cord in direction of the mouth. This air vibrates in a certain frequency, normally between 50 and 400 Hz that produces the sound heard and desirably understood by the receiver ears. This frequency is controlled by varying the shape of the air channel, as changing the mouth position or the tongue, working as a filter, allowing the desired frequencies for the expected sound to pass; and by the speaker age and sex. The unvoiced speech are created by making air go through an opening, not vibrating the vocal cords, and, consequently, not been as...

Words: 851 - Pages: 4

Premium Essay

Pt1420 Unit 1 Research Paper

...Year 10 Individual Student Research Project 2015 Aim To find which genre of game causes the greatest rise in your heart’s BPM. Background Information The experiment I am conducting is in order to determine which genre of game causes the greatest rise in a person’s heart rate. A video game is an electronic game that involves human interaction with a user interface to generate visual feedback on a video device. Studies have shown that playing video games with violent or disturbing imagery can have short or long-term physiological effects. Here we are measuring the primary. I believe that this experiment is relevant in today’s society as at the moment, 59% of people play video games regularly, and over 80% of people have a video game console...

Words: 1720 - Pages: 7

Premium Essay

Nt1330 Unit 1 Research Paper

...Task 1 Describe the following: a. Hardware e.g.: web server, mail server and proxy server Web server is a server that helps you to connect to the internet also it helps to deliver web content pages. Web servers also mange all websites. A mail server is a server that passes e-mail over a network. A mail server also can receive incoming e-mails from local users. For example your local shop or our local charity shop. A proxy server is computer that functions as connection between a web browser and the Internet that means that the proxy server is between your computer and any other internet. Proxy servers helps improve web performance by saving the webpages that you use normally. Proxy servers are good because they are also responsibly for checking...

Words: 1106 - Pages: 5

Premium Essay

Nt1310 Unit 1 Research Paper

...NAME : CHOW MENG HONG STUDENT ID : GEC 0000 OD1 UNIT CODE : VU21323 TASK 1 1. I’LL COMPLETE THE EAL CERTIFICATE III AND IV HERE IN MELBOURNE AND AFTER THAT I’LL GO BACK TO MALAYSIA TO WORK AT A HIGHER POSITION IN MY WORK. 2. I WANT TO IMPROVE MY SPEAKING AND LISTENING SKILLS IN THIS CAREER 3. I CAN MOSTLY COMPLETE READING AND WRITING, BUT MY SPEAKING AND LISTENING SKILLS STILL NEED TO BE IMPROVED. 4. I HAVE COMPLETED A SECONDARY SCHOOL LEVEL AND LCCI LEVEL IN MY COUNTRY, MALAYSIA. 5. I NEED TO TAKE CERTIFICATE III AND IV IN EAL COURSE FOR MY CAREER. 6. GOOGLE.COM 7. TWO YEARS. 8. MELBOURNE 9. - IMPROVE MY LISTENING SKILL - IMPORVE MY SPEAKING SKILL - COMPLETE CERTIFICATE III IN EAL - COMPLETE CERTIFICATE IV IN EAL - BACK TO MALAYSIA - WORK...

Words: 1034 - Pages: 5

Premium Essay

Unit 1 Networking Research Paper

...Introduction to Networking We often use the work “network”, without knowing what the real meaning is or what the technical meaning is. In easy words, a network is a group of computers connected by a transmission device. A computer which is not connected to any other computer is called a “stand-alone computer”. There are also 2 types of networks, peer-to-peer and client/server. Peer-to-peer is a ‘small’ group of computers directly connected. In peer-to-peer, all computers have authorization to do whatever and resources maybe equally shared. An example of peer-to-peer is connecting several computers to 1 Windows account, allowing them to be connected. Another type of network is client/server. In client/server, there is a main computer which...

Words: 1734 - Pages: 7

Premium Essay

Nt1310 Unit 1 Research Paper

...Q1. (i) I have depicted the 3 naturally accruing isotopes of hydrogen. Hydrogen-1, sometimes known as Protium or just hydrogen, hydrogen-2, also known as Deuterium and finally Hydrogen-3, which is also known as Tritium. Although each isotope has a different number of neutrons; 0, 1 and 2, respectively. This has no impact on their chemical properties. But, it does however affect the physical properties. Namely their mass. Whereas Hydrogen-1 has an atomic mass of 1amu, Hydrogen-2 has an atomic mass of 2, due to the presence of a neutron in addition to the proton within the nucleus. And Hydrogen-3 has an atomic mass of 3amu as a result of another additional neutron. Each isotope also differs in its’ nuclear binding energy, this is a result...

Words: 1878 - Pages: 8