Browse by Tags

• 2012
• Agile
• Best Practices
• Business Intelligence
• Engineering
• Integration Services
• MDX
• PASS
• SSAS
• T-SQL

• Execute a SSIS package in Sync or Async mode from SQL Server 2012

  Today I had to schedule a package stored in the shiny new SSIS Catalog store that can be enabled with SQL Server 2012. ( http://msdn.microsoft.com/en-us/library/hh479588(v=SQL.110).aspx ) Once your packages are stored here, they will be executed using Read More... Posted Thursday, November 24, 2011 6:45 PM by Davide Mauri | 6 Comments Filed under: 2012, SQL Server, SSIS

• PASS Workshop “Creating a BI solution from A to Z” - Interview

  If you’re still unsure if the workshop I’ll deliver at PASS Summit the next November - “Creating a BI solution from A to Z” - is a good choice for you or not, you can get some more details reading the brief interview here: PASS Summit Post-Con Preview Read More... Posted Friday, September 17, 2010 1:16 AM by Davide Mauri | 0 Comments Filed under: Best Practices, Business Intelligence, Engineering, MDX, PASS, SQL Server, SSAS, SSIS

• SET IDENTITY_INSERT little bug(?)

  While I was working on a package to incrementally load a dimension in the DWH I’m developing for a customer, I stumbled upon a tricky little bug (I think, I still have to have a response from MS) that had – and will have – a little impact on how I create Read More... Posted Wednesday, September 30, 2009 8:52 AM by Davide Mauri | 5 Comments Filed under: Agile, Business Intelligence, Integration Services, SQL Server, SSIS, T-SQL