Upgrading to SQL Server 2008 Notes

As we move down this SQL Server 2008 upgrade road I am trying to learn from previous projects of other versions and not take anything for granted. So, I am taking the time to research upgrade paths and issues as we look at moving forward.

First I needed to check and see if there is a supported upgrade path from SQL Server 2008 Enterprise Edition Evaluation to the full licensed product. Indeed there is according to this MSDN article

GMAP_Location module and Block Caching

Was working on another Drupal 6 site yesterday and worked on addressing a few issues that have crept up for the beta testing

Upgrading SQL Server Reporting Services Reports From 2005 to 2008

We just ordered our licenses for SQL Server 2008 (various editions). :) Now it is time to get ready for the migration. While doing some research on the actual report .rdl upgrade process I figured I’d put my findings here.

The Performance Point Blog has this FAQ that has a few good tidbits. The one that stuck out to me was the last one:

“Q: I know that every once in a while, a 2005 report won’t auto-upgrade to

A SQL Quiz – Follow Up

So Jason Massie has called me a many other out on this recent post. Ha! :) Of course looks like Chris Shaw was the real instigator.

So, he wants us each to share a stupid mistake we’ve made regarding our roles as DBA’s. For myself, I certainly use the term DBA very lightly. Anyhow, that post got me thinking, what was the biggest stupid mistake I’d made over so many years working with DB’s that others could learn from?

CMS Made Simple – Photo Album module and CSS Layout Issue

Was helping someone work out an issue with a layout issue on a website running on CMS Made Simple content management system. Honestly, I’ve never used CMSMS. After a bit of looking around, it seems like a great little, page based cms.

Taming Drupal Permissions and Unpublished Nodes

Back in May, I wrote about the great work of Brad (beeradb) from the Aten Design Group. Brad helped figure out how to allow users with appropriate roles to view unpublished nodes without using the overkill of “administer nodes” permission which includes all content types.

Brad blogs about this solution on the Aten Design Group blog.

View Unpublished Content Without Administer Node Rights in Drupal

“Dude, you got to see this!” is what I was shouting in the office a few minutes ago.

We have been bumping up against the fact that in Drupal you have to have the Administer Nodes permission in order to see unpublished nodes. The down side is that it means users in the role with Administer Nodes permission can see ALL nodes

Bullets not Working with Markdown?

Today I had a staff member who was create a new page in the Drupal implementation and could not get the bullet syntax of Markdown to render real bullets in the content body. Scratched my head a few times and created a test page.

← Newer PostsOlder Posts →