Entries for November 2008

Openforce 2008 Recap

29 Nov

It is amazing to think that OpenForce ended over two full weeks ago ever since returning home I have been swampped and haven't gotten around to my promised posting regarding the panel discussion that happened at the end of the session.  Although a bit late I thought I would share the notes that I made from the panel discussion on the final day of OpenForce.  The following items are not necessarily in any particular order, just the way they were scribbled into my notebook.

tags: DNN

Why Dynamically Attached Databases Cause Problems

24 Nov

One item that many people find unusual about my DotNetNuke installation guides is my insistence on NOT using the Database.mdf, dynamically attached database file for the creation of a DotNetNuke database.  In my tutorials I have quickly dismissed the topic by noting that "issues" come up when trying to use a dynamically attached database and I leave it at this.  Well after seeing more questions on this topic recently in the forums I wanted to take a moment to put my $0.02 out there as to WHY I don't like it.  I will do this by discussing quickly what the differences are in the two approaches, then I'll discuss the "downfalls" of each.

tags: DNN, SQL, .NET 2.0, General Tech, .NET 3.5

First OpenForce 2008 Update

11 Nov

Tom Kraak is doing a great job with Live Blogging over at, however, I thought it would be good to put a quick blog post up here about imp...

tags: DNN

Are you ready for OpenForce?

06 Nov

With OpenForce North America just a little over 3 days away I can feel the excitement building Bill Walker today announced the OpenForce Social event,...

tags: DNN

SQL Server RANK, ROW_NUMBER, and Partition

01 Nov

Finally getting the opportunity to get back to SQL Server 2005 development, and coming to the conclusion that NOT all of my projects have to support SQL Server 2000 I started looking all of those "fun" new items that we all really wanted. This article is going to go through a scenario that demonstrates how to use Common Table Expressions, Rank() and Partition to get results for a very common data scenario. We will present this information with an introduction to the problem, scripts to setup the problem in a test environment, and lastly the implementation, with a review/summary at the end.

tags: Tutorials, SQL

Content provided in this blog is provided "AS-IS" and the information should be used at your own discretion.  The thoughts and opinions expressed are the personal thoughts of Mitchel Sellers and do not reflect the opinions of his employer.

Connect with Mitchel

I hope the information here has been helpful. To stay connected you can also subscribe to blog updates via email, contact Mitchel about consulting services, or reach out for assistance via CodeMendor

Content Copyright

Content in this blog is copyright protected.  Re-publishing on other websites is allowed as long as proper credit and backlink to the article is provided.  Any other re-publishing or distribution of this content is prohibited without written permission from Mitchel Sellers.