Entries for November 2008

November 29, 2008

Openforce 2008 Recap

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.

November 24, 2008

Why Dynamically Attached Databases Cause Problems

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 DotNetNuke.com 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.
November 11, 2008

First OpenForce 2008 Update

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

Are you ready for OpenForce?

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,...
November 01, 2008

SQL Server RANK, ROW_NUMBER, and Partition

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.

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.

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.