What's New in SQL Server 2012

Advertisement

Today's Books

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

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 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

Comments

Amazing Books

LINQ in Action

Manning Publications, 2008

LINQ, Language INtegrated Query, is a new extension to the Visual Basic and C# programming languages designed to simplify data queries and database interaction. It addreses O/R mapping issues by making query operations like SQL statements part of the programming language. It also offers built-in support for querying in-memory collections like...

Search Engine Optimization All-in-One For Dummies (For Dummies (Business & Personal Finance))

For Dummies, 2012

Since the late 1990s, Internet marketing has taken off as a dynamic marketing channel because of its accuracy and how easily you can track traffic. The Internet has come a long way in a short time: As it grew, finding the sites you were looking for with a directory became impossible. Search engines appeared as the way forward, offering a way...

Engineering Acoustics: An Introduction to Noise Control

Springer, 2009

'Engineering acoustics' is a teaching textbook that can serve as a tool for self-study and as a compendium for lectures as well. One of the author's goals is not only to describe how the topic develops but also why a specific way is chosen. The explanations do not restrict themselves to mathematical formulas. Only the illustrative explanation...

$Algebra Essentials Practice Workbook with Answers: Linear & Quadratic Equations, Cross Multiplying, and Systems of Equations: Improve Your Math Fluency Series$

Algebra Essentials Practice Workbook with Answers: Linear & Quadratic Equations, Cross Multiplying, and Systems of Equations: Improve Your Math Fluency Series

CreateSpace Independent Publishing Platform, 2010

UPDATED EDITION: The new edition includes these updates:

The updated edition numbers the questions and answers. This helps to easily find the correct answers in the back of the book.

100% of the answers to the updated edition have been independently verified both by computer and...

$High Resolution X-Ray Diffractometry And Topography$

High Resolution X-Ray Diffractometry And Topography

CRC Press, 1998

The purpose of this book is to provide the theoretical and practical background necessary to the study of single-crystal materials by means of high resolution Xray diffractometry and topography. Whilst some of these techniques have been available for over fifty years, and the basic theory for even longer, it is in the last decade that they have...

Orthodoxy and the Courts in Late Antiquity

Oxford University Press, 2007

a truly important contribution to the study of the legal history of the later Roman Empire Gregory Halfond, Bryn Mawr Classical Review Humfresss engaging book makes an original, incisive contribution to our understanding of the continuity of legal practice in the later empire and to the role of forensic advocacy by Christians in the genesis and...