Now let's take a look at the Editions that are going to be offered for SQL Server 2012. There's going to be Three Main Editions, notice the good news, you can get them in 32-bit or 64-bit. And these three main additions are going to be the Standard Edition, the Business Intelligence Edition or the Enterprise Edition. And as usual Microsoft's going to offer three special editions, again both 32 and 64-bit, the Developer Edition, the Web Edition and the Express Edition. So let's take a look at each one of these and talk about some of the features you get and some of the characteristics of them. First of all, let's start with the Standard Edition. Now this one according to Microsoft is tailored toward departmental database, Limited Business Intelligence applications, medium class solutions and in smaller organizations. So if you're a small to a mid-size business or if you are a kind of a autonomous department inside of a company, the Standard Edition is probably going to be where you are going to land. Now this edition will support up to 16 processor cores, in English that means up to 4 processors for the way Microsoft counts these cores. And we'll talk more about that when we talk about Licensing in a separate video. This edition will also support up to 64 gigabytes of RAM, it supports 2 Fail-Over Clustering Nodes and again small to medium size. Now the Business Intelligence Edition this is the new edition that's being offered in 2012. We've never seen one dedicated to Business Intelligence before. You get all the Standard Edition features plus things like Self Service Business Intelligence which gives you alerting power, view power, pivot for SharePoint and I can hear some of you saying wait a minute what are these things, what do they do? Well I just refer you out to Microsoft's website to see what some of this stuff means in English. Just suffice for it now to say that it makes Business Intelligence much easier. There's a lot of things built in, that's just automatically happening for you. So advanced corporate Business Intelligence or BI includes things like Tabular BI Semantic Model, Advanced analytics and reporting, advanced data mining and then Enterprise Data Management. Really good sounding marketing things. Right. But if you are in Business Intelligence, you know what these mean and this is something you are going to want to go take a look at no doubt. Then the Enterprise Edition, notice you don't see the Data Center Edition anymore like we have seen for the past few years. The Enterprise Edition now encompasses the Data Center Edition as well. And this is the full featured decked out, tricked out edition of SQL Server 2012. Just coincidentally it is also most the expensive edition and it allows you to use the maximum number of processor cores only as they are restricted by your operating system. So as many processors as your operating system will support this version of SQL Server will take care of those. It offers Advanced High Availability, things like Transparent Data Encryption, Advanced Data Integration, Data Warehousing, just all kinds of things come in through Enterprise. Now those three special editions, the Developer Edition is really the Enterprise Edition. It's a fully functional Enterprise Edition but it's licensed for development only, you cannot use this to maintain production databases. These are for the pointy head, mad scientist developer types to actually create and develop on SQL Server. The Web Edition is very similar to the Free Express Edition, it's less expensive than Standard Edition, has less features than Standard. But it's designed for hosting websites, web applications, Internet facing things. That sort of thing. Then the Express Edition is the free edition, it is the entry level introduction into SQL Server 2012 and this one is also used for small database situations. You can access a single processor, 1 gigabyte of RAM and you have a maximum database size of 10 gigabytes. Now all the other ones are unlimited but with the Express Edition, 10 gigabytes. But if you are looking to learn SQL Server 2012, grab that Express Edition, download it free off Microsoft's website. And you can kind of go crazy with it and learn all kinds of things. But that's the wrap on your SQL Server 2012 Editions, pretty straightforward, pretty simple so far, don't see any changes coming. So just kind of watch for this with the new version.
| Course: | Microsoft SQL Server 2012 Admin (70-462) |
| Author: | Mark Long |
| SKU: | 34342 |
| ISBN: | 978-1-61866-048-0 |
| Release Date: | 2012-06-18 |
| Duration: | 9 hrs / 99 lessons |
| Work Files: |
Yes |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |