SEO is a vital part of a successful site, especially if you offer a service or sell anything on your site. Sometimes the SEO abilities of the core blog are a little lacking. Here is one way to help control the permalink URL for blog items.

I have been working on a new web application and recently ran into an interesting situation where I wanted to add possibly hundreds of records from one data entry screen. In the past I have done this a few different ways:

Loop through set of data and add each row one by one. Create some delimited string and create some SQL to parse it into a temp table.  Both of those methods work but have serious drawbacks. Method one is very easy to program but all those insert statements cause a lot of traffic to and from the database, this can cause a lot of scaling issues. Method two works if you are only inserting one value at a time and that value is not complex like lots of text or image byte arrays. A much easier method of doing this would be to create a table fill it with data and simply use a insert statement to select all records from the table into our datatable. Now with SQL 2008 we can pass Table Valued Parameters (TVP) to a stored procedure and use it just like any other table in the...

This question came from Twitter but thought it was a good quick fix here is a step by step on doing just that.

1. Log in a host account
2. Navigate to the SQL module under the Host menu
3. Run the following script

   UPDATE Users set UpdatePassword = 1 WHERE UserID in (SELECT UserID from UserPortals WHERE PortalId = X)

   --replace x with the id of the portal
4. Select 'Run as script' check box
5. Click Execute

Of course this script assumes you know what portal you are running this against, and that there is no object qualifier for the DNN database.