Tip:
Highlight text to annotate it
X
Welcome to Group 1's presentation on the Back end database, SQL Server. My name is Sivakumar. I have
Angela, Matthew, and Kevin in our group for the discussion. Next slide please.
So, this is our agenda for the day. We want to just give a brief introduction about the
database, the SQL Server. I want to take you through the additions we have for a
SQL Server, some architecture, some technical specifications, what features which are in 2016
which is the latest version and what's the perception from the user community and what's
the scalability and comparison. Then we'll open it up for questions. So, moving right along. So, just to introduce, what
is a database and what is a database management system? Before we get into
SQL Server. There are several definitions for databases. In simple, it is nothing but
a data structure to store information. The data is well organized in such a
way, it is easy and updates. There are types, or a few types of databases,
relational are very popular, the most common one. Some examples are the Oracle,
Microsoft SQL Server, IBM's DB2, Sybase ASE. In the relational database, data is
stored in tables in the form of lateral rows and columns. The other terms that are
very popular in the database world is the RDBMS which is a relational database
management system. It is nothing but a software package designed to store, modify, and
extract information from a database. An Enterprise version of all RDMSs including
servers is available along with all the RDMSs or popular databases.
So now, let's see the evolution of Microsoft SQL Server. So, over a period of time,
I think the product has evolved and shaped up pretty well. But, just a little bit of history. Microsoft along
with Sybase released the SQL Server in 1988 which is designed for OS2 platform. The partnership
ended in 1994. Microsoft came out with the earlier version of SQL Server 6 in
1995. I personally have my (inaudible) with SQL Server, since that version and I am certified, Microsoft
Certified Professional on 6.5 version. So looking at the features, the SQL Server 2000 was
Microsoft's most prominent release with some notable changes including XML support,
performance and stability improvement, query
analyzer improvements, and data (inaudible) and BI support in that version. With the SQL Server
2005, Microsoft introduced SQL Server integration services and
the new SQL Server Management Studio,
which is a vast and powerful replacement for both Enterprise Manager and Analysis Manager. the SQL Server
2005 also introduced the report builder in this version.
2010 Microsoft introduced in 2008 R two which explained to read the integration
of Microsoft Office NSO series of BS drug use which is you know including
0.00% for XNA SharePoint this election 2008 are doing interviews domestic
terrorists overseas and domestically management solutions for consolidating
its pending information across the enterprise to a centralized location
capacity to be in the 2012 season is over twenty don't mean to do something
community that quality management
about the the master data say we've since this is actually a loan to use it
apart from a deputy counsel in standards in the data doesn't do that when I did
everything you supported the Harlem store index which is based on x-ray las
tienen bounced in memory storage and compression technology because it
actually comes in next group of humans readies for large 2002 some notable
changes in 2014 are you know and Highbridge optimist clubs and dancing to
music loud from Bri and balloons but someone's instability so when we do it
seemed that he shares of 2016 in the latest late I will note under doormat to
Angela and SQL Server offers any business is as well as data warehouse
comprehensive high and data center capabilities or demanding database
business until they business intelligence is your business
intelligence it empowers organizations to be able to build and deploy secure
scalable and manageable self-service kiosk solution the Standard Edition is
the basic database reporting and analytics capabilities it's going to be
able to provide core database data management and business with you reach
there is also an express that is intense basically ideal for developing and
powered desktop application processor operating system
the middle of course or server is the minimal uncle one day good memory at
least 21 put me stress which does allow you to popular demand at least a good
memory and that will increase as your database increases the process faster
the newer edition of SQL Server becoming available one thing you should know is
that the new edition does not now I'm gonna handed over to Kevin to discuss
the database architecture what we want to do here with the database
architecture to our first project we have here is basically the architecture
shows that request a web browser
firewall actually through the web server which the media options are on the Apple
her application security and the best part actually checks to make sure that
it has a mission to go on and then was that date is clearance process process
process are actually isolates the user from the details of the execution you
the specified there are actually two major phases of optimization and
execution is the process of choosing the best execution was the fastest way to
get the data in the fast to get that data in the car execute execute that
goes out and gets that data and then depending on where the data is stored as
you stayed at the bottom there are 32 latest orange is directly connected
so now I'll turn it back over to talk about the technical specifications and
technical specifications for Siebel Server on the slide it is also
recommended that you run the computers TFS format when installing computers
with 30 2010 neediest and the Beast and it's not recommended as the last week
was server startup is going to block installations on readonly map or
compressed routes and its sequel server fails if you watched set up their
Terminal Services client as its not supporting she will start her Management
Studio installation requires installing the.net it will automatically install
Management Studio as new installation choice she will start her installs the
following software components which are the product they are the sea lion and
the sequel start moving on to the cost we outlined because her 2014 here as the
cost for 2016 were not really what this time that you have to remember is the
cost that it is going to be her core for the pricing and as far as maintenance
and troubleshooting cause that's going to depend on the company's needs whether
they need it out the support or their house the cost will now discuss security
considerations one of the basic scary
service I is it a Louis missions and associated with the lowest prevalence
Windows users to make those are the one out separate those out the difference
service accounts for each one you make sure that occasion
well and also make sure you have arose indication one thing to remember when
you used a base as the only to make sure that her into a server not your time and
be on your knees have a strong and always enable passport or all strains
and expiration and always use a strong password and now we'll turn it back over
to talk about pictures thank you given a number I need some unique regions for
sequence 2016 along with other features that we saw in 2014 the prior-year
margins there are some improvements made when he 1621 has enhanced in Moody's
support which is no mention that would be column in store in experts from Excel
hasta technology this actually provides thirty times faster transactions more
than a hundred times consequent ease and displaced relational databases and
real-time operational analytics other features include the faster hybrid
back-ups es as a new feature to back up and restore the active databases
hi everybody everybody is looking into these these days and you know
is expected to be available on the clock
a decision using our database system way actually managed so very cool feature on
technology insecurities everything this technology provides you've been
addressed in motion but it's in the cloud or it's actually lebanese message
he always sits in application and access to the encrypted dana is only available
that's attractive feature piece so the features of 2016 and introduced into the
building advanced analytics actually the whites and scalability and only be
active database but also on the cloud databases actually supposed to be
isolation another feature added stretch denim is a new technology to be used as
a method to stretch the story on we established a cute anime studio is your
school amidst these stressed animals feature allows you have been mostly
continues during the actual appease when the less access data in the opposite is
your business is allowed
you know these are still be here he features available in 2016 I will now
turn it over to Matthew
your perception among community using cloud tool and that generated cloud here
in different words that are most commonly used based on frequency so
worried and it's used
customer reviews so you can see it very popular things from everybody says its
Microsoft and that its database
services are awkward
the market its top or queries and its competitors so there are a lot of
reviews like Microsoft SQL Server 2000 database and next show some of the
screens available for use with Microsoft SQL Server part of the reason that is so
popular is that there's an interface for every flavor it's nuts
Microsoft man prompt for all operating systems MEMS everything in like people
server from the command line if you desire most commonly used with UNIX it
also a wide range of graphical interfaces or users sure thing is it
based designer
drag-n-drop owners interaction between database technology will here in a
graphical window so you can see the various functions and the various
objects that the word actually be our server this allows you to write and
execute query on the database so and it also lose graphical analysis of your
its do you think you're on the bottom
actually will be scalability data recovery recovery for Microsoft's most
dressed using network and virtualization where you see you in real time to
separate location and stamps technology why the option of real-time data
recovery and fell over once she also knows that if you need to increase the
amount of storage in your database Microsoft
include technology
be Microsoft Azure cloud which provides scalability all the way to data
Enterprise Edition and uses massive parallel processing architecture to data
the response time for scaling into the cloud in minutes so if you suddenly have
an influx of business or application you can scale up to meet the need almost as
fast as good a while since I will be followed by Kevin to discuss some of the
pros and cons Microsoft and that's what you wanted to hear some of the
differences and similarities or the major competition the three main
differences between language and the organization of database objects
differences in the languages which is an extension of SQL Oracle used a
procedural languages in a just different dialects the second change the
transaction control transaction can be identified as a group that should be
treated the same transaction
each Amanda task individually it will be nearly impossible to roll back to change
the character with Oracle database connections trade as a new transaction
and a score is your executor commands are issued only made him every single
object to tables views and procedures database name and Oracle database
schemas
a database objects some of the areas of the last thing structure and they used a
licensing structure they're both great on the language C++ and they are both
are DBMS in the next lad we wanted to show you some are using safe harbor
46 percent market share and right now of course Microsoft Bank of America even
Ferrari use for their infrastructure and then the last talked about some things
we learn to talk about us and what we learn what I was getting not work with
it as a learning process I manage employees that work I just tell them to
get the date and they never paid attention to a poll had a doubt the
database is actually interesting to see how the process works now that actually
that was interesting to say the difference however and the abolition of
Microsoft's server and from where it started and loaded in the project
will have SQL have passed are related to take the time to understanding of how it
was actually getting information from the database i'm always dan the person
related to that just got out of it I didn't go and look at all the details
architectural layers and so these two projects that we've done so far has
definitely been out banners and they have shown the system which has been
very interested in this project I also believe all stacked and it was
interesting to see materials especially in my car out now we've actually been
writing Java programming to do a lot of things over what are you reading
technology that's out there so my dad had been working in b2b space for a very
very long time not only did you miss his BMS logical database I've ever done that
so I should cause SQL s my second language but this exercise a lot of just
new features will exploit information on SQL Server I was able to relate most of
the features with Oracle's but I deal with everyday math is in fact a recent
do you know that some of these features a cloud based technology good friend and
more importantly agency I learn more about the team members unanimously way
be worried about diaper to it so now with that will open up for any questions
that you may have noticed a professor
nice job just like the the conclusion that that's interesting because I think
you have experienced you used in these things and so when you bring that to the
table that's great I guess her my general questions are you how would you
relate a database MySQL Oracle and that certain players in the market but what
about something like my music it compares to that my day carry on that as
MySQL a mistake in an open database open source to have a game in as bad as own
drawbacks and he chose one day just I should say you know when it comes to
cost ease of use I think my seat will be tied up there this is a similar
comparison that we did about you do the any other website owners have any issues
and shooting you know you want you don't have anybody to Justine on the active
rely on the you know and he's so I would say again based on the technology the
application sensitivity I think you'll meet Amanda communication device you use
my sequences any other constant basis like the sequence that would be
established
the business intelligence and the cloud and on-site Microsoft see it
YouTube got general databases feeding directly as your business analytics and
it becomes an incredibly powerful I see it can't deliver back all around our
mystery lies you started to say and how you can tell that into web based it was
used a product like say they're not as simple question I had in this group that
asked this question but Oracle SQL Server
last effort when somebody designs databases to a database administrator
idea a database administrator is the one that it's running
whereas the person actually designed your database is the one that gets to
meet with the user's looks at what information can be held in what kind of
comes out with a structure to be in a 2004 and will run
in my professional experience i've seen
good job title change locks and designers and architects
administrator you can't help but think deeper understanding how all of your
data objects interact with each other in the system are you playing well we just
need to optimize this week so that the students return to her job so in in an
established companies had been our duties I think enemies administrator
p.m. by Deidre Lynn and making sure that I have to write access to burn up with
you seen nobody should have in mind being alone you know access and
manipulate the data the other activity did they take care of his backups making
sure these there is an obvious technology on the scene was properly
happening under the architecture they they're involved in part of the
discussion when the requirement that you know when they start looking into data
gathering
quirements blamed it on the moustache of the you know your database and then you
know the spaceman I come from the position that I support the support of
product that India vs that it actually looks like and what the internet on
running in line with the necessary access security that's my appreciating
it enjoyed that last hearing
your experience thanks a lot of small things you should also be sure and fill
out the peer evaluations
did you as feedback and I want to rely on that one more presentation at three
so after that time I'll get them posted and probably doesn't interest you that
the transcribed the rest the day that matter there any questions thank you
very much I appreciate it