We will be undergoing scheduled maintenance on May 20th, 2013 at 02:00 GMT.
Microsoft SQL Server 2012 Admin (70-462) Tutorials
SQL Server 2012 Essentials / Licensing for 2012
Subtitles of the Movie (Microsoft SQL Server 2012 Admin (70-462) / SQL Server 2012 Essentials / Licensing for 2012)
Licensing for SQL Server 2012 has changed and this needs to be a flashing red light for you okay, watch for questions about this on the exam. Now they are not going to ask you directly, has licensing changed? Yes or no but they will show you a scenario and, and expect you to understand the differences in Licensing. Now for 2012 SQL Server there are two different Licensing Models being offered. First of all there is the Server+ Client Access License and this is really kind of the way it's been in the past. You have servers out there that have Server Licenses on them and then you just have to have a Client Access License for every person connecting to that server. This is again licensing based on the number of users, watch for that little clue on the exam. If you are trying to handle Licensing based on the number of users, you're talking about a Client Access License, very easy to remember. Then there's Core Based Licensing and this is kind of the new one and this is licensing by computer power and it's a little different than the way they used to do it. But this means that basically all cores in the server must be licensed. And then Microsoft takes it a step further and they define cores for you. Okay. They say okay for any physical processor that you have in the machine, we are going to say that there is a minimum of four cores there. And in a lot of cases that's true. Okay. But if you've got dual-core processor and you got a processor there, guess what? They are treating like four cores. Okay. So anyway all cores in the server must be licensed there's a minimum of four for each physical processor. Now here's kind of the rub and this is what you need to watch for the exam, different versions of SQL Server 2012 require different licenses. If you have the Enterprise Edition, you're going to do Core Based Licensing, that's all there is to it. If you have the Business Intelligence Edition of SQL Server 2012, you are going to do Server+ Client Access License. If you have the Standard Edition of SQL 2012, you can choose either Core Based or Server+ Client Access. So just kind of remember this, memorize this little thing, just remember Standard can have either, Enterprise is the biggest so they're going to do just Core Based Licensing. You are going to pay on the most for the cores, that's it, we don't care how many people connect but just think Enterprise huge. They don't, there's no way to count how many people are going to connect this thing, there's no way to keep track of that. So Enterprise is Core Based, Business Intelligence is Server plus Client Access, Standard whatever you want, either one. Now there is also a Cloud Optimized License, watch for that word Cloud as a cue and watch for another term here, Virtual Machine. This Cloud Optimized License is for virtual machine based databases, say that another way. For SQL Server databases that are running on a virtual machine. Now that is going to be another thing you can watch for on the exam, Microsoft refers to this as a machine with fewer hardware parts or minimal hardware configurations, is what they call it. And they are talking about virtual machines so there you go and really what they are talking about here, let me go ahead with it, is they are talking about Server Core. Because the first time in SQL Server 2012 this can now be installed on Server Core and so you can get a separate license when you are running it there. So that's kind of the rundown on SQL Server 2012 Licensing. Again just be familiar with what the two types of licensing, which version which runs on and just know about this Cloud Optimized License out there and you will do just fine. These will kind of become the gimme portions of the exam.
Tutorial Information
| 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 |
VTC Sign up & Benefits
- Unlimited Access
- 81,350 Video Tutorials (14,200 free)
- Video Available as Flash or QuickTime
- Over 715 Courses
- $30 for One Month Access
- Multi-User Discounts Available
