I must admit that I really loves tools from RedGate and recently I’ve discovered the Sql Dependency Tracker, an exceptional tool to manage dependencies between objects in a database.
This tool is really great because with a few click you can have different graphs that represents dependency relation between objects in the database. I’m working on [...]
Continue reading about Red Gate Tools, Sql Dependency Tracker
I have a database where reports are done with stored procedure over the OLTP database, and we begin to suffer poor performance because we have a lot of data and sometimes reports are locked by transaction issued from components that does bulk data insertion.
A viable solution is moving all data in a DataWarehouse server where [...]
Continue reading about SSIS use parameter with ADO Net source in DataFlow