Iman Eftekhari's Blog

A bug in ASP.Net 2.0 Gridview control and ...

2008-05-03T20:12:00.020+10:00

I don’t know why it has to be like this! I know BUG is a non-detachable part of software development and according to a Murphy’s law: "Each computer code has five bugs, and this number does not depend on how many bugs have been already found." (!?)

But, when a bug was found and reported to a company like Microsoft, why it should take so long to fix it? And isn't it better if Microsoft add a note or comment in MSDN like: "this is a known bug and here is the workaround..." so that people don't get confused by getting a different result from a sample code? Or maybe Bill Gates wants to make developers more creative?!

To make the long story short, last week after several frustrating hours debugging a Gridview image button which was firing an command event twice, I found it's a known bug in ASP.Net 2.0 and was reported to Microsoft on 2006, and yet to be fixed! The funny thing is it works fine when you have a LinkButton instead of ImageButton.

I finally found a workaround for this:

Put your imagebutton in an ItemTemplate and add:

commandargument="<%# DataBinder.Eval(Container,"RowIndex") %>"

The rest is same as other Gridview commands, you need to write your code in RowCommand event of the Gridview and find the index of the row like this:

Dim index As Integer = Convert.ToInt32(e.CommandArgument) Dim myRow As GridViewRow = CartGrid.Rows(index) If (e.CommandName = "YourCommandName") Then ....

Have a look at this page, (a frustrated developer was trying to get help about this issue and answer of Microsoft Online Support...):

http://www.netnewsgroups.net/group/microsoft.public.dotnet.framework.aspnet/topic16694.aspx

"First to Know" Visual Studio 2008 and SQL Server 2008 exam offer

2008-03-24T22:31:00.003+11:00

http://www.microsoft.com/learning/mcp/sqlvs/offer/default.mspx

Goodbye SDM!

2008-02-29T22:16:00.001+11:00

Today was my last day at SDM. I'm going to join the "contractors club" to experience a new type of work and want to be an independent consultant in the near future. Hence I'm starting a contract role in Tenix on a large-scale data migration project.

Working at SDM was a great experience for me and I have learned a lot and made some good friendships over the 1 year working with them.

Exam 70-551: UPGRADE: MCAD Skills to MCPD Web Developer by Using the Microsoft® .NET Framework

2008-02-27T14:42:00.003+11:00

Today I passed 70-551 (a tough one!) and upgraded my MCAD to MCPD. The exam was devided in 3 sections and each section was contained of 30 Questions:

Section 1 - .NET Framework Fundamentals
Section 2 - Core Web Application Development
Section 3 - Application Development Advanced Topics

Time for each section was around 70 minutes which seems not to be enought.Once you finish one section, you can't go back to that section again. Passing score is 700.

The first section was specific to web applications and it has a bunch of question with mobile pages, web forms and new web controls like webparts, login, profiles, site map and master page as the main topics.

The second part of the exam was the hardest one, it was related to framework and types with security attributes, xml serialization attributes, class design and generics in its topics.

The third part was the architecture one and it was lot of logical questions about designing solutions, unit testing, code coverage and integration test and best practices.

Check out this links:

SQL Server 2008 - CTP 6

2008-02-22T17:02:00.005+11:00

The latest Community Technology Preview of SQL Server 2008 is available.

SQL Server 2008 CTP6 is "feature complete," which means that Microsoft won't be adding or removing features between now and RTM later this year.

SQL Server 2008 February CTP 6 can be downloaded from here

Microsoft Positioned in Leaders Quadrants in Magic Quadrant for BI Platforms

2008-02-13T14:52:00.005+11:00

Congratulations Microsoft!

You can read the press release on the news here.

Overview of SQL Server 2008 Business Intelligence by Tom Casey

2008-02-11T22:34:00.000+11:00

In this 9 minutes video, Tom Casey (general manager SQL Server Business Intelligence at Microsoft) gives an overview of BI in SQL Server 2008 (code name Catmai)

http://www.microsoft.com/sql/2008/bi/

What's New in Microsoft SQL Server 2008 for Business Intelligence

2008-02-09T22:12:00.000+11:00

Integration Services in SQL Server 2008

SSIS 2008 provides the data integration features such as SSIS pipeline, SSIS persistent lookups, and SSIS data profiling that help you to integrate data more effectively.
SSIS 2008 provides data warehousing features and tools that help you to effectively manage large volumes of data. These features and tools include partitioned table parallelism, query optimization, Resource Governor, and data compression.
SQL Server 2008 provides the MERGE statement that helps you to simplify the code and enhance the system performance. You can also use the MERGE statement as a join between a target that is the recipient of the DML and a source that is the provider of the data.
SQL Server 2008 provides the CDC (Change Data Capture) feature that helps you to insert records, update, and delete activities applied to SQL Server 2008 tables. You can use CDC to store details of the changes in an easy relational format. CDC also provides a structured, reliable stream of change data that can be applied by users to dissimilar target representations of data.

Reporting Services in SQL Server 2008

SSRS 2008 includes the report server that is used to set a memory threshold for background operations and performance counters for monitoring service activity.
SSRS 2008 supports two modes of deployment for report server, the native mode and SharePoint integrated mode.
SSRS provides the report authoring features that help you to manage large reports. These features include Report Designer, data visualization, and Tablix.
SSRS provides the report delivery features that help you to generate reports. The features include rich-text, Office Word rendering, Office Excel rendering, export to Office Word and Office Excel, and report delivery through MOSS.

Analysis Services in SQL Server 2008

SSAS 2008 provides several Cube Designer enhancements for better detection and classification of attributes along with identification of member properties. These enhancements include Analysis Services personalization extensions, best practice alerts, enhanced dimension design, enhanced aggregate design, and dynamic named sets.
SSAS 2008 provides you with the capabilities to can enhance the data mining models by appending a new algorithm to Microsoft Time Series algorithm. This new algorithim is based on the ARIMA algorithm. This enhancement improves the accuracy and stability of predictions in the data mining models.
SSAS 2008 provides several performance enhancements to manage cube space. The enhancements include subspace computation, MOLAP-enabled write back capabilities, scale-out analysis, and scalable backup tool.

Source: MS Clinic 6189: What’s New in Microsoft® SQL Server™ 2008 for Business Intelligence

PPS 2007 MCTS Exam 70-556 Now Available

2008-02-01T14:56:00.000+11:00

Prometric already listed the exam on its site.

The official preparation guide for the exam:

http://www.microsoft.com/learning/exams/70-556.mspx

MCITP – Business Intelligence Developer (Exam: 70-446)

2007-12-08T17:47:00.000+11:00

Today I passed 70-446 exam. There were 6 scenarios and around 10 questions for each scenario and 30 minutes for each scenario. Not too hard and many straightforward questions if you have done a few projects and are familiar with concepts like: dimensional modeling, cube designing, SCD (especially type-2), data mining. There are only 183 MCITP -BI Developer all around the world up to now compare to 3,232 MCITP (DBA) or 148,244 MCDBA (SQL 2000), that's a very small number. Not sure if that means the MS BI is not popular or it is still young or because it’s a new exam or … (?)

Number of Microsoft Certified Professionals Worldwide

I found these links very helpful:

Slowly Changing Dimension (SCD)

2007-12-07T17:09:00.000+11:00

There are different types of Slowly Changing Dimension:

Type 1 (overwrites the original information) (http://www.1keydata.com/datawarehousing/scd-type-1.html)
Type 2 (a new record is added to the table to represent the new information, keeps all historical information) (http://www.1keydata.com/datawarehousing/scd-type-2.html)
Type 3 (keeps original value, and current value in different columns of the same record) (http://www.1keydata.com/datawarehousing/scd-type-3.html)
Type 4: uses "history tables", where one table keeps the current data, and an additional table is used to keep a record of some or all changes
Type 6 (2+3+1) (hybrid approach that combines the three fundamental SCD techniques)

Note: SSIS SCD control only supports Type1 and Type2. But by identifying columns with the fixed attribute update type, you can capture the data values that are candidates for Type 3 changes.

Slowly Changing Dimension Transformation (http://msdn2.microsoft.com/en-us/library/ms141715.aspx)
Configuring Outputs Using the Slowly Changing Dimension Wizard (http://technet.microsoft.com/en-us/library/ms141662.aspx)
http://en.wikipedia.org/wiki/Slowly_changing_dimension

Slowly Changing Dimension Transformation Outputs
Output	Description	Data flow requirements
Changing Attributes Updates Output	The record in the lookup table is updated. This output is used for changing attribute rows.	An OLE DB Command transformation updates the record using an UPDATE statement.
Fixed Attribute Output	The values in rows that must not change do not match values in the lookup table. This output is used for fixed attribute rows.	No default data flow is created. If the transformation is configured to continue after it encounters changes to fixed attribute columns, you should create a data flow that captures these rows.
Historical Attributes Inserts Output	The lookup table contains at least one matching row. The row marked as “current” must now be marked as "expired". This output is used for historical attribute rows.	Derived Column transformations create columns for the expired row and the current row indicators. An OLE DB Command transformation updates the record that must now be marked as "expired". The row with the new column values is directed to the New Output, where the row is inserted and marked as "current".
Inferred Member Updates Output	Rows for inferred dimension members are inserted. This output is used for inferred member rows.	An OLE DB Command transformation updates the record using an SQL UPDATE statement.
New Output	The lookup table contains no matching rows. The row is added to the dimension table. This output is used for new rows and changes to historical attributes rows.	A Derived Column transformation sets the current row indicator, and an OLE DB destination inserts the row.
Unchanged Output	The values in the lookup table match the row values. This output is used for unchanged rows.	No default data flow is created because the Slowly Changing Dimension transformation performs no work. If you want to capture these rows, you should create a data flow for this output.

SQL Server 2005 Books Online (September 2007)

Usage-Based Optimization in Analysis Services 2005

2007-12-06T17:05:00.000+11:00

You can optimize partitions of a measure group based on the usage. Here is the full instruction:

http://www.databasejournal.com/features/mssql/article.php/10894_3575751_1

What is "Microsoft Office PerformancePoint Server 2007"?

2007-12-02T17:43:00.000+11:00

Well, Microsoft says:

"Microsoft® Office PerformancePoint™ Server 2007 is an integrated performance management application that provides robust monitoring, analytics, and planning capabilities. Office PerformancePoint Server 2007 helps businesses to articulate goals; monitor business activity; identify and analyze issues; and collaborate and take action."

PPS is very feature rich. It has all the functionality customers can expect if they need to plan, budget, forecast, scorecard, dashboard their business activities and use management reporting and consolidation. In addition, all users work with a single data model whether they are monitoring, analyzing and planning.

We can’t talk about PPS and don’t mention two names: Adrian Downes and Nick Barclay my ex-colleagues at SDM and PPS gurus. Their books about PPS 2007 have just been published a couple of days ago:

Here are their blogs:

Here are some more useful links about PPS 2007:

Microsoft Office PPS 2007 - beta exam

2007-12-01T17:35:00.000+11:00

Unexpected Certification!

A few weeks ago, I sat for a Microsoft beta exam 71-556 "TS: Microsoft Office PerformancePoint Server 2007, Application Development". I didn’t expect to pass it as I didn’t have any real project experience, but I did!

That's the new look of MS certifications:

Some exam topics from our memory (myself and my colleague Lisset):

Refresh rate Interval - (PPSAddInforExcel.chm)
Assignment rule, allocation rules - PEL Syntax
Rule set types and rule types - (PPSPlanningBusinessModelerHelp.chm)
PSSAddinforExcel.dll
Review all the help - (PPSAddInforExcel.chm) - is small and there are different questions about it. (e.g. parameters)
Business Roles – administrative Roles. Very clear what to do which each one. Security and roles - (PPSPlanningBusinessModelerHelp.chm)
Update member property - (PPSPlanningBusinessModelerHelp.chm)
Current Time period - (PPSPlanningBusinessModelerHelp.chm)
Association- (PPSPlanningBusinessModelerHelp.chm)
Member set- (PPSPlanningBusinessModelerHelp.chm)
Installing the PPS (Clean Installation)
Building the Reports, defining filters, show the leaf members, link the reports in worksheet (PPSAddInforExcel.chm)
Generic models, sub sites, Associations - (PPSPlanningBusinessModelerHelp.chm)
Workflow, setup roles, modify the existing workflow - (PPSAddInforExcel.chm, PPSPlanningBusinessModelerHelp.chm)
Creating Data Sources, DSN
Create an association to move data between models PPSPlanningBusinessModelerHelp.chm)
Assumption models - (PPSPlanningBusinessModelerHelp.chm)
Defining a SCOPE statement - (PPSPlanningBusinessModelerHelp.chm)
Data Integration: Sync the staging DB, Loading data from staging to application database - (PPSPlanningBusinessModelerHelp.chm)

MS BI Summit 2007 - Melbourne - Australia

2007-11-29T17:33:00.001+11:00

Microsoft BI Summit was so interesting for me specially meeting many of ex-colleagues and clients. One of the most exciting parts was when Sean Downer (Manager - Decision Support, Royal Children's Hospital, Melbourne) presented the RCH BI system (which I was involved in development of the system) as the case study of a successful MS BI system. They are using SharePoint server to host a dashboard designed by the Business Scorecard Manager (BSM) which includes scorecards and SSRS reports talking to SSAS cubes.

Another exciting session was "PerformancePoint Server 2007: Monitoring and Analyzing", which Nick Barkley (our ex-colleague at SDM) presented the new features of PPS 2007 Monitoring module and how developers can develop the project in their local system without have to deploy it to SharePoint to see the result.

There were some other informative sessions about data mining, MDX and PPS Planning & Budgeting which all had some interesting points.

Last session was presented by David Lean (from Microsoft). He talked about new BI features and new performance improvements in SQL Server 2008.

Hello World!

2007-11-28T17:00:00.000+11:00

3....2.....1.... and now I'm a blogger!

I’m going to share some Business Intelligence stuff I learn in my job and some stuff I learn from life.

If you are a Microsoft fan, you may find some good stuff here, otherwise don't waste your time here!