Microsoft SQL Server 2012 Admin (70-462) Tutorials
Improvements in 2012 / SQL Server 2012 Enhancements
Subtitles of the Movie (Microsoft SQL Server 2012 Admin (70-462) / Improvements in 2012 / SQL Server 2012 Enhancements)
I guess the first thing everybody wants to know when a new product comes out is well, what's new in this product? Is there a compelling reason for me to buy this, to spend money on it? Do I want to just kind of skip this one, maybe get the next one? So let's talk about SQL Server 2012 Enhancements in this video and the next 3 or 4 to follow. First of all SQL Server 2012 really continued to build on the ground they gained out there in the marketplace with SQL Server 2008 Release 2. There were a lot of things about that, that administrators really liked, a lot of things started to really grow and mature and this product just continues to get stronger, faster and more stable, all that stuff. Now if you went back to say SQL Server 2000 it really wasn't considered by database administrators to be a true enterprise database. It is certainly turning into that now. Cloud Computing is a major focus for SQL Server 2012 because Cloud Computing has become a major part of how we're using computers now, both public and private Cloud Computing. Whether you have your own private servers out there on the network kind of in the Cloud or whether you are using public Cloud Services, SQL Server 2012 is architected and has features in there to help you take advantage of those things. We'll talk about Azure and some of those other things a little bit later on in the course. Now here's the big one, total cost of administration continued to be a driving factor for Microsoft and the architecture and construction and functionalities of SQL Server 2012. Total cost of administration is a marketing term yes but it's a very real term in the real world. In another words if I buy SQL Server 2012, what is it then going to cost me on an ongoing basis to keep this thing up and running and you know it's not vibrating, smoking or you know on fire. And that's a very real concern because while I might, can buy you know, a really cheap car I may spend as much repairing that thing every month or more than it would if I had just gone and bought a new car. Then I would have had the new car smell, everything would have worked, radio would have been great, probably would have an iPod plug in it and you know all that sort of thing. Same thing with databases. Now this is something that is going to be a little hard for you to believe, so I'm putting the Alinean White Paper in your Work Files folder so you can read through this yourself. Now this is a study that was paid for Microsoft, so you know it's kind of bent in their favor a little bit. But Microsoft if you were to deal with a Microsoft salesperson at the Enterprise level, you would hear that person say the words, total cost of administration, a couple of, three four hundred times in every meeting. Why? Because it's a very real number. But I want you to see this, Microsoft SQL Server according to this study costs roughly 1,605 Dollars per year per database in administrative costs. Oracle, Microsoft's big competitor, costs 7,385 Dollars per year per database in administrative costs. So which one is really more expensive. Okay. And the, the simple answer here is Oracle is a lot more expensive all the way around. Oracle does something different, Oracle is a true, really large enterprise database software. Microsoft's SQL Server is competing in a lot of ways to Oracle though. Okay. So I don't want to get into that battle here. But these are the kind of things that you can find out there. Now what's making these numbers so drastically different is they found in the study that Microsoft needed, I don't know 16 databases could be managed by one admin something like that and with Oracle it was like 5 databases per administrator. So anyway you can read the study yourself but these kind of things are what Microsoft was really chasing and had in mind when they basically redesigned and starting adding functionalities to SQL Server 2012. Now the areas of enhancement that SQL Server is going to capture the attention of database administrators and the things that you are likely to see on the exam are in the areas of Availability, Manageability, Programmability, Scalability, Performance and Security. Okay. So these are the six areas that got attention from a database administrator point of view and so if I were you, real good advice here, trust me. On each one of these I would especially focus on these aspects. Read about them, get you a copy of SQL Server 2012, tell you how later in the course, set it up, play with these pieces of functionality. These are the new things, these are the enhanced things, this is the new baby, this is what everybody is proud of, they get their pictures made with it. So play close attention to these things. I'm going to talk about them just a little bit in the next few videos and then you'll see them also, we'll touch on these again as we move through the course. So that's the main area of enhancements that would pertain to this particular exam for database administrators and this is where you really want to focus in, in your test preparation.
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
