Unit 1 Research Essay

Submitted By MichaelBWhite
Words: 496
Pages: 2
Open Document
George Olivo
Pt2520
3/19/14

Unit 1 research assignment 1:

1.
SQL Server Release History
Version
Year Release Name
Codename
1.0
(OS/2)
1989
SQL Server 1.0
(16 bit)
-
1.1
(OS/2)
1991
SQL Server 1.1
(16 bit)
-
4.21
(WinNT)
1993
SQL Server 4.21
SQLNT
6.0
1995
SQL Server 6.0
SQL95
6.5
1996
SQL Server 6.5
Hydra
7.0
1998
SQL Server 7.0
Sphinx
-
1999
SQL Server 7.0
OLAP Tools
Palato mania
8.0
2000
SQL Server 2000
Shiloh
8.0
2003
SQL Server 2000
64-bit Edition
Liberty
9.0
2005
SQL Server 2005
Yukon
10.0
2008
SQL Server 2008
Katmai
10.25
2010
SQL Azure DB
CloudDatabase
10.5
2010
SQL Server 2008 R2
Kilimanjaro (aka KJ)
11.0
2012
SQL Server 2012
Denali
12.0
2014
SQL Server 2014
SQL14

There are 15 versions since the standard and the most current is SQL Server 2014.
The following features were added to SQL Server 2014:
Memory optimization (In Memory OLTP)-improves performance and it is integrated into the SQL Server Engine
Windows Azure- allows to run on premises or in VM Wizard to host a database
Enhancements for SQL Server Backup and Restoration
Allows backup to URL for task and maintenance plans
Allows the server to manage backups to Windows Asure
Encryptions for backups

Better and new design for Cardinality Estimation-corporates assumptions and algorithms
Delayed Durability-transaction log can be controlled at the database lever
Enhancements for Always On Failover Cluster Instances and Always On Availability Groups
An Add Azure Replica Wizard, secondary replicas increased from 4 to 8
Secondary Replicas remain available for read workloads after being disconnected from the Primary
Failover cluster Instances (FCIs) can now use Cluster Shared Volumes (CSVs)
New System Function
Partition Switching and Indexing-individual partitioned tables can now be rebuild
Managing the Lock Priority of Online Operations
Column store Indexes
Database Compatibility Level
Security Enhancements
Deployment enhancement

Comercial Database Name
SQL Express
Oracle Express
DB2 Express
Features

10GB of storage per database, easy backup and restore, compatibility with all editions of SQL Server and Windows Azure SQL Database, web & small server applications, full version of SQL Server 2014 Management Studio instead of SQL Server 2014
Show More

Related Documents: Unit 1 Research Essay

Unit 1 D1 Research Paper

Unit 1: D1 - Corrections The human reproductive system contains all the relevant organs needed for reproduction. Conception occurs in the female's fallopian tube when a single male sperm meets one of the two females egg, which is called the ovum, which then fertilises the egg. The fertilised egg contains genetic material from both the mother and father, and this is when conception occurs and a new life begins. Fertilisation occurs when an egg cell and a sperm cell meet and combine together. This…

Words 1247 - Pages 5

Unit 2 Research Paper 1

sheet (sheet with all of the information needed to complete the mission). We knew that the issue wasn’t a user error on our part. After checking to make sure we didn’t fat finger (insert wrong information), we contacted our unit to verify the cut sheet was correct. Within the unit they would occasionally send out old cut sheets that will not work with our current mission. Everything with the cut sheet is verified and we begin to think of equipment issues. We decided the next best step would be to power…

Words 590 - Pages 3

Nt1330 Unit 1 Research Paper

1) a)Specify your protocol by listing the messages exchanged and the action taken by the automatic teller machine or the bank’s centralized computer on transmission and receipt of messages. Solution : There may be various types of message exchange. Given is a possible message exchange. Message from ATM to Bank Centralized computer(server) Message Description INSERT To notify server that a user has inserted ATM card. PIN User inserts pin number and send to server. OK Request Operation BALANCE…

Words 387 - Pages 2

Nt1310 Unit 1 Research Paper

Unit Two questions/project – set ii Short Answer What do you call a piece of code that attaches to an application program and secretly spreads when the application program is executed? Viruses are codes that attach to an application program and secretly spread themselves when the application program is executed. What do you call a program that performs a useful task while at the same time carrying out some secret destructive act? A Trojan horse is a program that performs a useful task while at…

Words 954 - Pages 4

Nt1310 Unit 1 Research Paper

1.2 Describe the technology of each component in terms of its operating principles. Keyboard When you press a key, the keyboard controller detects the keystroke, the controller places a scan code in the keyboard buffer, indicating which key was pressed. The keyboard sends the computer an interrupt request, telling the CPU to accept the keystroke. Operating system responds controller repeats the letter if held. (White, 2008) Mouse Nowadays optical mouses are widely used. The main components of…

Words 1204 - Pages 5

Ww1 Unit 1 Research Paper

The rise of nationalism all over the world has contributed to global security. According to Stanford Encyclopedia of Philosophy, nationalism describes two phenomena’s: “(1) the attitude that the members of a nation have when they care about their national identity, and (2) the actions that the members of a nation take when seeking to achieve (or sustain) self-determination.” To understand nationalism, we must first know what nation and state are. A state is a political entity that has control of…

Words 529 - Pages 3

Nt1310 Unit 1 Research Paper

One of the main advantages of 4-20 mA is that you can run 2-wires to the sensor, which saves much cost in long runs, but does have drawbacks. The biggest is the "loading". The sensor "steals" 10V type to operate its electronics. If you’re receiving end uses a 250 ohm resistor (typ), that is another 5V, so your power supply must output 15 V plus wiring drops. Not usually a problem with the typical 24 V power supply. 3-wire systems allow more margin since the signal isn't in series. Other drawbacks…

Words 1822 - Pages 8

Ar 670 Unit 1 Research

AR 670-1 explains what is authorized to wear and how to wear it. Because the Army is a uniformed service, discipline is, in part, judged by personal appearance, both in and out of uniform. Following the prescribed standards and taking pride in my appearance, are both parts of being a soldier, whether I’m in or out of uniform, whether I am on duty or off. Not only does this include my dress and personal grooming, this also includes my level of physical fitness and remaining within my approved weight…

Words 1090 - Pages 5

Nt1310 Unit 1 Research Paper

Becoming a person with a huge network is a great thing while becoming someone who is able to connect the network with other networks is much greater. This is my principle to gain a network in my life as I firmly believe that networking is not about just connecting people. More than that, networking will connect people with people, people with idea, people and people with opportunities. Therefore, I always develop my networking skill by connecting networks I had with other opportunities to gain new…

Words 499 - Pages 2

Ww1 Unit 1 Research Paper

Many things and people should be remember from the armed forces. Many things were given up and many things were gained. From all the work of the military Canada were able to conquer many things over time like helping to win the great war and becoming Canada itself. Without the help from many others this could not have be done though. Many people should be remembered but there are some big ones that people never do. Some being like Aboriginals, Blacks and Women. But one that really should be is women…

Words 817 - Pages 4