Here it is 2012 already and I am just starting to play with schemas in SQL 2005. Anyway, follow the directions below to just start using a Schema as a container or namespace for your objects. Create a Role “schema_owner” and set the owner to dbo. Create schema “myschema” and set the owner to “schema_owner”. I personally used the same… Read more →
Desktop MOTD
“Try it, You’ll like it” says the wife. “Download it, use it.” says the developer “What is it? Why should I?” says the visitor Get it here. Well, it is a small application that I wrote to write messages onto your desktop picture. I wanted to see bible verses on my desktop that would rotate at some interval. To Use:… Read more →
Akismet: The WordPress AntiSpam Solution
I’ve installed Akismet, then found out for it to work, you need an API key. Well, I now have the API key, now to see if this thing works. Edit: Well, it seems to be working. If a blucastle blogger is interested in it, activate the plugin. Then go over to wordpress.com and create an account. You don’t have to… Read more →
YMMV: miles or words
A certain somebody has worn out his LifeType blog and needed me to 'check' it out. Well, I'm kicking the tires, checking the radio… seems to be working… On the flip side, I have put over7,500 miles on my motorcycle. Lately I've been putting somewhere around 60 to 70 miles on it every day. On most days, the roads are… Read more →
How to tell if Windows XP is activated.
Start, Run, type "oobe/msoobe /a" without quotations, hit Enter. http://www.computing.net/answers/windows-xp/how-to-tell-if-xp-is-activated/61146.html Read more →
Hilarious
This is so absolutely hilarious, I had to post. Read more →
Two-sided Printing from Adobe Reader on HP LaserJet 4M
1. Print Odd pages reversed. 2. Flip printed pages once long-wise and re-insert into the tray with text facing up and page top towards the front of printer. 3. Print even pages reversed. Read more →
Welcome to Earth Avery Llanes
My cousin Raquel is now the proud mama of a baby girl. See the beautiful picture below: See her hospital page here:http://www.our365.com/NewbornPortraits/HospitalDefault.aspx?sid=4575&S=true&SM=ByHospital&BM=1&BY=2009&BD=21 Read more →
SCOPE_IDENTITY() returns a value?
I have long used SCOPE_IDENTITY() to get the primary key of a newly inserted row immediately after the INSERT statement. For example: INSERT INTO myTableSELET @var = SCOPE_IDENTITY() What I incorrectly assumed was that the value was reset with each statement similar to the behavior of @@ERROR. If not each statement, then each INSERT statement. In other words, [@more@]if I… Read more →
Computer Security
In today's virtually connected world computer security is more important than locking your car. Some basic guidelines are: password minimum length of 8 characters. Passwords with less than 8 characters can be brute forced (systematic guessing) in less than 5 minutes. 8 character passwords will take a very long time. password of mixed alphanumeric characters. The first step in breaking… Read more →