BI Tool – SQL Server 2012 Released to Manufacturing

Today… I have one more reason to write here… Microsoft announced that SQL Server 2012 has released to manufacturing. Now it’s your turn to download and evaluate this new amazing version. Relating to SSIS 2012 I’ll write more often about it just because I passed the last 6 months investigating it through the SSIS book that I’m finishing with my friend Reza rad. For now, I want to highlight the following new updates:

Microsoft SQL Server Data Tools
Business Intelligence Development Studio known as BIDS there will not exist anymore. Now, the name is Microsoft SQL Server Data Tools. Take a look here.
Download SQL Server Data Tools

Microsoft SQL Server 2012 Data Mining Add-ins for Office 2010
I thought Data Mining strategy had died, but has not yet! Fortunately Microsoft update the old Add-In to the new SQL 2012 and Excel 2010 versions. This package includes two add-ins for Microsoft Office Excel 2010 (Table Analysis Tools and Data Mining Client) and one add-in for Microsoft Office Visio 2010 (Data Mining Templates)
Download Data Mining Add-In

Today, don’t forget to attend the SQL Server 2012 Virtual Launch Event, featuring keynotes by Ted Kummert and Quentin Clark and a number of video presentations about SQL Server 2012 by other SQL Server expert.

BI Book – SSIS 2012 Integration Services Book

I've never been so long without writing on the blog. The last months have been very complicated in terms of time, but I promise that I will not be so long time without writing! The main reason for such a long absence was undoubtedly the book I'm writing since September 2011! Yes…I’m writing a book and you know it now in first hand! This book is focused on the next version of SQL Integration Services (SSIS 2012 version) and is being written with my friend Reza Rad. This book is being reviewed by SSIS world reference professionals Phil Brammer and Rafael Salas that I need to thank for all the feedback they are giving to us!

The book is almost complete and has been an incredible challenge for me! It has been an authentic miracle working in a full-time job, teaching at the weekend and still has time to investigate and write a book! I want to thank all the effort that has been made also by Reza Rad (co-author), all reviewers, and especially PacktPub publisher staff. Thanks to Joana, my girlfriend, that always supported and motivated me to take this up until the end and never give up.
Microsoft SQL Server 2012 Integration Services: An Expert Cookbook
Reza Rad, Pedro Perfeito

"SQL Server Integration Services (SSIS) is a leading tool in the data warehouse industry - used for performing extraction, transformation, and load operations. This book is aligned with the most common methodology associated with SSIS known as Extract Transform and Load (ETL); ETL is responsible for the extraction of data from several sources, their cleansing, customization, and loading into a central repository normally called Data Warehouse or Data Mart.

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook covers all the aspects of SSIS 2012 with lots of real-world scenarios to help readers understand usages of SSIS in every environment.

Written by two SQL Server MVPs who have in-depth knowledge of SSIS having worked with it for many years. This book starts by creating simple data transfer packages with wizards and illustrates how to create more complex data transfer packages, troubleshoot packages, make robust SSIS packages, and how to boost the performance of data consolidation with SSIS. It then covers data flow transformations and advanced transformations for data cleansing, fuzzy and term extraction in detail. The book then dives deep into making a dynamic package with the help of expressions and variables, and performance tuning and consideration"

Me and reza didn't wrote this book for money, but by the desire of writing about what we like to do. Help us continue to share knowledge with the comunity. The book is now in pre-order and will available soon in several places like Amazon, Lehmans and in the PacktPub Publisher Website

Order the Book NOW

BI Tools - SQL Denali CTP3 Released

Microsoft announced today in the Microsoft Worldwide Partner Conference the release of the Community Technical Preview (CTP 3) of Microsoft SQL Server Code Name “Denali”! I’m really very excited to install and check all the new BI features that I have at very high expectations! The world is moving fast and I hope that all you can stay connected with the future!!!

Take a look to the keynote presented by Satya Nadell (President of Server and Tools Business Group) to see all the news about Microsoft products, best partners and strategy for the next year

More details here
SQL "Denali" CTP3 Download

BI Videos - SQL Server Denali Videos‏

Today I paste some very interesting SQL Server videos links for you... not only for BI professionals, but also SQL DBA's and DEV's. I hope you enjoy them!

The videos and links could be found below:

Upgrade Your Database (Denali)
Data Programmability Tools (Denali)
SQL Server appliance (Denali & R2)
Parallel Data Warehouse (R2)
SQL Server virtualization (Denali & R2)
SQL Server security (Denali)
SQL Server AlwaysOn (Denali)
SQL Server backup compression (R2)
SQL Server Integration Services (Denali)
SQL Server Non-Relational (Denali)
SQL Server CLR (Denali)
SQL Server Data Compression (R2)
SQL Server Manageability (Denali & R2)