September 2009 - Posts

• 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: SSIS, Integration Services, Agile, Business Intelligence, T-SQL, SQL Server

• Extended Properties in Object Explorer Details – Vote on Connect

  After a discussion with a friend of mine, I’ve opened a suggestion on Connect to request to have Extended Properties visible in the main Object Explorer Details window. This will be especially useful for creating self-documenting database, since that Read More... Posted Tuesday, September 15, 2009 9:10 AM by Davide Mauri | 1 Comments Filed under: 2008, Management Studio, SQL Server, Connect

• SQL Server 2008 Object Explorer Details

  Ok, maybe this post contains information that anyone already knows, but since I just discovered the SQL Server 2008 Object Explorer Details’ features today, maybe other people are in the same situation. In older version of SQL Server the Object Explorer Read More... Posted Saturday, September 05, 2009 1:13 PM by Davide Mauri | 3 Comments Filed under: 2008, Management Studio, SQL Server