December 2004 - Posts

SCHEMABINDING Option
I've never run into the situation where I was worried about a table being accidentally dropped (maybe I should have been?) as I usually let a good security model restrict that. But, accidents do happen. So, if I ever need to make sure a table isn't dropped Read More...
Posted 27 December 04 08:55 by ryanm1201 | 0 Comments   
Filed under
Select DISTINCT in a DataTable
Just a quick bookmark...Found this posting by Sahil Malik on how to implement a SELECT DISTINCT from a DataTable. It required the table to be sorted, but it's a good start. Read More...
Posted 27 December 04 08:40 by ryanm1201 | 0 Comments   
Filed under
Zipcode/Postalcode Validation
My current client has customers that are located all throughout the world, but the majority of which reside or work in the US, Canada or the UK. We recently had a situation where a user was inputing a postal code for a Canadian residence and they did Read More...
Posted 22 December 04 10:48 by ryanm1201 | 0 Comments   
Filed under
Research Your House
I'm terrible with names. So much so that if I don't use it on a daily basis I'll more than likely forget it within a couple of days. Such is the case with my neighbors. I met them when I first moved in, didn't talk to them for a couple of days, and promptly Read More...
Posted 21 December 04 01:55 by ryanm1201 | 0 Comments   
Filed under
What's the Population of Madagascar?
Beats me. But I found a really cool site that will tell you. And the best part is, it's paid for by our tax dollars. It's called The World Factbook and is put together by our friends at the CIA . Oh, the population is 17,501,871. Read More...
Posted 16 December 04 09:34 by ryanm1201 | 0 Comments   
Filed under ,
Is Your Fourth Grader a Criminal
The whole “school violence” and political correctness of this world is really getting to me. As a father of two it's getting close to being frightening. Not that I'm worried my kids will be the victim of some crazy kid...I'm more worried that Read More...
Posted 12 December 04 07:28 by ryanm1201 | 0 Comments   
Filed under
Code Snippets in Visual Studio
There's a lot to be said for working solo, but working in an environment with other developers definitely has its advantages. Earlier, I posted about a co-worker who asked me a question about SQL and I had to dig through my brain to re-discover a way Read More...
Posted 09 December 04 06:17 by ryanm1201 | 0 Comments   
Filed under
Conditional JOIN's
A co-worker asked me earlier today if there was a way to do a conditional join. Meaning he had two tables and he wanted to join to one or the other within his query, depending on the value of a variable. The two simplest ways to accomplish this are to Read More...
Posted 09 December 04 12:33 by ryanm1201 | 0 Comments   
Filed under
Company Holiday Party(ies)
Ok, let's try this again. I'll try not to lose this post before it makes it to the warm and cozy Home away from Home, otherwise known as SQL Server. So I had two parties to go to in one night. One is for my company, Statera , and the other is for my current Read More...
Posted 08 December 04 07:09 by ryanm1201 | 1 Comments   
Filed under
Posting Frustrations
I spent quite a bit of time writing a post on the recent company holiday parties I attended (I'll rewrite it later). Unfortunately, in the middle of writing that post, I left the computer for a while. Being an experienced web developer, you would think Read More...
Posted 05 December 04 06:48 by ryanm1201 | 0 Comments   
GC.Collect()
Here's a well explained posting on when to use Collect(). Read More...
Posted 02 December 04 01:55 by ryanm1201 | 0 Comments   
Filed under
Fingerprint Reader
I just read this post from Michael Creasy where he talks about his experience with the fingerprint reader device from Microsoft. That may be exactly what I've needed (and didn't know it) to help solve the problem of getting Lauren and Kyla logged into Read More...
Posted 02 December 04 11:30 by ryanm1201 | 0 Comments   
MSN Spaces
So no less than two days after I get this site up and running with .Text, MSN comes out with MSN Spaces . Figures. I'll look into it a bit more, but I like having the customization options. I guess I'll always be a “do-it-yourself” kind of Read More...
Posted 02 December 04 10:59 by ryanm1201 | 0 Comments