MS 2010 BI conference Dates announced

31 בדצמבר 2009

The 2010 Microsoft BI conference will be held on June 2010, and will be part of the 2010 TechEd North America, according to this blog post. I’m not sure I’ll be attending this conference, but definitely be on the lookout for a more detailed agenda to see if there is added value in me making the cross-Atlantic trip. With so many new features in the Microsoft BI stack for 2009 and 2010 ( a series of PowerPivot blog posts is coming up on this blog in the coming weeks, for example), there’s enough new material to cover and showcase...
תגיות: , ,
אין תגובות

Merging partitions – which direction should I merge?

29 בדצמבר 2009

When you work with large tables in SQL Server 2005 and 2008, you will inevitably start using partitioned tables in order to ease the maintenance of these tables, and improve query performance. I recently wanted to merge several partitions at the tail of an existing partition function, and I wanted to understand whether I need to merge the partitions in a sequential order from the last partition and work my way up the chain of partitions, or would it be better to start from the newest partition (that I can merge) and work my way down the chain of...
אין תגובות

SSIS Checkpoints

21 בדצמבר 2009

I’m using SSIS for several years now, and I want to shortly cover an SSIS feature which last week help me a lot: using checkpoints in order to recover failed packages. I’m currently developing an ETL solution which requires the import and export of data in and out of a production system on a daily basis, and it is very important to ensure the process only touches the system when required and does not impact on the system performance (or, should I say, impact the least). What I actually need is to get the daily content of several...
תגיות: , ,
אין תגובות

Report Builder 3.0 – Shared Data Sets

16 בדצמבר 2009

Technorati Tags: SSRS,Report Builder,SQL Server 2008 R2 I’ve been trying the new Report Builder 3.0, which ships with the SQL Server 2008 R2 November CTP and among the various new features, I want to write  a bit about the Shared Data Sets feature. Up until this version, report authors could create a data source, and when deploying the report could make the decision whether the data source for this report is shared among other users/authors or be linked only to the individual report they have created. If the report author decided to share the data source, new reports...
אין תגובות

Report Builder 2.0 – Where is the Report Model?

9 בדצמבר 2009

Technorati Tags: SSRS,Report Builder I thought I’d write about this topic, even though it’s a bit of an old news item, because I keep getting questions about this when I visit clients. As part of the SQL Server 2005 Reporting Services product, many of us were really enthusiastic about the Report Builder tool. This tool enabled the organisation's power users to create their own custom-made reports, using a pre-defined Report Model. This Report Model was simply a logical “map” of specific database fields that the administrator wrapped inside this model, thus enabling the users to simply drag and...
תגיות: , ,
אין תגובות

SSIS Performance – The OLE DB Source Adapter

2 בדצמבר 2009

Technorati Tags: SSIS,Data Flow Task I came across a BOL topic discussing SSIS data flow optimization techniques. For the OLE-DB source component there is a recommendation to use a SELECT statement instead of the "Table or View" access mode. For the sake of clarity, when you use the "Table or View" access method, you get to choose a specific table or view from the database you have designated as your source database, in a drop-down list. When you use the "SQL Command" access method, you can simply type in the query editor any SELECT statement you like. ...
תגיות: , ,
אין תגובות