Posting relating to anything .Net related.

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 ......
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 ......
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... ......
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 ......
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 ......
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 ......
[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 ......
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 ......
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. ......


About Me
I am a consultant, based in Melbourne Australia. I primarily work in the Business Intelligence area with SQL Server, although I also dabble in Content Management Server and .Net coding

Contact Me


Any and all code, software, examples, suggestions and anything else on this web site is available for you to use at your own risk. No warranty is expressed or implied.
Views and Opinions
The views and opinions expressed on this web site are not necessarily the views or opinions of my employer.

Subscribe in Bloglines Subscribe in NewsGator Online

Locations of visitors to this page


Tag Cloud

Article Categories


Post Categories

.Net Blogs

Aussie Bloggers

BI Blogs

CMS Blogs