We will be undergoing scheduled maintenance on May 20th, 2013 at 02:00 GMT.
Microsoft SQL Server 2012 Admin (70-462) Tutorials
Improvements in 2012 / Programmability Enhancements
Subtitles of the Movie (Microsoft SQL Server 2012 Admin (70-462) / Improvements in 2012 / Programmability Enhancements)
In the area of Programmability, Microsoft has done some really interesting things in SQL Server 2012 and that is they have continued to extend support for data elements that they refer to as Beyond Relational. And kind of what we're seeing here is this need for data for so many years. Go back to like the late 1990's up until about two, three, four years ago, our data needed to be strongly relational data, you know, very rigid. And then suddenly we started getting into all kinds of Beyond Relational data. Now what do we mean by that? Well, like XML, it's not just a neat little window little snippet of data that we can put you know in a column, in a field and store it and come back and do things with it later. XML could be an entire file that describes something. Spatial Data, Documents, Digital Media, any kind of other unstructured data type. These need to be stored somewhere and Microsoft is kind of you know done all kinds of different things to try to store these things and manage them in a database environment. And so in 2012 they have introduced something called the File Table. Now this addresses the challenge of storing documents, media files, all that sort of thing. It basically offers Windows File Namespace Support and then application compatibility with the file data that is stored in SQL Server. Now what's that going to do, let me back up here before I leave that. That means that I can store say a Word document out there on my hard disk, wherever it was but I have Namespace Support inside SQL Server now. And so I can store some of the data inside SQL Server, I can add Namespace Support on where to go find it. File Table is something you really need to look at but again this is another attempt by Microsoft to find a really cool way to manage this unstructured data that we need to store in a structured environment. Statistical Semantic Search, there's Three New Transact-SQL Row Set Functions dealing with this. You can query not only words in a document but also the meaning of the document. And this is something else that's coming up in Programmability. We're no longer about data per se, but the meaning of the data as well. Full Text Search Enhancements, much, much better query performance with Full Text Search Enhancements and we also now have the ability to store File Properties in a separate database and then search those properties. This is something else that we're finding. When we put all of our data into databases, we have problems then retrieving that data. How do we find that needle in that haystack? Well now not only can we search for full text terms that have to do with our data. But we can also store properties about that file in a separate database, search those properties, have that link us back to the actual data that we are looking for. So in Programmability, there's two or three things here that are very important. We'll touch on these a little bit in the course here, we won't go, kind of really drill into them a whole lot. But we will touch on them. These are things you need to kind of be reading up on, play with them a little bit yourself. You could see these in a slight way on the exam. But I just wanted you to be aware of them, to know they are out there and then know that these enhancements are there. But this is definitely where the world is headed. We are heading into Cloud environments, data being distributed all over the place and not only just storing data anymore. We need to be able to query descriptions of the data and then the meaning of the data based on the words around it and how those words correlate. So a lot of really cool stuff going on here, but that's the basics for the Programmability Enhancements in SQL Server 2012.
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
