Mischa Kroon

Just got this from someone on irc worked great for me :)

There are a couple of uses for this... hopes it helps someone else as well.

------------------------------------------------------------------
-- Name: dbo.sp_FixObjOwners
-- Auth: Sal Terillo (sterillo@hotmail.com)
-- Date: 10/1/2002
-- finds objects that are not owned by dbo
-- and changes them to dbo
-- this eliminates the problem with objects accidentally
-- created as being owned by someone other than dbo
-- REVS:
--
------------------------------------------------------------------

CREATE   PROC dbo.up_FixObjOwners
AS
SET NOCOUNT ON

DECLARE @dynsql varchar(1000)
SET @dynsql = ''

DECLARE @Obj_Owner sysname
SET @Obj_Owner = ''

DECLARE @Obj_Type VARCHAR(30)
SET @Obj_Type = ''

DECLARE @Obj_Name sysname
SET @Obj_Name = ''

DECLARE @ObjCounter INT
SET @ObjCounter = 0

DECLARE @DBO CHAR(3)
SET @DBO = 'DBO'

-- temp table to hold all objects not owned
-- by DBO
create table #ChangeOwners(
    id int identity(1,1),
    Obj_Owner sysname,
    Obj_Name sysname,
    Obj_Type varchar(30))
-- populate it
INSERT #ChangeOwners (Obj_Owner, Obj_Name, Obj_Type)
select
    su.name,
    so.name,
    case
        when type = 'u' then 'table'
        when type = 'p' then 'sproc'
        when type = 'v' then 'view'
    end as obj_type
from sysusers su
join sysobjects so
on su.uid = so.uid
where su.name not in ('information_schema', 'dbo')
and so.type in ('p', 'u', 'v')
-- select * from #ChangeOwners

SET @ObjCounter = @@rowcount    -- holds the count of rows inserted into
#ChangeOwners

WHILE @Objcounter > 0
   BEGIN
    -- construct string for object ownership change
    SELECT @Obj_Name = Obj_Owner + '.' + Obj_Name FROM #ChangeOwners WHERE id =
@ObjCounter
    SELECT @Obj_Type = Obj_Type FROM #ChangeOwners WHERE id = @ObjCounter

    SET @dynsql = 'sp_ChangeObjectOwner ''' + @Obj_Name + ''', ' + @DBO
    --select @dynsql
    print 'changing ownership on ' + @Obj_Type + ': ' + @Obj_Name
    EXEC(@dynsql)
    SET @ObjCounter = @ObjCounter - 1
   END

-- ok all done, collect garbage
drop table #ChangeOwners

Webmonkey is back from the dead with fresh content:
http://hotwired.lycos.com/webmonkey/

A great resource that it has is it's javascript code library check that out here:
http://hotwired.lycos.com/webmonkey/reference/javascript_code_library/

Also up and running:
http://www.alistapart.com/

Seems to be a good resource for xhtml / CSS stuff.

And last but not least Oreilly's javascript / Flash site:
http://www.oreillynet.com/javascript/

Extra added bonus bit:

Webstandards links bonanza
http://www.simplebits.com/notebook/2004/06/21/bonanza.html

Ms Mvp's Weblogs overview:

http://www.msmvps.com/

Eli Robbilard has put up a list of Share point links at his bog: http://weblogs.asp.net/erobillard/archive/2004/06/17/158311.aspx

Sharepoint is definitely something which I might dig into in the future, it seems that it could be the right tool for the job in a lot of occasions. But for now I haven't really run into those occasions just yet :)

Can be found at:

http://uptime.openacs.org/uptime/

What it does:

Give it an email address and a url which it will then monitor, when the site goes down it sends you an email.
When the site goes back up, it sends another email.

Offcourse this sort off thing can also be created quite fast but still to have a free service do it for you can be handy :)

Seems like this blog is turning into my about email blog :)

But this is one of those “for me” links, somehow this service isn't spelled the way I'd expect it to be so using the allmighty google turns up a blank... so I'm adding it here for future reference.

So what is it:

It's a email gateway which can display all emails sent to a specific account, without registration and deleting the emails a couple of hours later.

So: Fill in a registration form leave: mischa@mailinator.com

goto: http://www.mailinator.com

Fill in mischakroon and check email or goto: http://www.mailinator.com/mailinator/CheckMail.do?email=mischa

Ohh offcourse this service is free :)
More information can be found on:

www.mailinator.net / www.mailinator.net

Edit:

Thanks to Ashutosh Nilkanth for pointing it out there is also

Jetable which does about the same thing but which lets you create an email first and desciding how long it should be available. I've read about this one in the past as well but also haven't been able to find it again, nice to have the link again :)

http://jetable.org/

The contenders are:

SpyMac

1 GB + POP access. + Hosting + Blogs

AventureMail

2 GB no POP access
Unlimited filesize on the attachments.
Currently not excepting new members

Gmail

1 GB no POP access
Threaded view
Enhanced search
Privacy problems ?

From MSDN Downloads:

"Common utilities for writing an ISO file to recordable media such as CD-R include ISORecorder and Nero. The contents of images files can be extracted to hard drive using utilities such as ISObuster or DaemonTools. Image files can be mounted locally using the Virtual CD-ROM Control Panel for Windows XP."

Through:  Mark Brown 

To complete the ISO / Burnsoftware list, some other freebies:
Deep burner, a good free piece of burn software with a nice interface:

http://www.deepburner.com/download/DeepBurner1.exe

Another one with some more options but with a less intuitive interface:
http://www.burn4free.com/

Nuff said :)

A while ago I came across a product which really looks good to me:

A PC to Phone connector this connector connects any phone and connects it to a pc through USB effectively making it possible to use your standard phone with things like MSN / SKYPE / ICQ etc. which is great :)

It seems to me that this solution is a whole lot cheaper and easier as getting the wireless headset I was thinking about for using Skype / MSN with voice conversations and this should be able to save me a lot of money  in mobile phone bills while being equeally comfortable with calling :) 

I'm usually programming in VB.NET now for the first time I'm using a project done in C# as the basis of a website.
Should be simple enough right, well I haven't really looked at C# much in the past and I have to say my eyes are opening while using this programming language.

So whats been different:

Using vs Imports:

Using can only use namespaces while Imports also supports classes.

Case sensitive programming:

Because im used to programming in VB.NET this allows you to be sloppy with casings, I mean who cares that your doing functions without capitalisation... well the people using these functions from the case sensitive languages offcourse.

Unfortunately I'm not the only one with problems doing this in a good way even MS screws up sometimes, well either that or im not totally clear on naming conventions:

Why is it that it's:
DataTable
and Hashtable

A friend of mine ( a Java programmer ) told me that the Java guys made the same mistake with the Hashtable in Java thats why the next version of the Hashtable in Java became a HashMap. Well actually I'm still not completly clear on what a HashMap is but thats something for later worries, if I'll worrie about it at all.

Explicit casting:

How nice that in VB.NET I don't have to explicitly convert / cast everything and that it will do the conversions for me or at least try :) Well actually it might or might not be better don't know, with VB.NET i wen't the path of multifunctional checking functions without explicit casting. With C# another solution will probably be a lot better.

Background compiling:

Here I am trying to figure out why my code isn't working trying to teach myself to work with an unfamiliar language, and just at this time VS.NET stops the background compiling to check for syntax errors.
Just when I need it most, and with a large project, so high comile times...

Helping hand:

There is one big helping hand in all this the VB.NET --> C# converter I'm using the converter from sharpdevelop
Which is quite good but still quite far from perfect.

Lessons learned: