June 2004 - Posts
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 (email@example.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
CREATE PROC dbo.up_FixObjOwners
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),
-- populate it
INSERT #ChangeOwners (Obj_Owner, Obj_Name, Obj_Type)
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
WHILE @Objcounter > 0
-- construct string for object ownership change
SELECT @Obj_Name = Obj_Owner + '.' + Obj_Name FROM #ChangeOwners WHERE id =
SELECT @Obj_Type = Obj_Type FROM #ChangeOwners WHERE id = @ObjCounter
SET @dynsql = 'sp_ChangeObjectOwner ''' + @Obj_Name + ''', ' + @DBO
print 'changing ownership on ' + @Obj_Type + ': ' + @Obj_Name
SET @ObjCounter = @ObjCounter - 1
-- ok all done, collect garbage
drop table #ChangeOwners
Webmonkey is back from the dead with fresh content:
Also up and running:
Seems to be a good resource for xhtml / CSS stuff.
Extra added bonus bit:
Webstandards links bonanza
Ms Mvp's Weblogs overview:
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:
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: firstname.lastname@example.org
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
Thanks to 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 :)
The contenders are:
1 GB + POP access. + Hosting + Blogs
2 GB no POP access
Unlimited filesize on the attachments.
Currently not excepting new members
1 GB no POP access
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:
Another one with some more options but with a less intuitive interface:
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:
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.
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.
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...
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.
To be more carefull with casing my functions and subs
That I really dont want to know what the gotchas are with casing in .NET
That Imports is in some ways superior to Using ( or different in ways I don't care about )
That background compiling is a very addictive