We will cover the different editions of SQL Server 2016 available from Microsoft.
- [Instructor] Microsoft SQL Server 2016 is available in several different editions. Those editions are Enterprise, Standard, Web, Express, and Developer. For this course, I'll be using Enterprise Edition. However, the majority of features we're covering would also be available in Standard, or some of the other editions. Enterprise has the most features. Standard has a subset of features, but it's still appropriate for many business applications. The Web Edition, as the name implies, is the specialized edition for web servers.
The Express Edition is a free edition designed for hobbyists. It has an extremely limited feature set. The Developer Edition actually has every feature that Enterprise Edition has. It has a much lower price point. Microsoft usually prices this at $100 or less. And it's designed for people learning SQL Serever 2016. It has a license agreement that says you will not put it into production or actually use it on a production network. As mentioned, Enterprise Edition has every possible feature SQL Server could have.
SQL Server Enterprise Edition does not put any limitation on how many processors you can use. That would only be limited by your operating system. And the same with memory. SQL Server Enterprise Edition can potentially use all of the memory in your server, however high you operating system can go. Standard Edition has some limitations. The database engine is limited. Specifically, it does not support partitioning, does not support compression, and does not support in-memory tables. There's a few other features that are not supported, but I feel that these are the most important ones.
Standard Edition also has some limitations on the Business Intelligence features. The hardware limitations for Standard Edition. You're limited to 24 processor cores. The database engine is limited to 128GB of memory, and the Business Intelligence features are limited to using only 64GB of memory. If you would like more information about the specifics of the different versions, Microsoft has some very thorough documentation. The web page is called Features Supported by Editions of SQL Server 2016.
You could search for that in your favorite search engine. It's currently available at this URL.
Author
Released
11/16/2016- Installing SQL Management Studio
- Using SQL Server Configuration Monitor
- Creating a database
- Creating tables with SMS and T-SQL
- Creating relationships between tables
- Creating views
- Writing queries to return XML
- Working with XML and JSON
- Backing up and restoring SQL Server
- Monitoring and management
- Security
- Performance
- Integrating SQL Server with cloud services like Azure
Skill Level Intermediate
Duration
Views
Related Courses
-
Database Foundations: Administration
with Adam Wilbert1h 14m Beginner -
Microsoft SQL Server 2014: Backup and Recovery
with Martin Guidry1h 22m Intermediate -
Learning Microsoft SQL Server 2016
with Adam Wilbert1h 21m Beginner
-
Introduction
-
Welcome1m
-
-
1. Overview of SQL Server 2016
-
SQL Server editions2m 22s
-
2. Installing SQL Server 2016
-
Basic installation6m 22s
-
-
3. Working with Tools
-
Activity Monitor3m 31s
-
Profiler4m 20s
-
4. Creating and Configuring Databases
-
Create a database3m 16s
-
Install a sample database3m 12s
-
-
5. Creating Tables in a Database
-
Create a table using T-SQL1m 41s
-
In-memory tables3m 34s
-
Temporal tables5m 19s
-
6. Creating Views in Databases
-
Create a view3m 17s
-
-
7. Understanding Programmability
-
Stored procedures3m 23s
-
Built-in functions1m 50s
-
Scalar functions2m 10s
-
-
8. Working with XML
-
Introduction to XML1m 29s
-
Write queries to return XML2m 38s
-
Shred XML2m 23s
-
Working with XML schemas1m 48s
-
Storing XML3m 38s
-
-
9. Working with JSON
-
Working with JSON2m 29s
-
Storing JSON2m 19s
-
-
10. Backup and Restore
-
Basic backups2m 32s
-
Basic restore2m 48s
-
11. Monitoring and Management
-
Audit logins2m 35s
-
12. Security
-
Instance-level logins2m 47s
-
Database-level users2m 24s
-
Encrypt data5m 24s
-
13. Performance
-
Basics of indexes3m 4s
-
Create an index6m 18s
-
Columnstore index3m 12s
-
Explore execution plans5m 1s
-
Overview of Query Store3m 18s
-
-
14. Cloud
-
Back up to Azure3m 9s
-
Set up Stretch Database4m 46s
-
Monitor Stretch Database1m 24s
-
-
Conclusion
-
Next steps33s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: SQL Server editions