July 2012 - Posts

• Power View in SkyDrive

  UPDATE 02/08/2012, I have written an important follow-up to this blog post at Power View in SkyDrive revisited which has better news than what I have written below. Please read that blog post as well as this one. Sean Boon has begun an interesting blog Read More... Posted Monday, July 30, 2012 4:07 PM by jamiet | 9 Comments Filed under: excel, Power View, SkyDrive

• The difference between Excel Services and the Excel Web App

  If you follow Chris Webb’s blog (and if you’re a BI practitioner in the Microsoft space – why aren’t you following his blog?) you may know that I have an interest ( Chris calls it an obscure enthusiasm ) in developments surrounding Excel and its various Read More... Posted Friday, July 27, 2012 1:07 PM by jamiet | 1 Comments Filed under: excel, Excel Services, SkyDrive

• CASTs become CONVERTs in computed columns with implications for SSDT

  I discovered a peculiar little nuance in SQL Server yesterday that I think is worth sharing. Execute the following CREATE TABLE statement: CREATE TABLE _t ( c INT , [S_Profit] AS ( CAST ( 1 AS DECIMAL ( 19 , 6 ))) ); If you then go to Object Explorer Read More... Posted Thursday, July 19, 2012 12:03 PM by jamiet | 3 Comments Filed under: sql server, SSDT

• Execution Statuses [SSIS]

  I have been doing development on SQL Server Integration Services (SSIS) 2012 for a few months and I have quite a lot of experiences to share on this blog. Sharing them will happen over time but I do want to begin with this particular nugget. Very simply, Read More... Posted Wednesday, July 18, 2012 1:11 PM by jamiet | 6 Comments

• Using Composable DML to maintain entity history [T-SQL]

  I recently inherited a data warehousing SQL Server solution from my good buddy James Rowland-Jones (you may know him from his more auspicious role on the SQLPass board ) and it contained a very cool technique of using composable DML (a feature that arrived Read More... Posted Friday, July 13, 2012 3:09 PM by jamiet | 2 Comments Filed under: t-sql, sql server, Composable DML

• SQL Server job opportunities in South West London

  The company that I am currently working for, an ISV that supplies products to the world’s largest retailer and Consumer-Packaged-Goods companies, is on the look out for top notch SQL Server folks. If you are interested in either of these roles (click Read More... Posted Friday, July 13, 2012 11:05 AM by jamiet | 0 Comments

• SSIS Catalog, Windows updates and deployment failures due to System.Core mismatch

  This is a heads-up for anyone doing development on SSIS. On my current project where we are implementing a SQL Server Integration Services (SSIS) 2012 solution we recently encountered a situation where we were unable to deploy any of our projects even Read More... Posted Wednesday, July 11, 2012 4:36 PM by jamiet | 3 Comments Filed under: sql server, sql server integration services, ssis, SQL Server 2012, SSIS Catalog