Sep 25 2009

Microsoft gets into Media Monitoring

Hopefully they'll devote some resources to this ... anyway, read more at: http://adage.com/digital/article?article_id=139199.

Sep 24 2009

Libraries, the inevitable transformation ...

Just read an interesting discussion on the future of libraries ... the author thinks that they'll transform into decentralized, sparsely staffed (I agree) ... basically glorified study areas. Read the article at: http://www.insidehighered.com/news/2009/09/24/libraries.

 

Sep 15 2009

Recover host password ... from Dotnetnuke installation

Ever forget your DNN host password? Just found a nifty SQL script that allows you to reset the pw ... it worked for me. From: http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/108/threadid/42369/scope/posts/threadpage/2/Default.aspx. You'll need access to SQL Server to run this (Enterprise Manager access will work fine).

 

Declare @UserName NVarChar(255)
Declare @NewPassword NVarChar(255)
Declare @PasswordSalt NVarChar(128)
Declare @Application NVarChar(255)

-- Enter the user name and new password between ''
-- do not leave any spaces unless intended to do so.
-- Edit only between single quote characters
Set @UserName = 'host' -- This is a default DNN admin user; the default host user is 'host'
Set @NewPassword = 'password' -- Your new password

SET @APPLICATION = (SELECT [APPLICATIONNAME] FROM ASPNET_USERS U,ASPNET_APPLICATIONS A WHERE  U.APPLICATIONID = A.APPLICATIONID AND  USERNAME=@USERNAME)
Set @PasswordSalt = (SELECT PasswordSalt FROM aspnet_Membership WHERE UserID IN (SELECT UserID FROM aspnet_Users WHERE UserName=@UserName))

Exec dbo.aspnet_Membership_ResetPassword @Application, @UserName, @NewPassword, 10, 10, @PasswordSalt, -5