Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
What's New in SQL Server 2012

What's New in SQL Server 2012, 9781849687348 (184968734X), Packt Publishing, 2012

Unleash the new features of SQL Server 2012


  • 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 SQL?s 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
(HTML tags aren't allowed.)

Embracing Insanity: Open Source Software Development
Embracing Insanity: Open Source Software Development
In this book, you will learn where the Open Source movement comes from and what motivates its adherents. You will be introduced to the culture that fuels the movement, as well as the personalities and organizations that promote its growth. You will also understand the strengths of the Open Source movement and how it changes the way in which...
Object-Oriented Design Using Java
Object-Oriented Design Using Java

This text is an introduction to object-oriented (OO) design for second-year or higher undergraduate computer science students. It discusses software design and implementation in terms of “elegance,” which is defined in Chapter 1. It reviews the concepts of object-oriented programming and then covers fundamental software...

New Perspectives on Microsoft Access 2010, Brief (New Perspectives Series)
New Perspectives on Microsoft Access 2010, Brief (New Perspectives Series)

The New Perspectives Series’ critical-thinking, problem-solving approach is the ideal way to prepare students to transcend point-and-click skills and take advantage of all that Microsoft Office 2010 has to offer.

In developing the New Perspectives Series, our goal was to create books that give students the software...

How to Use Excel in Analytical Chemistry and in General Scientific Data Analysis
How to Use Excel in Analytical Chemistry and in General Scientific Data Analysis
Spreadsheets provide one of the most easily learned routes to scientific computing. This book uses Excel®, the most powerful spreadsheet available, to explore and solve problems in general and chemical data analysis. It follows the usual sequence of college textbooks in analytical chemistry: statistics, chemical equilibria, pH calculations,...
Excel 2007 Miracles Made Easy: Mr. Excel Reveals 25 Amazing Things You Can Do with the New Excel
Excel 2007 Miracles Made Easy: Mr. Excel Reveals 25 Amazing Things You Can Do with the New Excel
In this addendum to Learn Excel from Mr. Excel, the amazing new features offered in Excel 2007 are introduced. Revealing the features that make this new version the best new release of Excel since 1997, this guide provides the necessary information to teach users to quickly unleash the powerful new features in Excel 2007, create...
The Worst Is Yet to Come: A Post-Capitalist Survival Guide
The Worst Is Yet to Come: A Post-Capitalist Survival Guide
Capitalism is about to commit suicide and is threatening to take us down with it. But will it give way to a grand social utopia or the beginning of a new dark age... albeit WiFi enabled?

The Worst is Yet to Come explores the disturbing possibility that the current crisis of neoliberal capitalism isn’t
©2019 LearnIT (support@pdfchm.net) - Privacy Policy