• Title Introducing Microsoft SQL Server 2014: Technical Overview
• Author(s) Ross Mistry, Stacia Misner
• Publisher: Microsoft Press; 1 edition (April 25, 2014)
• Paperback 144 pages
• eBook PDF (125 pages, 8.08 MB), ePub,
• Language: English
• ISBN-10: 0735684758
• ISBN-13: 978-0735684751
• Share This:  

Book Description

In this book, the authors explain how SQL Server 2014 incorporates in-memory technology to boost performance in online transactional processing (OLTP) and data-warehouse solutions. They also describe how it eases the transition from on-premises solutions to the cloud with added support for hybrid environments.

• Ross Mistry is National Director, Microsoft Technology Centers (MTC). His team focuses on SQL Server high availability, virtualization, and private cloud. He has published numerous books and articles, and speaks at conferences worldwide.
• Stacia Misner is the founder of Data Inspirations (www.datainspirations.com), which delivers global business intelligence (BI) consulting and education services.

• Amazon

• Miscrosoft SQL Server
• Database, Data Warehouse and Data Management
• Data Management White Papers
• Microsoft Windows and .NET

• Introducing Microsoft SQL Server 2014: Technical Overview (Ross Mistry, et al.)
• The Mirror Site (1) - PDF

• Transact-SQL: The Building Blocks to SQL Server Programming

  This book will cover different aspects of the Transact SQL (TSQL) language. It takes the readers step by step through the TSQL language, one concept at a time. Each topic covers a particular aspect of TSQL with discussion and examples.

• SQL Server Execution Plans, 3rd Edition (Grant Fritchey)

  This book is the only in-depth look at how to improve your SQL query performance through careful design of execution plans, leads you right from the basics of capturing plans to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy.

• SQL Server Concurrency: Locking, Blocking and Row Versioning

  This book is for anyone using SQL Server as a programmer, an administrator, or even a user, who wants to understand how SQL Server manages multiple sessions, and what causes excessive blocking.

• SQL Server Backup and Restore (Shawn McGehee)

  This book shows you how to set-up a reliable, tested, SQL Server backup and restore plan. Get tips for recovering your data with minimum downtime. Learn how to minimize data loss when disaster strikes.

• SQL Server Team-based Development

  How to use of mixture of home-grown scripts, native SQL Server tools, and tools from the Red Gate SQL Toolbelt, to successfully develop database applications in a team environment, and make database development as "normal" development.

• Performance Tuning with SQL Server Dynamic Management Views

  This book investigates all of the DMVs that are most frequently useful to the DBA in investigating query execution, index usage, session and transaction activity, disk IO, and how SQL Server is using or abusing the operating system.

• Learn T-SQL Querying (Pedro Lopes, et al)

  The book will get you started with query processing fundamentals to help you write powerful, performant Transact-SQL (T-SQL) queries. You will then focus on query execution plans and learn how to leverage them for troubleshooting.

• 45 Database Performance Tips for Developers (Phil Factor, et al)

  Speed up your development with ORMs and discover the gotchas' involved. Learn the best practices for efficiently indexing tables. Get expert advice on writing well-formed SQL queries. Topics covered: ORM Tips, T-SQL Tips, Index Tips, Database Design Tips.

• SQL Server Integration Services (SSIS) Succinctly (Rui Machado)

  With this book, you will learn how to build and deploy your own ETL solution in a drag-and-drop development environment by using SSIS packages, control flows, data flows, tasks, and more.