SQL SERVER 2014. Enhancements, Bussines Intelligence and Big Data

SQL Server 2014, the latest complete information platform from Microsoft, embodies the new era of Microsoft’s Cloud OS, which provides organizations and customers with one consistent platform for infrastructure, apps and data that span customer data centers, hosting service- provider data centers, and the Microsoft public cloud. The benefits that customers experience with a consistent platform include common development, management, data, identity, and vir- tualization, no matter where an application is being run. SQL Server 2014 also offers organizations the opportunity to efficiently protect, unlock, and scale their data across the desktop, mobile devices, data centers, and a private, public, or hybrid cloud. Furthermore, SQL Server 2014 builds on the success of SQL Server 2012 by mak- ing a strong impact on organizations worldwide with significant new capabilities that are tightly aligned to the trends transforming the IT industry, including Microsoft’s Cloud OS. SQL Server provides mission-critical performance for the most demanding database applications while de- livering the highest forms of security, scalability, high availability, and support. SQL Server 2014’s mission is to deliver faster insights into big data, small data—all data—and, most importantly, deliver business intelligence in a consumable manner through familiar tools such as Microsoft Excel. Finally, SQL Server 2014 enables new unique hybrid-cloud solutions based on the Cloud OS. These solutions can positively affect an organization’s bottom line and allow an organization to create innovative solutions for its database applications. Microsoft SQL Server 2014 is the next generation of Microsoft’s information plat- form, with new features that deliver faster performance, expand capabilities in the cloud, and provide powerful business insights. In this book, we explain how SQL Server 2014 incorporates in-memory technology to boost performance in online transac- tional processing (OLTP) and data-warehouse solutions. We also describe how it eases the transition from on-premises solutions to the cloud with added support for hybrid environments. SQL Server 2014 continues to include components that support analysis, although no major new features for business intelligence were included in this release. However, several advances of note have been made in related technologies such as Microsoft Excel 2013, Power BI for Office 365, HDInsight, and PolyBase, and we describe these advances in this book as well. This book is for anyone who has an interest in SQL Server 2014 and wants to under- stand its capabilities. Many new improvements have been made to SQL Server 2014, but in a book of this size we cannot cover every improvement in its entirety—or cover every feature that distinguishes SQL Server from other databases or SQL Server 2014 from previous versions. Consequently, we assume that you have some familiarity with SQL Server already. You might be a database administrator (DBA), an application de- veloper, a business intelligence solution architect, a power user, or a technical decision maker. Regardless of your role, we hope that you can use this book to discover the features in SQL Server 2014 that are most beneficial to you.

SQL Server 2014是微軟最新的完整資訊平台，代表了微軟的Cloud OS新時代，為組織和客戶提供了一個統一的基礎架構、應用程式和數據平台，涵蓋了客戶數據中心、托管服務提供商數據中心和微軟公有雲。統一平台帶來的好處包括共同的開發、管理、數據、身份和虛擬化，無論應用程式在哪裡運行。SQL Server 2014還為組織提供了在桌面、移動設備、數據中心和私有、公有或混合雲中高效保護、解鎖和擴展數據的機會。此外，SQL Server 2014在SQL Server 2012的成功基礎上，通過提供與改變IT行業趨勢（包括微軟的Cloud OS）緊密相關的重要新功能，對全球組織產生了強大的影響。SQL Server提供了對最苛刻的數據庫應用程式的關鍵性能，同時提供了最高形式的安全性、可擴展性、高可用性和支持。SQL Server 2014的使命是通過熟悉的工具（如Microsoft Excel）以可消費的方式提供對大數據、小數據和所有數據的更快洞察力。最後，SQL Server 2014基於Cloud OS實現了新的獨特混合雲解決方案。這些解決方案可以對組織的經濟效益產生積極影響，並允許組織為其數據庫應用程式創建創新解決方案。Microsoft SQL Server 2014是微軟信息平台的下一代，具有提供更快性能、擴展雲端能力和提供強大業務洞察力的新功能。在本書中，我們解釋了SQL Server 2014如何利用內存技術提升在線交易處理（OLTP）和數據倉庫解決方案的性能。我們還描述了它如何通過增加對混合環境的支持，簡化了從本地解決方案過渡到雲端的過程。SQL Server 2014繼續包括支持分析的組件，雖然在此版本中沒有包含主要的商業智能新功能。然而，在相關技術（如Microsoft Excel 2013、Power BI for Office 365、HDInsight和PolyBase）方面取得了一些值得注意的進展，我們在本書中也描述了這些進展。本書適用於對SQL Server 2014感興趣並希望了解其功能的任何人。SQL Server 2014進行了許多新的改進，但在這本書的範圍內，我們無法完整涵蓋每一個改進，也無法涵蓋SQL Server與其他數據庫或SQL Server 2014與之前版本的每一個特性。因此，我們假設您對SQL Server已有一定的熟悉程度。您可能是數據庫管理員（DBA）、應用程式開發人員、商業智能解決方案架構師、高級用戶或技術決策者。無論您的角色如何，我們希望您能使用本書發現對您最有益的SQL Server 2014功能。