BI Book - SQL Server MVP Deep Dives - Volume 2

Dear friends,

I’m not writing for too much time... almost 2 months! Although we are on summer (usually time for vacations) I was working almost day and night! Yes… it’s true! Too many challenges and few much time to vacations or to write here some posts) One of the challenge was being a co-author of the MVP Deep Dives book (2nd Volume). The book is almost available for sell! See here more details from the chapter I wrote: “Excel as BI FrontEnd tool”.

Book Description

Individually, each SQL Server MVP possesses an impressive wealth of knowledge and skill. Collectively, the 63 MVPs who contributed to SQL Server MVP Deep Dives, Volume II represent over 1000 years of daily experience in SQL Server administration, development, training, and design. This incredible book captures this expertise and passion in a collection of sixty concise chapters, each handpicked by lead editor Kalen Delaney and section editors Louis Davidson, Greg Low, Brad McGehee, Paul Nielsen, Paul Randal, and Kimberly Tripp, and written by an active SQL Server MVP.

This second volume picks up where the first SQL Server MVP Deep Dives leaves off, offering completely new content on topics ranging from testing and policy management to integration services, reporting, and performance optimization techniques. The chapters fall into five parts, Architecture and Design, Administration, Database Development, Performance Tuning and Optimization, and Business Intelligence

About the Authors

This book includes contributions from 63 SQL Server MVPs. All chapters were selected and edited by Kalen Delaney and section editors Louis Davidson (Architecture and Design), Paul Randaland Kimberly Tripp (Database Administration), Brad McGehee (Performance Tuning), Paul Nielsen (Database Development), and Greg Low (Business Intelligence)

Your purchase supports Operation Smile

An international children's medical charity dedicated to healing cleft lip, cleft palate, and other facial deformities through safe and effective surgical care. Every donation can help change a life! Learn more at www.operationsmile.org

BI Tools - Cumulative Update #8 for SQL 2008 R2

Dear Friends,
Just to inform you that a new cumulative update was released today! If you use SQL 2008 R2 version don´t forget to update it with these new fixes.

Take a look a the full details here:
CU#8 KB Article: http://support.microsoft.com/kb/2534352

Previous Cumulative Update KB Articles:
CU#7 KB Article: http://support.microsoft.com/kb/2507770
CU#6 KB Article: http://support.microsoft.com/kb/2489376
CU#5 KB Article: http://support.microsoft.com/kb/2438347
CU#4 KB Article: http://support.microsoft.com/kb/2345451
CU#3 KB Article: http://support.microsoft.com/kb/2261464
CU#2 KB Article: http://support.microsoft.com/kb/2072493
CU#1 KB Article: http://support.microsoft.com/kb/981355

Follow all Microsoft SQL Server Release Services here:
http://blogs.msdn.com/b/sqlreleaseservices

BI Book – Free Data Quality and MDM SQL e-book

Well… here am I again with another free e-book… and this time a Data Quality (DQ) and master data management (MDM) book using SQL 2008 R2! The book was written by my MVP colleagues Dejan Sarka and Davide Mauri. It’s for sure an amazing book that you should not miss! I’ll start reading soon!

"This book deals with master data. It explains how we can recognize our master data. It stresses the importance of a good data model for data integrity. It shows how we can find areas of bad or suspicious data. It shows how we can proactively enforce better data quality and make an authoritative master data source through a specialized Master Data Management application. It also shows how we can tackle the problems with duplicate master data and the problems with identity mapping from different databases in order to create a unique representation of the master data.

For all the tasks mentioned in this book, we use the tools that are available in the Microsoft SQL Server 2008 R2 suite. In order to achieve our goal—good quality of our data—nearly any part of the suite turns to be useful. This is not a beginner’s book. We, the authors, suppose that you, the readers, have quite good knowledge of SQL Server Database Engine, .NET, and other tools from the SQL Server suite.

Achieving good quality of your master data is not an easy task. We hope this book will help you with this task and serve you as a guide for practical work and as a reference manual whenever you have problems with master data"

Download link!

I hope you enjoy it!

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)

BI News – Donald Farmer Left Microsoft

Today I received the notice that Donald Farmer, one of the main business intelligence (BI) minds left Microsoft. Even yesterday I was writing about him on the predixion post and I had no idea what happened today… And imagine to where? To QlickTech…

I do not understand how Microsoft let their main BI reference Donald Farmer goes to the main concurrent of PowerPivot: Qlickview. Last year, Donald Farmer was defending his perspective of PowerPivot product agains Qlickview… now his in that side… what a great loss!

What can we think right now? Some question that we can do: Will Microsoft BI strategy follow Data mining Strategy? (Silenced) Why Donald Farmer left Microsoft? Exactly because there is a change on BI strategic? It’s the end of the line in Microsoft BI?

Read the entire Donald Farmer perspective through his blog in first person here.
Just some paragraphs here:

“When I joined Microsoft in 2001, the Analysis Services team was then about 50 people, and was the largest organization I had ever worked in. Along with Reporting Services, and later Integration Services, the BI org was an exceptional team including some of the smartest, most driven, and most amiable people I know. (Some were all three!)
…
So, where am I going? I am joining QlikTech, creating a role as the Product Advocate for QlikView. In my next post, early next week, I’ll write more, from QlikTech HQ. I look forward to telling you more about this role and what promises to be a thrilling new direction for me with the most exciting company I have seen in years"

Some Donald Farmer references in this blog during last years:

BI Interview – Donald Farmer BI Perspective
Yes we can!...see Donald Farmer in Portugal!
BI Webminar - Free Data Mining Webinar

I wish you the best luck in your new challenge.

Pedro

BI Tools - SQL 2008 R2 Digital Tour

My teacher Maria Jose Trigueiros is not physical present any more, but she’s always present in my mind. I’m sure that she’s watching what the persons that has the luck to has her as teacher and as a friend will be doing. She shared amazing words, enthusiasm and experiences with me that changed my life. Because I know that she wishes that I continue blogging... I’ll do it, and even with more power!

SQL Server 2008 R2 RTM is now available for download!
I already installed in a new virtual machine in order to preparing some posts about it. In Microsoft SQL Server 2008 R2, several components have new or improved features. I highlight the following new improvements:

PowerPivot for SharePoint
PowerPivot for SharePoint adds shared services and infrastructure for loading, querying, and managing PowerPivot workbooks that you publish to a SharePoint 2010 server or farm. To create PowerPivot workbooks, you use PowerPivot for Excel.

PowerPivot for Excel
PowerPivot for Excel is an add-in to Excel 2010 that can be downloaded from the web and installed on client workstations. You use PowerPivot for Excel to assemble and create relationships in large amounts of data from different sources, and then use that data as the basis for PivotTables and other data visualization objects that support data analysis in Excel

Reporting Services improvements
Reports can now include maps, sparklines, data bars, and indicators to depict data. Report parts enable collaboration through shared datasets, report items, and data regions that are centrally stored and managed. Dataset query results can be cached on first use or by schedule. SharePoint integration supports multiple SharePoint Zones, SharePoint Universal Logging, and local mode report viewing with Access Services and SharePoint lists. SharePoint lists, SQL Server 2008 R2 Parallel Data Warehouse, and SQL Azure Database can be used as data sources for reports

Take a look at additional news here
Take a tour on this new version of SQL through SQL 2008 R2 Digital Tour:

Regards,

Pedro

BI Books - Free SQL 2008 R2 eBook

Dear friends,
A very interesting free eBook was publish and shared by Microsoft Press. If you are a Database Administrator or a BI Developer, don’t forget to take a look to this book. You have no excuses… the book is FREE. Naturally the part of the book more interesting for me is undoubtedly the Business Intelligence chapters. Check the book structure:

PART I Database Administration
CHAPTER 1 SQL 2008 R2 Editions and Enhancements
CHAPTER 2 Multi-Server Administration
CHAPTER 3 Data-Tier Applications
CHAPTER 4 High Availability and Virtualization Enhancements
CHAPTER 5 Consolidation and Monitoring

PART II Business Intelligence Development
CHAPTER 6 Scalable Data Warehousing
CHAPTER 7 Master Data Services
CHAPTER 8 Complex Event Processing with Stream Insight
CHAPTER 9 Reporting Services Enhancements
CHAPTER 10 Self-Service Analyses with Power Pivot

More details about this book
Download the free SQL 2008 R2 eBook

Regards,
Pedro

BI Conference - TechDays 2010 - After my session

Finally I have some time to describe what I experienced last week during the TechDays Portugal conferences. Today I’m writing my post nrº100 and could not do it better describing this fantastic experience

The facilities
The day before my session I went to see the event facilities and aclimatize myself to the room where I would present my session. There were many people working for this event, and it is important that everyone had the notion that organizing such an event is not easy. It requires lot of human labour and a lot of dedication, mainly from persons like Luis Martins, João Bilhim and Leonor (Microsoft) and several other amazing dedicated persons

The people
I met many people and also spoke with people who normally only contact via the Web. Is indeed a very interesting event, where people share knowledge and opinions that for sure is more important than if the lunch is good or bad! Jorge Paulino, Ricardo Peres, André Lage, Rodrigo Pinto, MVP guys, Jorge Moura, Nuno Batalha, Tiago Rente, and a lot of enthusiastic professionals

The Session
Most people, certainly should not have a notion that it was my first public session with so many people... and also, that a year ago never came into my head be presenting a session at TechDays. It was a very difficult challenge trying to pass a message on Data Mining for almost 300 people, mainly because the profiles of the audience was very diverse ... feedback received varied between easy and very difficult session contents. Thanks to all the persons that attended to my session. Well… if you're curious take a look into presentation below:

TechDays 2010 DAT202

I hope you enjoy it... I can translate to english if needed.

BI Conference - TechDays 2010 - Before my session

Dear friends,
There are only a few hours before presenting my session at TechDays. It will be a great challenge for me where I hope I can transmit the message I purposed to.

I don’t know yet, how many people will be watching my session, could be from 40 to 500 attendees… and for that reason I cannot measure right now the pression level that I’ll have today… :-)

There’ll be a lot of interesting sessions almost made by portuguese professionals…It’ll be a prove, that here in Portugal we have lot of expertise professionals.

I am sure that next year there will be lot of new speakers that are just watching this year. Mainly the master and pós-graduation BI Students… are your there!?!! :-)

Well… I'll leave now and I’ll wish a good luck to myself and a very good TechDays to all you. :-) I’ll be back after the event...

Pedro

BI Tools - Microsoft beating the BI market

Today I finally received an e-mail from Microsoft announcing the release of the CTP version (Community Technology Preview) for SQL 2008 R2 ... and I'm really excited to take the first look and for sure tomorrow I’ll download it ... I'm still focused on my master thesis, any way I will try to "play" a little this release and give a little feedback to you.

I truly believe that today Microsoft made a big step to beat all the competitors. Microsoft doesn’t have several decades of proved work, but has few years that are being improving and investing a lot in the Business Intelligence “world”

But why as an independent BI consultant I believe in Microsoft?

1. Because Is open to the communities/and world in spite of almost other players that they follow a strategy to hide all information and knowledge from their products

2. Because Is a buyer in the market… Examples are the acquisitions of Datallegro, ProClarity, Mobicomp (mobile), Zoomix (data quality), Teradata… and for example partnerships with Dundas, Panorama…

3. Because in a near future BI will be for all users (to the masses) and not only for a few group of decision makers. Today BI is spread in all organization for operational, tactical and strategy areas. Nothing better than improve the capabilities of an existent product in the market that everybody knows what it is, and what it does… simple EXCEL.

4. Because almost the players (SAP, SAS, Microstrategy…) in the BI market provide very expensive tools that are not possible nowadays… Some years ago they could set these expensive costs, because in that time these tools could provide competitive advantage… today even open source solutions are available in BI…

Last decades this BI players was trying to convince the end users and decision makers that they need new applications/interfaces to analyze, monitor and plan their business, but they were wrong, and mainly because Microsoft enter few years ago in this market. The end users and decision makers doesn’t want to know what is behind excel… only wants to see their KPIs no monitor, analyze, plan and control their business in their preferred tool… EXCEL.

In the coming weeks Microsft will also launch CTPs in the Project Gemini (Excel and Sharepoint) and in the Project Madison (massively scalable data warehousing).