Microsoft SQL Server 2012 Admin (70-462) Tutorials
Improvements in 2012 / Manageability Enhancements
Subtitles of the Movie (Microsoft SQL Server 2012 Admin (70-462) / Improvements in 2012 / Manageability Enhancements)
In the area of Manageability which is one where Microsoft's always been extremely strong with their products, SQL Server 2012 continues the improvement trend. They continue to streamline the Management Tools, clean up the interfaces, add more functionality so you have to go fewer places. And inside the SQL Server Management Studio, they have enhanced Intellisense and Transact-SQL Debugging. Now in Intellisense for example, Completion List now suggest String Matches based on partial words and not just the first character. In the past once you get passed the first character, that was pretty much it. Now you can keep going with partial words. There is a new Insert Snippet Menu. If you are familiar with Snippet, if you've done any development in other aspects of Microsoft environments, like C#, VB.NET out in Visual Studio, you've seen these Insert Snippets. These things are really slick and you're going to like what you see. This thing will actually write code for you, you just have to know how to kick it off and I'll show you that a little bit later on. Some Resource Governor Enhancements have been implemented, it now supports up to 64 Pools instead of 20. If you used these in prior versions, you see the big deal here, if not don't worry about it, we'll talk about it later. Contain Databases, now this is going to be a big one and this is one you're going to hear about quite a bit. This is one you really need to be comfortable with going into the exam because I guarantee you, it's going to be mentioned a lot of different ways. Notice what's happened here, users are now or can be authenticated directly into a user database. Now when I say Contained Databases and users now log directly into a database, does not mean it has to be that way. You can continue to operate your SQL Server in the old format which meant you had a SQL Server Logon and that's how you connected to the SQL Server. Then you had a User Database, you know a list of database users that said who could then, once they got on the server, could go into certain databases. That was really cool but it created some problems. And so now we don't have any dependencies on the Database Engine or the Server Logins. We can turn on the Contain Database functionality and now the user information is basically kept out there in the User Database. We will talk about this more later on in the course. But notice what this does. If my User Database out there keeps up with all my users, then this gives me the ability to very easily move this database to another server. And out there in the real world a lot of times, certain databases take off, get popular, get busy, start to become a resource hog and it would be really great to move those over to another server. Well you've got to make sure on the server that you are moving to, that you have the same SQL Server Logins that you had. You know over on the former home of the database otherwise some people are not going to be able to log in, it just causes all kind of problems. Not a problem anymore with Contain Databases. You also have tight integration with SQL Azure, depending on what part of the world, what part of the United States you, you are from, this could either be SQL Azure, SQL Azure, SQL all kinds of things. Okay. But the bottom line with this is, this is a technology that Microsoft introduced a few years ago that basically turns SQL Server data in the databases into kind of a Cloud based solution. And so there is tight integration in SQL Server 2012, you can deploy a database to the SQL Azure using a Wizard. And we'll talk more about that a little bit later on. But this is new abilities to give you bi-directional data synchronization between databases across the Data Center and the Cloud. Probably the best real world application I've seen of this are functionalities like iTunes and the iPods and iPads and so forth. There's all kinds of bi-directional data synchronization going on between those based on the database. That's the kind of functionalities we are talking about for SQL Azure. Now Startup Options, they've, they haven't added this, it's always been here, but they've relocated it and they've changed how you get to it. And a database administrator or a DBA can now very easily specify Startup Parameters for a SQL instance or a SQL Server, bottom line. And this is huge, you now just have to right-click a Server Instance Name in the Configuration Manager and select Properties and you can change the Startup Options. This was a lot more involved in earlier versions, this as it's turned out was one of the number one requested updates, improvements, enhancements in SQL Server 2012. A lot, a lot of administrators had problems with this, they are going to be very happy with what they see here with this. So that's just kind of a quick review of some of the Manageability Enhancements that we have here. There's a lot out there but really focus on these and again get your hands on these things, get comfortable with them because they are going to show up on 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
