It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

Beyond Relational in SQL Server 2012 and SQL Futures

What do you do about your unstructured data? A huge amount of data produced today is unstructured. This day session deals with how we can manage this data effectively and flexibly. Find out how to use this data efficiently. The breakdown of the day is as follows:

A lot of applications are making use of data that goes beyond the relational table paradigms. In fact, it is estimated that over 80% of the data is now so called unstructured data. SQL Server provides support to manage unstructured and semistructured data and provides rich services over such data. In this introduction, we give an overview on these capabilities and set up the reminder of the Beyond Relational journey.

80% or more of the data produced and stored are so called unstructured documents and are often not stored in the database, but often need to be managed in conjunction with relational data. In order to facilitate the storage and management of unstructured data, SQL Server has evolved from storing blobs to providing a sophisticated integration with the Windows Filesystem and provides rich services over such data to provide an interesting and compelling application development experience. This presentation introduces the new unstructured data processing capabilities of SQL Server 2012 that provide full Windows application-compatible file management over files stored in SQL Server as well as the services to unlock the information in such data such as the extensions and improvements to Full-Text Search and the introduction of semantic similarity search.

Many applications today need to be locally aware to provide customer value. SQL Server 2012 has continued its spatial investment to address the next major customer requirements around spatial data support. Thus, this presentation will provide an overview of SQL Server’s spatial support and introduce the new spatial types, capabilities and performance enhancements such as curves and spatial aggregates.

Spatial data operations are often expensive. Thus, in order to achieve the required performance and scalability in spatial database applications, we need to define spatial indices. This presentation describes how SQL Server 2008 and 2012 spatial indexes work and gives tips and presents the tools on how to analyze and improve your spatial application's performance even when it needs to scale to large amounts of spatial data. The session assumes a core understanding of the spatial functionality in SQL Server 2008 or later.

About

SQL Bits was started by a group of individuals that are passionate about the SQL Server product suite.
There is a breadth of knowledge in the SQL Community that will benefit everyone in the community.
We want to spread that knowledge.

We all work with the SQL community, some of us for many years and have all been given the MVP award by Microsoft