.Net

Posting relating to anything .Net related.
SSAS: Creating a Rowset action with the ExecuteSQL .Net stored procedure
A few weeks ago I did a post introduced the ExecuteSQL .net stored procedure for SSAS. Chris Webb asked if this function can be called from Excel 2007 when it is set this up as a rowset action and I figured that this would make a good topic for a blog post. So the following screen shots show how you would go about setting up such an action. As a quick example I cheated a bit and set up an Rowset action that calls the sp_who2 system stored procedure. This way I did not have a depedancy on any particular ......

Posted On Thursday, July 2, 2009 7:42 AM | Comments (15)

Unable to start debugging on the web server
[via Paul Gielens] I installed VS.NET 2005 on my laptop last year when it RTM'd, but I recently had to edit a VS.NET 2003 ASP.NET project on it and kept getting an error “Unable to start debugging on the web server “. I figured that the issue was probably related to the installation of .Net 2.0, but running aspnet_regiis -i, did not fix things. Even the initial results on a visit to Google did not look promising. The first few hits I got were not much help until I came across the blog ......

Posted On Sunday, February 12, 2006 5:57 PM | Comments (2)

Rumour: VS.NET 2005 available on MSDN from October 15?
via Jeffery Palermo Yes, the public launch date and availability is still scheduled for the week of November 7th, but Microsoft will be releasing the software to it's MSDN Universal subscribers first on October 15th. I've been looking for changes from the Release Candidate to RTM, but I haven't found them yet. I'm glad the software is finally coming out. I've been working with .Net 2.0 since Beta 1 came out, and I'm looking forward to using the final product. The I've installed Beta 1, Beta 2, and ......

Posted On Thursday, October 13, 2005 11:21 AM | Comments (0)

Comparing WWF rules and the Microsoft Business Rule Engine
via Charles Young Charles has a long post here on comparing Comparing WF rules and the Microsoft Business Rule Engine (which is part of Biztalk), I have not finished reading it yet myself, but I was pretty impressed with what I have read so far so I thought I would share it. ......

Posted On Tuesday, October 11, 2005 9:18 AM | Comments (0)

SSAS: Executing Arbitrary SQL queries
I had a question a little while ago via my blog about possibly using a rowset action to execute a SQL query against a specified table. Although a rowset action will allow you to enter a SQL query, such a query is still executed against the current cube and only the subset of SQL supported by SSAS can be used. Basically the rowset action just returns a flattened result set. However what would be possible would be to write a .Net stored procedure and use that to execute your SQL query. The code itself ......

Posted On Thursday, June 18, 2009 11:20 PM | Comments (6)

Using PowerShell to update the case of Attribute names
I had a question recently about how to quickly convert all the attributes in a given database from UPPER CASE to Title Case. Now you could certainly write a C# or VB.Net based program, but I feel that a script is the way to go for a once off requirement like this and what better scripting environment could we ask for than PowerShell. So here is a short PowerShell script that does the job. [System.Reflection.Assembly... > $null [Microsoft.AnalysisServices... ......

Posted On Monday, March 17, 2008 12:01 AM | Comments (3)

SSAS: Analysis Services Stored Procedure Project (ASSP) 1.1 release is out!
It's been a little while since we did the initial release of ASSP, but things have been bubbling along quietly in the background and today we pushed out another release which in addition to a few minor fixes includes the following new features. ListFunctions - This is cool on a couple of fronts (and not just because it is one of mine :) ) Firstly it is practical because it will list all the available functions in all the .Net assemblies that have been registered either at the server or, if you pass ......

Posted On Sunday, June 24, 2007 10:32 PM | Comments (1)

Codeplex
This looks pretty cool and I have already seen a few articles touting it as the successor to GotDotNet. It will be interesting to see how this goes. I for one will be watching it closely. [via Oleg Tkachenko ] http://www.tkachenko.com/bl... CodePlex is an online software development environment for open and shared source developers to create, host and manage projects throughout the project lifecycle. It has been written from the ground up in C# using .NET 2.0 technology with Team ......

Posted On Tuesday, May 23, 2006 10:02 PM | Comments (0)

MSDN Nuggets
I have watched a few full length web casts from Microsoft and a couple of episodes of dnrTV. And while these are a great learning tool, it is not always easy to find an hour to set aside to watch many of these (well it's not easy for me <g> ) I came across the following after someone posted a reference to them on the aus-dotnet mailling list. MSDN Nuggets: http://www.microsoft.com/uk... The concept looks really interesting, these are little 10-15 minute videos on specific ......

Posted On Sunday, April 2, 2006 9:17 PM | Comments (1)