What's New in SQL Server 2012

#777
Год: 2012 October
Автор: Rachel Clements, Jon Reade
Издательство: Packt Publishing
ISBN: 9781849687348
Язык: Английский
Формат: PDF/EPUB
Качество: Изначально компьютерное (eBook)
Интерактивное оглавление: Да
Количество страниц: 238
Описание: 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