Thomas.I Microsoft BI & Analytics

A Site Dedicated to General BI Issues and MS BI Issues: Architecture and Technology

SQL Server 2012 Books

Posted by thomasivarssonmalmo on December 23, 2011

With a big release like SQL Server 2012 it can be expected to see some new book titles on the shelf next year.

Here is the list that I have found so far:

The SQL Server RDBMS

Microsoft SQL Server 2012 High Performance T-SQL Using Windows Functions(MS Press 30 April 2012):  SQL Server 2012 TSQL have some important additions to this programming language like being able to navigate to previous and next records and running sums, that we in the MDX community know quite well. Itzik Ben-Gan is the writer and that tells me that it is a good book.

SQL Server 2012 Query Performance Tuning(APress 30 April 2012): This is always an interesting subject and usually is a chapter in TSQL books. No details have been revealed yet about the content.

Analysis Services

Professional Microsoft SQL Server 2012 Analysis Services with MDX(WROX 30 April 2012). The title hides the fact that this book will cover both BISM Multidimensional with MDX and BISM Tabular with DAX. 

Applied Microsoft SQL Server 2012 Analysis Services:Tabular Modelling(PROLOGICA, March 2012). Teo Lachev is the author of this book that will describe the self service concept in BISM, how to build applications in Excel and how to publish in SharePoint 2010. There will also be chapters dedicated to BI professionals.

Marco Russo, Alberto Ferrari and Chris Webb are working on a book about BISM tabular. I will write more when I have the details. The Title is “Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model”

Reporting Services

Professional Microsoft SQL Server 2012 Reporting Services(WROX 30 April 2012).  I think that Reporting Services is the MSBI product with most new features added in each release so it is usually mandatory to buy a new book. This book release will also cover Power View.

Visualizing Data with Power View(McGraw-Hill Osborne 1 June 2012) This is a book about the new MS SharePoint report buliding tool for BISM Tabular models.  

Integration Services

Professional Microsoft SQL Server 2012 Integration  Services(WROX 11 April 2012). Integration Services in SQL Server 2012 is a major release so this book is also important. I am not sure if it will cover Data Quality Services and Master Data Management as well.

General MS SQL Server 2012 BI Books

Programming SQL Server 2012 (MS Press, 31 May 2012). I would have second thoughts about the title of this book. It is not about programming in TSQL which is a book with almost the same title in the SQL Server 2008 version. I can see some MSBI content like integration of data mining into applications, building and maintaining data warehouses and use Excel to build front ends for OLAP cubes. I will probably move this book to a general MS BI 2012 section in an update.

Introducing Microsoft SQL Server 2012(O’REILLY/MS Press, March 2012). Half of the chapters in this book will cover MS BI Topics like SSIS, DQS, PowerPivot, SSAS and MDX as well as SSRS.


These are the titles that I have found on Amazon this far. I will update this list as soon as I find more interesting titles.

Happy Christmas Everybody!


3 Responses to “SQL Server 2012 Books”

  1. Vincent Wylenzek said

    Thanks for sharing!

  2. jadionne said

    Have you found any books to help with the new certifications yet?

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: