SQL Server 2014 - VideoWebCast, Infos, Schulungen
Interessante Vorträge, WhitePapers, Infos und Schulungen zum SQL Server 2014:
VideoWebCast von der TechED Europe 2013 auf Chanel 9:
Microsoft SQL Server 2014: Future and Features
Learn about the features in the next version of SQL Server, including HA/DR scenarios, updatable columnstore, AlwaysOn capabilities, and much more.
Microsoft SQL Server 2014 In-Memory OLTP: Overview
SQL Server 2014 introduces in-memory technology for optimizing OLTP workloads. In this overview session, we discuss the user scenarios and the hardware trends such as decreasing memory cost, many-core processors, and stalling CPU clock rate that prompted the key architectural pillars of memory optimization, no lock/latch concurrency control, and native compilation. We also cover how in-memory OLTP is integrated with the rest of SQL Server.
Microsoft SQL Server 2014 In-Memory OLTP: DB Developer Deep Dive
SQL Server 2014 introduces in-memory technology for optimizing OLTP workloads. In this DB developer focused session, we discuss the new memory-optimized tables and indexes. You will learn how to access memory-optimized tables using interpreted Transact-SQL, and how to optimize data access using the new natively compiled stored procedures. Finally, you will learn how to work with the new lock-free transaction semantics for in-memory OLTP.
Whitepapers zum SQL Server 2014 zum Download
SQL Server Mission Critical Performance White Paper
Summary: As the volume and complexity of data continue to increase, organizations require a new approach to their mission-critical capabilities. In this white paper, we examine how capabilities built into Microsoft SQL Server—including enterprise-grade security, availability, and performance, along with support for a full range of complex data types—define a “new mission critical” that answers what kinds of capabilities organizations need and expect to compete in a dynamic global landscape. We also compare the cost impact of solutions that offer mission-critical functionality that is built into the core database with solutions that offer separate features organizations can add at additional cost.
SQL Server Faster Insights White Paper
Summary: Even the modern business intelligence (BI) platform must adapt to a whole new scope, scale, and diversity of information and data—and it must continue to embrace the new ways that we discover and collaborate on information every day. Microsoft SQL Server empowers BI users through easy-to-use self-service capabilities for Microsoft Office and Microsoft SharePoint, while balancing the need to maintain credible, consistent data throughout the organization with robust data management capabilities. With Office and SharePoint 2013 and future releases, Microsoft Excel becomes a complete and powerful self-service BI tool. With the emergence of Big Data, it is all the more important to ensure that BI users are able to gain business insight from all available data, whether structured or unstructured. In this paper, we also discuss Microsoft capabilities for Big Data as an integral part of a BI platform for the modern enterprise.
SQL Server In-Memory OLTP Internals Overview for CTP1(WhitePaper)
Summaary: In-Memory OLTP (formally known as code name “Hekaton”) is a new database engine component, fully integrated into SQL Server. It is optimized for OLTP workloads accessing memory resident data. In-Memory OLTP allows OLTP workloads to achieve remarkable improvements in performance and reduction in processing time. Tables can be declared as ‘memory optimized’ to take advantage of In-Memory OLTP’s capabilities. In-Memory OLTP tables are fully transactional and can be accessed using Transact-SQL. Transact-SQL stored procedures can be compiled into machine code for further performance improvements if all the tables referenced are In-Memory OLTP tables. The engine is designed for high concurrency and blocking is minimal.
MOC-Schulungen und Workshops zu SQL Server 2014, SharePoint, Big Data, Power BI, Haddop