Part 2 A : Editions, installation and Connectivity to SSMS
Summary
TLDRIn this Microsoft SQL tutorial, Amir introduces various editions of Microsoft SQL Server, including Enterprise, Standard, Workgroup, Web, Developer, Express, Compact, Datacenter, Business Intelligence, and Evaluation editions. Each edition is tailored for different user needs, from full-feature sets to free entry-level databases for mobile apps. Amir also outlines the history of SQL Server versions, highlighting the introduction of new features like Power View and Power Pivot in recent releases. The tutorial promises to continue with installation and connectivity instructions for SQL Server Management Studio (SSMS).
Takeaways
- 📚 Microsoft SQL Server is available in various editions, each tailored to different needs and features.
- 🏢 Enterprise Edition is the top-tier edition with a full feature set, including advanced permissions and capabilities.
- 📈 Standard Edition offers fewer features compared to Enterprise, suitable for environments without the need for advanced features.
- 👥 Workgroup Edition is ideal for remote offices of large companies, allowing multiple employees to connect to a specific server for remote work.
- 🌐 Web Edition is designed for web applications, such as ASP.NET or PHP, that require database connectivity.
- 👨💻 Developer Edition is similar to Enterprise but is licensed for one user, intended for development or testing purposes, and can be upgraded to Enterprise.
- 🆓 Express Edition is a free entry-level database with limitations on CPU, memory, and database size, suitable for small-scale applications.
- 📱 Compact Edition is a free embedded database for mobile application development with a maximum database size of 4 GB.
- 🔊 Datacenter Edition, introduced in SQL Server 2008 R2, has no memory limitation and supports more than 25 instances simultaneously.
- 📊 Business Intelligence Edition, introduced in SQL Server 2012, includes all features of the Standard Edition plus advanced BI features like Power View and Power Pivot, but lacks advanced availability features.
- 🚀 SQL Server Evaluation Edition provides a fully functional, free instance for learning and developing solutions with a built-in expiration of six months from installation.
Q & A
What are the various editions of Microsoft SQL Server mentioned in the script?
-The script mentions Enterprise Edition, Standard Edition, Workgroup Edition, Web-based Edition, Developer Edition, Express Edition, Compact Edition, Datacenter Edition, Business Intelligence Edition, and Evaluation Edition.
What features does the Enterprise Edition of Microsoft SQL Server offer?
-The Enterprise Edition offers a full feature set, including the ability to create procedures, views, and handle permissions.
Why would one choose the Standard Edition over the Enterprise Edition?
-One might choose the Standard Edition if there is no requirement for the advanced features available in the Enterprise Edition.
In what scenario is the Workgroup Edition of SQL Server most suitable?
-The Workgroup Edition is suitable for remote offices of a large company where employees are working from different locations globally.
What is the main advantage of the Web-based Edition of Microsoft SQL Server for web applications?
-The main advantage is that it allows web applications, such as those built with ASP.NET, PHP, or HTML, to connect to the database.
How does the Developer Edition differ from the Enterprise Edition in terms of licensing?
-The Developer Edition is similar to the Enterprise Edition but is licensed for use by only one user for development or testing purposes.
What are the limitations of the Express Edition in terms of CPU, memory, and database size?
-The Express Edition can utilize only one CPU and 1 GB of memory, with a maximum database size of 10 GB.
What is the purpose of the Compact Edition of Microsoft SQL Server?
-The Compact Edition is a free embedded database for mobile application development, with a maximum database size of 4 GB.
What is unique about the Datacenter Edition introduced in SQL Server 2008?
-The Datacenter Edition has no memory limitation and offers support for more than 25 instances at a time.
What features does the Business Intelligence Edition include that are not found in the Standard Edition?
-The Business Intelligence Edition includes all features of the Standard Edition and supports advanced features such as Power View and Power Pivot, but it lacks support for advanced availability features like Always On Availability Groups.
What is the duration of the SQL Server Evaluation Edition's built-in expert?
-The Evaluation Edition has a built-in expiration of six months from the time of installation.
What is the latest version of Microsoft SQL Server mentioned in the script?
-The latest version mentioned in the script is SQL Server 2017 with version 14.0.
Outlines
🚀 Introduction to Microsoft SQL Server Editions
This paragraph introduces the various editions of Microsoft SQL Server, highlighting their unique features and use cases. Amir, the presenter, begins by outlining the range of editions available, including Enterprise, Standard, Workgroup, Web, Developer, Express, Compact, Datacenter, Business Intelligence, and Evaluation Editions. Each edition is briefly described in terms of its capabilities, with Enterprise Edition offering the most comprehensive feature set. The Standard Edition is tailored for less feature-intensive needs, while Workgroup Edition is ideal for remote offices of large companies. Web Edition is designed for web applications, Developer Edition is similar to Enterprise but limited to one user, and Express Edition is a free entry-level option with limitations on CPU, memory, and database size. Compact Edition is suitable for mobile application development with a 4 GB database size limit. Lastly, Datacenter Edition, introduced in SQL Server 2008 R2, has no memory limitations and supports multiple instances, and Business Intelligence Edition includes advanced features like Power View and Power Pivot but lacks Always On availability support.
📚 SQL Server Edition Features and Version History
The second paragraph delves deeper into the features of the Business Intelligence Edition and the limitations it has regarding advanced availability features like Always On Availability Groups. It also introduces the SQL Server Evaluation Edition, which is a free, fully functional version with a time limit of six months from installation. The paragraph then provides a historical overview of Microsoft SQL Server versions, starting from the earliest release in 1999 to the latest version at the time of the video, SQL Server 2017 with version 14.0. The presenter, Amir, promises to continue the tutorial in the next video, focusing on the installation of Microsoft SQL Server Management Studio (SSMS) and how to connect to it, concluding the video with a thank you message to the viewers.
Mindmap
Keywords
💡Microsoft SQL Server
💡Editions
💡Enterprise Edition
💡Standard Edition
💡Workgroup Edition
💡Web-based Edition
💡Developer Edition
💡Express Edition
💡Compact Edition
💡Datacenter Edition
💡Business Intelligence Edition
💡Evaluation Edition
Highlights
Introduction to Microsoft SQL Server editions and features.
Enterprise Edition is the top edition with a full feature set.
Standard Edition has fewer features compared to Enterprise Edition.
Workgroup Edition is suitable for remote offices of large companies.
Web-based Edition is best for web applications like ASP.NET or PHP.
Developer Edition is similar to Enterprise but limited to one user.
Express Edition is a free entry-level database with limitations on CPU, memory, and DB size.
Compact Edition is a free embedded database for mobile application development.
Datacenter Edition has no memory limitation and supports more than 25 instances.
Business Intelligence Edition includes advanced features like Power View and Power Pivot.
Business Intelligence Edition lacks support for advanced availability features.
Evaluation Edition offers a fully functional, free instance for learning and development.
Overview of Microsoft SQL Server release history from 1.0 to the latest version.
Business Intelligence Edition was introduced in SQL Server 2012.
SQL Server 2014 introduced with version 12.0.
SQL Server 2016 released with version 13.
Latest release is SQL Server 2017 with version 14.4.
Upcoming tutorial on installing Microsoft SQL Server Management Studio (SSMS).
Learning how to connect SSMS in the next video.
Transcripts
hi welcome to Microsoft SQL tutorials my
name is Amir this is part 2 additions
installation and connectivity to SSMS in
this session we will understand what are
different editions of Microsoft SQL
Server and their features second how to
install Microsoft SQL Server management
studio and finally we will check it out
how to connect SSMS first of all we'll
check it out what are the different
versions and different editions of
Microsoft SQL Server SQL Server is
available in various editions there you
know one is Enterprise Edition another
one is standard edition of SQL Server
and workgroup Edition web-based Edition
we are having developer based editions
Express Edition compact Edition
datacenter Edition business intelligence
Edition and finally we hang interpret
evaluation Edition as of now so let me
check it one by one we'll check it what
are the features that were having for
each and every edition of the Microsoft
SQL Server first we will check it out
what is Enterprise Edition this is the
top and Edition with the full feature
set we're having all kind of features
like you know where hand the permissions
we can create the procedures views
everything we're having in the
Enterprise Edition next we'll check it
out what is standard edition in this
standardization this is having a less
feature comparatively with Enterprise
Edition where there is no requirement of
the advanced features then in their case
we are going to use the standard
editions next workgroup Edition this is
suitable for the remote offices of a
large company so see if we are working
for the company purpose and there's a
lot of em play dirty No
bulk number of em plus or do you know
we're having so many employ like five
thousand or three thousand or more than
ten to twenty employees in that case and
they're also working from the different
different locations okay different part
of the globe then in that case will
preferred work group additions so that
they can connect to a particular
addition on particular server of the
Microsoft SQL Server and then can work
remotely this is the main advantage of
the work group okay so we can most of
the company's or prefer for the work
group edition of the Microsoft SQL
Server okay next the best defend for the
web applications so if they're having
any kind of web application like asp.net
or PHP or you know HTML different
different kind of web applications so
that they want to connect to the
database so in that case they will
prefer web-based Edition Microsoft SQL
Server anything next developer edition
this is similar to enterprise only but
license to only one user only for the
one development purpose or one testing
purpose and one demo so it can be used
to upgrade to enterprise without any
reinstallation so we can upgrade if you
want to enterprise we can go ahead way
it is a very simple step or we're just
going to upgrade it so that it will
convert easily into Enterprise Edition
next Express Edition this is free entry
level database it can utilize only one
CPU and 1gb memory only the maximum size
of the DB is 10 GB okay this is reason
it's a Express Edition that what we'll
call it next compact Edition this is the
free embedded database for mobile
application development the maximum size
of the database is 4 GB only this is
using for the mobile purpose only mobile
application development purpose if you
see right now we're hangs a marine right
now Android
there's a different different mobile
apps that coming into picture into the
market so for if you want to use it that
will go will prefer compact edition so
the Magnum size of the DB is for to be
only okay next data center the major
change in SQL Server 2008 or two is the
datacenter edition the datacenter
edition has no memory limitation and
offers supports for more than 25
instances at a time okay next business
intelligence so business intelligence
Edition is the new introduction in SQL
Server 2000 includes all features in the
standard edition and supports for the
advanced behave features such as power
power view power pivot but it lacks
support for the advanced availability
features like always on availability
groups and other online operations okay
so as we said this the things that what
are the features that were hanging Power
View power pivot and it won't support
always-on feature availability this is
oh no always-on feature is available for
the remaining the previous versions like
you know previous editions like
enterpriser and all the things but
there's always on availability is not
available for the business intelligence
available this is the lack of the next
enterprise evaluation the SQL Server
evaluation Edition is a great way to get
a fully functional and free instance of
the skills or for learning and
developing solutions this edition has a
built in expert a of six months from the
time of your installation in it okay
these are all different different
editions of Microsoft SQL so we have
gone through the different different
work different different editions of the
Microsoft SQL next we will check it out
what are the Microsoft server version
list that we are having if you see on my
screen there are different different
versions of them of the Microsoft
SQL Server release history there if you
see the first version has been sorted
with the one point rule in 1999 so the
release name is a school's over 1.0
16-bit it's a code name as given as
Philippi so and there's no internal
worship and then it has been started one
point one four point two a four point to
be and then later on it have been now
you know it's called in 1995 scheme with
6.0 version with the SQL Server release
history if you see that it is calls or
6.0 writing on the latest if you see I
have given two tone to Earl SQL Server
2012 with eleven point four worship so
in this area that they have introduced
business intelligence Edition okay
later on SQL Server 2014 release name
and 2014 with the version of Tor 0.0
right now we're having SQL Server 2016
with taken point version and the latest
release is SQL Server 2007 teen with
fourteen point four version in the next
video we'll continue how to install in
Microsoft SQL Server management studio
and also we will learn how to connect
SSMS thank you for watching this video
have a great day
Weitere ähnliche Videos ansehen
SQL Server Tutorial For Beginners | SQL Server Management Studio Install & Tips 2022
Complete CRUD Operation in Asp.Net C# With SQL Server Step by Step
Asp.net sql server database connection tutorial
Cómo instalar y configurar SQL Server 2019
2 - Planning for an On-Premise SQL Server to Migrate to Azure
Dream Report: Acquiring Data from SQL Server
5.0 / 5 (0 votes)