Activity overview
Latest activity by lucazav
How to skip database name comparing in a view?
Hi all,
I'm using SQL Compare 10.7.0.18.
I'm wondering if there's a way to compare, for example, these two viewsfrom two databases:SELECT *
FROM MyDatabaseA.MyTable
SELECT *
FROM MyDatabaseB.MyTab...
Hi Nick,
basically we start to load/transform data from the ERP system through several databases (Helper, Config, Staging) and
finally all the cleansed data is stored in the Datawarehouse database. So we have some SSIS packages between these db
that do the "dirty" work; we also can have SSIS packages that move/transform data into the same db.
We also create SSAS databases and SSRS reports based on the Datawarehouse db.
All this work is based on an Adaptive BI Framework, the rules of which will be described by my collegue Davide Mauri in a
website (http://www.engineeringbi.com, work in progress).
It'd be nice to have a tool that traces all the dependencies between all the objects of the BI stack.
E.g. starting from a dimension in a SSAS database, this tool will trace all the dependencies down to the staging database
table (passing through SSIS packages that may occur between objects, views or stored procedures, etc. etc.). Even parsing of SSIS SQL Tasks (in general of all SQL Commands) should be traced.
You should be able to group selected objects into logical layers. After you select one or more layers, or independent
objects in this tool, you'd be able to export a dependencies matrix of selected layers/object in Excel, or an XML file containing these dependencies.
More features like these can be implemented in order to facilitate the BI developer daily work. But I think the ones upon described are the most important.
Let me know by personal e-mail if you need further help.
Thank you / comments
Hi Nick,
basically we start to load/transform data from the ERP system through several databases (Helper, Config, Staging) and
finally all the cleansed data is stored in the Datawarehouse database....
This has already been requested by other users, it has been logged as DT-577 if you wish to chase it up in the future.
Is there a public requests repository so that I can browse other users requests?
Thank you so much. / comments
This has already been requested by other users, it has been logged as DT-577 if you wish to chase it up in the future.
Is there a public requests repository so that I can browse other users re...
BI Stack Dependency Tracker
I'm working on a BI project. It'd be very interesting to use an evolution of Dependency Tracker (e.g. BI Dependency Tracker) that is able to track all the dependencies beetwen SQL Engine, SSIS, SSA...
Filegroups not in suggestions
Hi all,
it'd be nice to have filegroup's suggestions in queries like this:ALTER DATABASE AdventureWorks
MODIFY FILEGROUP ...
Thank you.
Unhandled exception when browsing Analysis Services objects
Hi all!
I noticed that when I click on an Analysis Services object (a node in the Object Explorer, or a cube, etc.), I got an unhandled exception.
On the error popup I can read:Object not of the ex...
Paul Stephenson wrote:
...please try uninstalling SQL Refactor and then re-trying SQL Prompt 5.
and what if I need Refactor in order to work?
Thank you! / comments
Paul Stephenson wrote:
...please try uninstalling SQL Refactor and then re-trying SQL Prompt 5.
and what if I need Refactor in order to work?
Thank you!
Same here: Windows 7 32-bit Ultimate, SQL Server 2008 SP1, SQL Server 2005 SP3. / comments
Same here: Windows 7 32-bit Ultimate, SQL Server 2008 SP1, SQL Server 2005 SP3.