Browse by Tags

• Analysis Services
• collation
• Datadude
• dimension cubes
• sql server analysis services
• sql server integration services
• ssis
• SSRS
• Visual Studio

• Build-time dependency resolving coming to Entity Framework. Now, how about those BI tools too?

  Three months ago I wrote a blog post entitled Some thoughts on Visual Studio database references and how they should be used for SQL Server BI where I shared some thoughts on a feature available to database developers in Visual Studio 2010 that I would Read More... Posted Tuesday, December 7, 2010 11:04 AM by jamiet | 4 Comments Filed under: sql server, SSAS, ssis, SSRS

• Some thoughts on Visual Studio database references and how they should be used for SQL Server BI

  Over the past few weeks I have been making heavy use of the Database tools in Visual Studio 2010 (formerly known as datadude, DBPro, VSTS for Database Professionals or one of a plethora of other names that it has gone by over the past few years) and one Read More... Posted Tuesday, September 14, 2010 2:53 PM by jamiet | 5 Comments Filed under: Datadude, sql server, sql server integration services, SSAS, ssis, SSRS, Visual Studio

• Mind that collation : SSAS

  I’ve been using Analysis Services a lot lately in my current day job and recently encountered an issue that I believe people need to be aware of. The issue transpired to be a bug in our application rather than in Analysis Services itself but it was brought Read More... Posted Monday, February 15, 2010 8:29 PM by jamiet | 4 Comments Filed under: collation, sql server, sql server analysis services, SSAS

• The SQL developer gap (Warning: rant coming up)

  I recently submitted a bug to Microsoft Connect concerning the behaviour of the expression language in SSRS, if you’re interested you can read about it here: DateAdd() doesn't throw an error when it has invalid parameters . I got a swift and detailed Read More... Posted Wednesday, January 13, 2010 12:43 AM by jamiet | 15 Comments Filed under: sql server, SSAS, ssis, SSRS

• Dimension cubes

  This is a quickfire blog post about a feature in Analysis Services that I have learnt about recently – Dimension Cubes. As of Analysis Services 2005 every single dimension in an Analysis Server database implicitly has a dimension cube created for it. Read More... Posted Thursday, December 31, 2009 12:14 AM by jamiet | 3 Comments Filed under: Analysis Services, dimension cubes, sql server, SSAS