SQL Server 2012 Professional Tips and Tricks

Overview

SQL Server 2012 professional tips and tricks is a concise reference for database administrators, SQL Server Developers and BI professionals. Anyone who is familiar with SQL Server 2008 R2 and needs to make the jump to the latest version with the shortest learning curve will find this book useful.

SQL Server 2012 professional tips and tricks is a hands-on book to quickly get ...

See more details below
Paperback
$33.72
BN.com price
(Save 3%)$34.99 List Price
Other sellers (Paperback)
  • All (7) from $33.71   
  • New (6) from $33.71   
  • Used (1) from $33.71   
Sending request ...

Overview

SQL Server 2012 professional tips and tricks is a concise reference for database administrators, SQL Server Developers and BI professionals. Anyone who is familiar with SQL Server 2008 R2 and needs to make the jump to the latest version with the shortest learning curve will find this book useful.

SQL Server 2012 professional tips and tricks is a hands-on book to quickly get you up to speed with SQL Server 2012. It covers all the new features of the core database engine as well as the business intelligence (BI) services.

The book begins by taking you step by step through the installation process, showing you what to install and which services and features you need. Once you have your SQL Server in place, you learn how to administer it and then explore new T-SQL functions to expand your query-writing toolkit. You will discover how the enhancements to Integration Services, Analysis Services and Reporting Services make developing BI solutions easier. It will then introduce you to SQL Server Data Tools, your new and improved development environment for creating database and BI projects.

A hands-on example guides you through the steps required to run Distributed Replay, giving you the experience you need to apply this in the field. The book then takes you through a detailed example to show you how to create a Data Quality Services project and cleanse real-world data. Easy to follow code samples provide you with the queries you need to set up Availability Groups using the new AlwaysOn technology.

Once you are comfortable with these new features you will be ready to migrate your data to the cloud and into SQL Azure. An exploration of Hadoop will help you understand big data and how it really is the next big thing.

Read More Show Less

Product Details

  • ISBN-13: 9781849687348
  • Publisher: Packt Publishing
  • Publication date: 9/26/2012
  • Pages: 238
  • Product dimensions: 7.50 (w) x 9.25 (h) x 0.50 (d)

Meet the Author

Rachel Clements has worked as a software and database developer for over 15 years across a wide variety of private industries. She is currently a SQL Server BI Developer for an international power tools company in the UK. Her role encompasses all aspects of the BI stack along with key database administration tasks. She began her career in London writing for The Times technology supplement before becoming a full-time developer. She now specializes in SQL Server and business intelligence, writes articles for SQL Server Club (http://www.sqlserverclub.com) and tweets at @RachelClements. As an active member of the technical community, she organizes the Bristol user group SQL Server Club (http://www.sqlserverclub.co.uk) and is a member of the Developer! Developer! Developer! South West team (http://www.dddsouthwest.com).

Jon Reade has worked in the UK and Europe as a database professional in the finance and telecomms sectors for 16 years. He is currently a SQL Server consultant in the finance industry, based in the UK. He began his career as a systems programmer for IBM, methodically testing and breaking mainframe database security systems before moving on to various database development roles. He has extensive experience of SQL Server from 6.0 to 2012, in development, operational, production and managerial roles. He is interested in BI and big data and the use of data mining to extract useful business knowledge from transactional systems.

He holds MCITP and MCTS certifications for SQL Server 2008 and is a recent MSc Business Intelligence graduate from the University of Dundee in Scotland. Jon is also a part-time SQL Server instructor for a global training company. He is the co-founder of SQL Server Club website and user group, tweets (@JonReade) speaks at SQL Server events (SQLBits, DDD South West and SQL Server Club) and has written for Packt and SQL Server Central.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)