Part 2 A : Editions, installation and Connectivity to SSMS

Summary

In 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

00:00

🚀 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.

05:02

📚 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.

Keywords

💡Microsoft SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft. It is a central theme of the video, which discusses various editions and their features. The script mentions different versions and editions, indicating the evolution and variety of SQL Server offerings.

💡Editions

The term 'editions' in the context of the video refers to the different versions of Microsoft SQL Server, each tailored to meet specific user needs and capabilities. The script outlines several editions, such as Enterprise, Standard, and Express, each with its own set of features and use cases.

💡Enterprise Edition

Enterprise Edition is the top-tier version of Microsoft SQL Server, offering a full feature set. The video describes it as having all kinds of features, including permissions, procedures, and views, making it suitable for large-scale and complex database needs.

💡Standard Edition

Standard Edition is a less feature-rich version compared to Enterprise Edition. It is designed for scenarios where advanced features are not required. The script positions it as a more cost-effective option for users with moderate database needs.

💡Workgroup Edition

Workgroup Edition is suitable for remote offices of large companies, as it allows multiple employees to connect to a particular server and work remotely. The video script suggests this edition is preferred for companies with a dispersed workforce.

💡Web-based Edition

Web-based Edition is tailored for web applications, such as those built with ASP.NET, PHP, or HTML. It is designed to facilitate database connections for web development, as mentioned in the script.

💡Developer Edition

Developer Edition is similar to Enterprise Edition but is licensed for use by a single user for development or testing purposes. The script highlights that it can be easily upgraded to Enterprise Edition without the need for reinstallation.

💡Express Edition

Express Edition is a free entry-level database offered by Microsoft. It has limitations, such as utilizing only one CPU and 1GB of memory, with a maximum database size of 10GB. The script positions it as a cost-effective option for small-scale or learning purposes.

💡Compact Edition

Compact Edition is a free embedded database designed for mobile application development. With a maximum database size of 4GB, it is specifically intended for mobile use, as illustrated in the script with the example of Android apps.

💡Datacenter Edition

Datacenter Edition, introduced in SQL Server 2008 R2, has no memory limitation and supports more than 25 instances simultaneously. The script highlights it as a powerful option for large-scale datacenter operations.

💡Business Intelligence Edition

Business Intelligence Edition is a newer introduction in SQL Server, including all features of the Standard Edition and advanced analytical features like Power View and Power Pivot. However, it lacks support for advanced availability features, as mentioned in the script.

💡Evaluation Edition

Evaluation Edition of SQL Server provides a fully functional, free instance for a limited time, typically six months from installation. It is ideal for learning and developing solutions, as described in the script.

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