This site, along with the others I maintain personally, run DotNetNuke. For those old enough to remember, DNN is based on IBuySpy, I actually work with one of the folks responsible for the original IBuySpy code and site.

Recently, DNN announced a security issue and here, just a couple of weeks later, they had an upgrade ready to go.

I personally like DNN. The modules and skins are easy to implement. I was able to take a couple of pieces of code I needed to handle WebQuotes and the like with very little work. It may not work for everyone and I still have some issues with my code I need to work through but it demonstrates that frameworks and open-source can work, even in the Microsoft World.

While I did have a relatively relaxing Memorial Day weekend, and did get to see Indiana Jones and the Crystal Skull, I also wrapped up the initial programming for SVN For SQL 2005.

While I will be spending time on a rented rowboat at the lake and doing some restful things, I think I know what I want to do about creating SVN-able files from the database.

Over the weekend I'll probably put together a little utility that will take basic user information and connect to a database and dump out views, sprocs, udfs, uddts, tables and such using SQLDMO to directories where it can be used for source code control with SVN.

I'll probably CCL the code or something.

Til next week

Josef

SQL Server 2005 does interface with Visual Source Safe. Which is, I suppose, a good thing.

But I hate VSS. Never truly liked it and, when I was introduced to SVN a few years back, did my best to give up VSS entirely. I've got an SVN server where I put all my important stuff and use Tortoise SVN as my interface. Quick, simple, mergeable... In short, many things that VSS isn't.

And I recently installed SP2 for SQL 2005 which FINALLY allows for scripting of database objects to seperate files again. So the first thing I did was dump databases out to directories as individual files and SVN them. Which was good. But there's no good way to say to the Script Wizard, "By the way, old chap, I'd like to just create those scripts for objects changed/created since this date." So I think I may write something, unless someone can point me to code that already does that. I'll use the DMO to create the script objects, that's for sure, but, until that time,...

Read More »

I actually wrote this some time ago but wanted to share it here as well....

This title and an appropriate picture, were on a co-worker's cube and so I said to him

I ran into something interesting and I'm not really sure what happened.

Code that has been running with no problem suddenly started to have performance impacts. When I took a look at the query's execution plan, I found that the expenses were all with a chunk of XML.  This stored procedure called another one (code reuse is good) that returned XML. I then queried that XML block a couple of times using variations on:

SELECT Tbl.Col.value('MediaID[1]', 'bigint'),Tbl.Col.value('FolderPath[1]', 'nvarchar(2048)') FROM  @MediaListXML.nodes('//assets') Tbl(Col)

For some reason, this took a long time to process, even with only three simple items in the XML. By changing the code to store the relevant columns in a table variable:

DECLARE @MediaList table(MediaID bigint,FolderPath nvarchar(2048)) INSERT INTO @MediaList select Tbl.Col.value('MediaID[1]', 'bigint'),Tbl.Col.value('FolderPath[1]', 'nvarchar(2048)')           FROM  @MediaListXML.nodes('//assets') Tbl(Col)

For whatever...

Read More »

Full Text Search can be a great tool but, like a double edged sword, sometimes it can be as painful as it is useful

A quick look at a problem that can occur when using functions in your code

When something runs in a process can be as important as how long it takes to run