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 →

Is your computer secure on the internet?

While looking around my blog, I noticed I had a post in draft form from last November. oops. Anyway, here it is.   While I was fumbling along last night on the internet, I ran across a comuter security website. One article in particular is about a honeypot that BBC had connected to the internet. A 'honeypot looks like a… Read more →

Site update

I have update our blogging software so there maybe some wierdness going on. Currently the Summary page is broken, but thats ok because I plan on replaceing it with one of my own. In the mean while you can get to Ardell's blog from my blogrole on the right and please ignore any warnings that show on a web page.… Read more →

The Lord is my programmer…

The Lord is my programmer, I shall not crash. He installed His software on the hard disk of my heart; all of His commands are user-friendly. His directory guides me to the right choices for His names sake Even though I scroll through the problems of life, I will fear no bugs, for he is my backup. His password protects… Read more →