Facebook Icon Image Google Plus Icon Image Twitter Icon Image Logo Image

What's New in SQL Server 2012

What's New in SQL Server 2012 Image

Book details:

Publisher:Packt Publishing
Category: Packt
Posted:Jun 30 2016
Book format:PDF
Book size:8.38 MB

Book Description:

Unleash the new features of SQL Server 2012 Overview Upgrade your skills to the latest version of SQL Server Discover the new dimensional model in Analysis Services Utilize data alerts and render reports to the latest versions of Excel and Word Build packages to leverage the new features in the Integration Services environment Plan, load and simulate real-world database activity using Distributed Replay In Detail Microsoft SQL Server has been part of the enterprise database landscape since SQL Server 7 arrived in 1998 and has evolved into the relational and BI platform of choice by businesses around the globe. The performance and full feature set of SQL Server has been widely recognized by the business community and it is viewed as a powerful weapon in their database and business intelligence arsenal. SQL Server brings numerous benefits to all businesses, central to which is a thorough understanding of the technology, both current and new. This is the book both DBAs and developers always wanted to buy but could never find in the bookstore. This is a SQL Server book that contains only the new features introduced in SQL Server 2012. This book will give you a competitive advantage by helping you to quickly learn and understand the new features of SQL Server 2012. Most readers will already have an established knowledge of SQL Server and will want to update their 2008/2008R2 knowledge swiftly with least pain. This book takes you through all of the new features of SQL Server 2012, from installing core database services and features, to the new administration and updated Transact-SQL functions. You will discover the new Analysis Services features, introduce data alerts and reporting features and explore the new enhancements to Integration Services. In addition you will learn how to automate, cleanse and transform critical business data with DQS and world-class enterprise level availability features. Finally, you will venture into simulating real-world database loads using Distributed Replay and complete your journey with a look at the new SQL Server cloud services and the new Hadoop big data platform. What will you learn from this book Learn how to install SQL Server 2012 core database features and advanced services Master day to day administration tasks in the new SQL Server Management Studio Take command of Transact SQLs new keywords and functions Explore the SQL Server Data Tools (SSDT) new development environment Find out about the new FileTable data type Learn about the Business Intelligence Semantic Models (BISM) in Analysis Services Take advantage of Reporting Services Data Alerts Find out about the new SSIS catalog, the SSIS Admin security role and how to upgrade from previous versions Create a Data Quality Services (DQS) project and cleanse real-world data Understand the new AlwaysOn Availability Features Test new hardware and vendor upgrades using Distributed Replay Discover the forthcoming Hadoop data platform and how to migrate to SQL Azure

Download Link:

Related Books:

What's New in SAS 9.2 Image

What's New in SAS 9.2

Jun 30 2016 Gives you a quick, convenient overview of new functionality, enhanced features, and new products that you might use in SAS 9.2....

Lotus Notes Domino 8 Image

Lotus Notes Domino 8

Jun 30 2016 A complete guide to the most powerful new features and changes of the new release of Lotus Notes/Domino 8. Lotus Notes power users, administrators, and developers working with any version of Lotus Notes/Domino, who want to upgrade to Lotus Notes/Domino 8....

Windows 10 Primer Image

Windows 10 Primer

Jun 30 2016 With Windows 10 arriving later in 2015, many questions remain to be answered, both for businesses and home users. Will it provide the compatibility of Windows XP, and the usability of Windows 7? Will it banish forever the problems associated with Windows 8? In this book, Windows expert, author and MVP Mike Halsey answers the questions you have and details hidden and improved features that can revolutionize your security, productivity and user experience. Whether you're an IT professional considering or planning an upgrade to your company's PCs or a Windows enthusiast eager to find out if Micro...

Joe Celko's Complete Guide to NoSQL Image

Joe Celko's Complete Guide to NoSQL

Jun 30 2016 Joe Celko's Complete Guide to NoSQL provides a complete overview of non-relational technologies so that you can become more nimble to meet the needs of your organization. As data continues to explode and grow more complex, SQL is becoming less useful for querying data and extracting meaning. In this new world of bigger and faster data, you will need to leverage non-relational technologies to get the most out of the information you have. Learn where, when, and why the benefits of NoSQL outweigh those of SQL with Joe Celko's Complete Guide to NoSQL. This book covers three areas that make today's...