ETL/BI Blogger

Don’t miss Montreal SQL Saturday tomorrow!

Tomorrow at CRIM building a conference on SQL Server Server 2012 will take place. I will have the pleasure to talk about BISM Tabular. Here is an abstract of tomorrow's agenda:

9:00 : Introduction

9:15 : Nouveautés T-SQL

Cette session fera le tour des nouveautés les plus marquantes du T-SQL. Venez voir comment bénéficiez des Sequence, Lag, Lead, First_Value, Last_Value, Try_Convert, Parse, Try_Parse

Conférencier : Éric Moreau

10:00 Pause

10:15 : Analysis Services 2012 Tabular Models

Cette session explique et démontre Analysis Services 2012 Tabular et quel est son rôle dans une stratégie BI. Les différences d'utilisation entre ce produit et Analysis Services Multidimensional (UDM) seront aussi abordées.

Conférencier : Christian Coté

11:00 SQL Server 2012 Performance and Tuning (Session en anglais / English session)

This session will talk about various topics that have been improved in SQL Server 2012:

- Database Tuning advisor

- Column store indexes

- Online index create, drop and rebuild

Conférencier : Michelle Gutzait

12:00 - 1300 : Lunch

13:00 : SQL Server AlwaysOn

Cette session présentera la nouvelle option de haute disponibilité AlwaysOn de SQL 2012.

Conférencier : Pollus Brodeur

14:15 : Pause

14:30 : Nouveautés SSIS

SSIS 2012 regorge de nouveautés et d'améliorations, que cela soit le volet développement et déploiement. Cette session aura pour but de vous dévoiler un aperçu de ce qui vous attend dans cette version 2012.

Conférencier: Thomas Riquebourg

You can register now on tomorrow before the conference.

 

Hope to see you there!

Christian

Power Pivot 2.0 drill through issues resolved

I've been working with Power Pivot quite a bit lately and I encountered the following drill through problems:

The LocaleIdentifier property is not overwriteable and cannot be assigned a new value 

That error only happened when my users tried to use a PowerPivot Excel workbook that I created for them. On my workstation, it worked just fine. The problem was that my OS regional settings are different than those of my users. Mine are Englidh US and my ciustomers are set to French Canada. So, the problem is the dot (.) vs the comma (,) difference in the decimal separator.

When I imported my users flat files in PowerPivot , I did not clicked on the advanced button that would have allow me to set the language settings in which I would like to import the files. So, I had three solutions:

1. Change the OS regional settings of my users: since their regional policies are based on a corporate policy, which was not an option.
2. Change the decimal delimiter of my user's computer: for the same reason stated above, that was not an option too.
3. Re-Import the files using the correct language: that`s what I did. Fortunately, I had only 2 small flat files, it took me few minutes to do it but if I had many more files, I would have been in trouble.

Only 1000 lines are showing in the drill through results

My users wanted to see more than 1000 rows while drilling though their Power Pivot table. Resolving that issue was very simple: l went in the connection's properties and changed the value to whatever was needed

 

So, that's it for today. I hope those tips will help you some day.

Don’t miss the SQL SERVER 2012 VIRTUAL LAUNCH EVENT

SQL server 2012 virtual launch event is scheduled to be held tomorrow! Don't miss it!

www.sqlserverlaunch.com?WT.mc_id=otc-n-ca-loc--4021

Also, SQL Server 2012 RTM availability date is finally announced: April 1^st 2012. You can download an evaluation version till that day at the same address (link) above.

Christian

Renewed as a SQL Server MVP!

This morning, I received a confirmation email that announced me that I was renewed as a MVP. This is the third year in a row that I have this status. But this year is different; I am now a SQL Server MVP. I am very glad of it because it represents better what I am involved in and I think that I can make a great contribution in SQL Server BI community.

Christian

Speaking at Devteach Ottawa

I will have the pleasure to be speaker to the next Devteach that will be held in Ottawa November 2^nd to 4^th. I will do two sessions:

• Data validation strategies with SSIS
• Introduction to Data Quality Services with SSIS

Devteach Ottawa is sponsored by TechDays. In fact, this event is THE Techdays event for Ottawa. Don't miss it!

Christian

I really enjoyed my first SQL Saturday

Yesterday was my first time as a speaker to a SQL Saturday. The event was at Humber College in the Toronto area. 15-20 people attended my two sessions on SSIS and Visual Studio 2010 Database Development Tools. Considering the fact that about 60 people showed up, I can say that the topics l talked about were popular. I enjoyed the fact that this was a whole day on SQL Server only. I assisted some of the other sessions and they were very good. This also a chance to meet valuable people, both speakers and attendees, and learn on SQL Server features.

We'll try to do something similar to this next year in Montreal. I hope we'll have SQL Server Denali RTM at that time!

Christian

Presenting at Toronto’s SQL Saturday 93

I will be presenting at SQL Saturday 93 on September 17^th. This will be my first experience as a speaker at a SQL Saturday and I can't wait to be there. I will present on Visual Studio 2010 database development tools and, of course, talk about forthcoming Juneau. I will do a new presentation called "Data Validation Strategies with SSIS". This session will talk about the various ways to validate data using SSIS.

 

Christian

Presenting at Vermont Code Camp III

I will be presenting at the third edition of Vermont Code Camp. I'll make a session on SQL Server Denali CTP3. It's my third participation at VT Code Camp as a speaker. I always enjoy Burlington's surroundings and it's gonna be a nice driver over there.

SSIS with Matt Mason Sept. 7th

I am glad to announce for that Matt Mason will present on SSIS Design patterns at Montreal SQL user group. I saw a brief content of this session last Spring at Ottawa Code Camp and I can tell it will be a very good presentation. Interested? Just register at http://www.dotnetmontreal.com/events/25114241 . Hope to see you there!

Christian

SSAS STDEV calculation issue in Connect

HI, since I did not solve my issue for the STDEV function error is Analysis Services , I submitted the problem to Connect.Microsoft.com. Please, vote for it because I think this is a bug. But in order to assert it, I want to have the feedback from Microsoft.

 

Thanks,

Christian