Every IT Professional and Business Decision maker looks for ways to understand their organization's data in ways that enable them to provide insights to their business. This course is designed to show you how Microsoft SQL Server 2012 can do just that. The 7 modules of this course will teach you:
- What's new in Microsoft StreamInsight - Symmetric Multiprocessing to Parallel Data Warehouse - Using columnstore technology to revolutionize your query performance - SQL Server Integration Services - SQL Server Fast Track for data warehouse for dramatic speed improvements - Going beyond relational data management into the realm of unstructured and spatial data management
You will learn how Microsoft is teaming up with our hardware partners to provide best practices for SQL Server deployment and how SQL Server 2012 will allow you to create a scalable data warehouse that will give you breakthrough insights to even your unstructured data.
Exploring Certification? Free SQL Server Certification Prep Tools
Microsoft SQL Server 2008 R2 introduces StreamInsight, a comprehensive platform for building event-driven applications. While typical relational database applications are query-driven, event-driven applications are characterized by continuously arriving new data, continuous processing of the incoming data, and oftentimes also latency requirements that make it impractical to store the data in a relational database before processing it. Event driven applications occur in many different industries, including manufacturing, oil and gas, utilities, financial services, health care, retail, web analytics, and data center monitoring. This session provides an overview of Microsoft StreamInsight, the main customer scenarios, the product architecture, and its integration into the Microsoft stack. As part of the session, we walk you through demos for different usage scenarios and illustrate how you can build event-driven applications with Microsoft Visual Studio 2010,Microsoft .NET Framework 4.0 and StreamInsight. We also provide a brief outlook on new and upcoming features for the next version of StreamInsight.
Microsoft Data Warehousing brings you a solid offering that provides the right data warehousing solution for customer needs and workloads. In this session, learn about Reference Architectures using Fast Track Data Warehouse and appliance-based implementations including Microsoft SQL Server Parallel Data Warehouse. Learn about the key differences in SMP and MPP (Massive Parallel Processing), and have clear understanding which offering is the most optimized and streamlined for your Data Warehouse projects. You will also learn about future roadmap and data scale-up and scale out best practices.
This talk describes a new data warehouse SQL query acceleration feature in Microsoft SQL Server 2012 based on a new type of index called the columnstore. This new index, combined with enhanced query processing features, improves data warehouse query performance by hundreds to thousands of times in some cases, and can routinely give a tenfold speedup for a broad range of decision support queries. We describe the fundamentals of column store technology, and how to create applications using it in Microsoft SQL Server 2012. We also describe how you can migrate your existing decision support applications to this amazing new capability.
SQL Server Fast Track for Data Warehouse has delivered proven and often dramatic results for SQL Server customers. With over 15 customer case studies and support from industry leading partners HP, Dell, IBM, and Cisco Fast Track provides proven Reference Configurations from 2 to 80TB for SQL Server Enterprise Edition deployments. Fast Track DW for Microsoft SQL Server 2012 will provide the same proven performance established for SQL Server 2008 and 2008 R2. As in prior releases validated Reference Configurations by Fast Track hardware partners will be accompanied by Microsoft best practices for SQL Server deployment and optimization. This guidance is tailored for the challenges of DW workloads and the specific characteristics of our partners latest servers and storage. This presentation will help you understand how you can take advantage of the Fast Track program to get the most out of the new features in Microsoft SQL Server 2012 for your challenging data warehousing requirements.
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, Microsoft 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 provides an overview of the unstructured data processing capabilities of SQL Server 2008 and Microsoft SQL Server 2012, ranging from storing BLOBs over remote BLOB stores to the new additions in Microsoft 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 FullText Search and the introduction of Semantic document processing in Microsoft SQL Server 2012.
SQL Server is providing extensive support for two-dimensional spatial data processing. This presentation is providing a short introduction to the world of spatial data processing. It will talk about use cases and how the SQL Server Spatial technology helps solve the common spatial questions such as where are the nearest restaurants, and it will discuss the difference between planar and geodetic Spatial data and requirements. Finally it will present the new spatial capabilities introduced in Microsoft SQL Server 2012 and talk about how to utilize Spatial indices to provide performing spatial queries.