don't feed the penguins

2018-04-10T15:42:00.000-05:00

good afternoon Blog https://bit.ly/2Ey9afD

---
El software de antivirus Avast ha analizado este correo electrónico en busca de virus.
https://www.avast.com/antivirus

Hello Blog

2017-02-01T06:27:00.000-05:00

good evening Blog

http://www.missouririverlunch.com/160-600.php?force=23yggp7vcf1p8z

Warmest Regards

I R Returned

2013-01-09T12:39:00.001-05:00

So after many years away from this blog, I decided to revive it again. I’m not sure what I will do with it, but I thought it would be fun to start blogging more again. I can post tiny, ranty, posty things here. =)

maybe… =P

2007-03-30T16:18:00.001-05:00

2007-03-30T08:54:00.000-05:00

Hitachi DB3DL

2007-03-29T12:13:00.000-05:00

I got this a while back when my cordless drill finally gave out. I had seen it a few times but wasn't going to spend the 80 bucks just for a new cordless screwdriver when I already had my cordless drill. However, when my drill gave up the ghost, I knew the time had come! I have to say I have been extremely happy with this product so far. I haven't used it to 'drill' anything, but I'm sure it would handle light drilling with ease. I'm really happy with this product each and every time I use it. So much so, I actually thought I'd post a blog entry about it!

another comic

2007-03-28T21:47:00.001-05:00

i created this with stripgenerator. unfortunately, they are all in flash or something and i couldn't figure out how to save it and look at it as an image quickly. probably isn't that hard, but it's not *really* worth the effort =P

another comic

2007-03-28T21:47:00.000-05:00

web comic enabled =P

2007-03-28T15:30:00.000-05:00

some fun tools out there that enable you creating your own web comics. here's one i created today. =)

new gear

2007-03-27T20:51:00.000-05:00

it finally has come time to upgrade my motorcycle gear. well, upgrade isn't quite the correct word. "replace" would be more accurate. my helmet, jacket, boots, gloves were all falling apart. here are my new things.

helmet

jacket

boots

gloves

i'll post copies of my old beat up and torn ones later. i must say it's a much more comfortable ride now.

all images courtesy of kneedraggers.com.

drop object

2007-02-26T17:16:00.000-05:00

IF (OBJECT_ID('objectname') IS NOT NULL)
 drop proc/table/etc objectname
GO

don't pass csv to stored procs, use xml

2007-02-19T12:18:00.000-05:00

passing csv to a stored proc is bad m'kay. it leaves you open to sql injection attacks and in general isn't the best practice anyway. i'm going to avoid entire code samples just because it's too much typing, but let's take a sample proc and assume you are passing in a varchar(1000) (@csv) comma delimited string. you could do something like this:

declare sql varchar(2000)
set sql = 'select * from table where id in (' + @csv + ')'
sp_executesql @sql

obviously this will work fine if you pass in 1,2,3,4 into your list. but what if some bad person sends you 1,2,3,4,null);select * from users; or something more fun. yep, bad. so what can we do? xml my friend. let's change our input parameter to a type of xml and name it @xml. let's say our xml must be in the format and you can have as many r records as you want. in fact, they can be any kind of record for this following query as long as they have an id attribute.

select * from table t join @xml.nodes('/root/*') x(n) on n.value('@id','int') = t.id

yep, same thing. you can do this a little differently using openxml, but that's old news and you can look that up.

How does MSSQL process my query?

2007-02-19T09:49:00.000-05:00

There are some distinct steps that take place when you submit some tsql to a mssql server. Here's a short overview of them.

1. Parse Query - Check Syntax, Store Query
2. Standardization - Prepare query for optimization
3. Optimize
4. Execution

Let's look at #3 briefly. MSSql does Cost Based optimization which means it will utilize data it knows about the tables involved (statistics) to determine a cost for each possible execution path. It will then pick the lowest cost. MSSql has three steps to it's query optimization.

1. Query Analysis - Identify optimizable clauses (x=1, name='fred')
2. Index Selection - Choose indexes that have a lower cost than a table scan
3. Join Selection - Identify which join order will have the lowest IO cost

There is a lot more information available about this out on the web and in books, but this gives you a rough idea of what happens when you send data to sql.

great sql query blog

2007-02-18T19:56:00.000-05:00

readable regular expressions

2007-02-10T01:26:00.001-05:00

freakin' sweet. that's all i have to say

update statistics undocumented

2007-02-10T00:57:00.000-05:00

these are undocumented for a reason as they will affect performance and you will break your sql production server if you use them! they are *really* helpful for simulations for query plan analysis without having large amounts of data though.

original article here

rock on with this cool code sample from above link:


use tempdb
go

create table t1(i int, j int)
go

create table t2(h int, k int)
go

set statistics profile on
go

select distinct(i) from t1
go

select * from t1, t2 where i = k order by j + k
go

update statistics t1 with rowcount = 10000, pagecount = 10000
update statistics t2 with rowcount = 100000, pagecount = 100000
go

select distinct(i) from t1 option (recompile)
go

select * from t1, t2 where i = k order by j + k option (recompile)
go

find sql proc with text

2007-02-07T07:09:00.000-05:00


SELECT    
      ROUTINE_NAME,
      ROUTINE_DEFINITION
FROM    
      INFORMATION_SCHEMA.ROUTINES
WHERE    
      ROUTINE_DEFINITION LIKE '%whatever you are looking for%'
ORDER BY
      ROUTINE_NAME

source

zipcode sql2005 endpoint sample/example

2007-02-07T01:32:00.000-05:00

i went to look for a super simple way to setup a test of the endpoint feature in sql 2005. i couldn't find one simple enough, so i made this one up.

here's some sql code. just run all of this. there are comments in here for what's going on.


--copy the database file from
--http://www.cfdynamics.com/zipbase/
--and save the txt file in it
--to c:\projects if you want to 
--match my setup

--create the database
create database zipcodes
go

--use it
use zipcodes
go

--create a table
create table zip_codes(
 zip varchar (255)
 , latitude varchar (50)
 , longitude varchar (50)
 , city varchar (50)
 , state varchar (50)
 , county varchar (50)
 , zip_class varchar (50)
)
go

--bulk import our data. modify the path to match yours
DECLARE @bulk_cmd varchar(1000)
SET @bulk_cmd ='bulk insert zip_codes
FROM ''c:\projects\zip_codes.txt'' 
WITH (FIELDTERMINATOR ='','',
ROWTERMINATOR = '''+CHAR(10)+''')'
EXEC(@bulk_cmd)

--remove the quotes we imported
update zip_codes set
 zip = replace(zip,'"','')
 , latitude = replace(latitude,'"','')
 , longitude = replace(longitude,'"','')
 , city = replace(city,'"','')
 , state = replace(state,'"','')
 , county = replace(county,'"','')
 , zip_class = replace(zip_class,'"','')

go

--modify the data types a little
alter table zip_codes alter column zip varchar (5)
alter table zip_codes alter column latitude float
alter table zip_codes alter column longitude float
alter table zip_codes alter column state varchar (2)
go

--create our proc to share
create proc dbo.zipcodes
 @zip varchar (5) = null
 , @latitude float = null
 , @longitude float = null
 , @city varchar (50) = null
 , @state varchar (2) = null
 , @county varchar (50) = null
 , @zip_class varchar (50) = null
as

--no locking
set transaction isolation level read uncommitted

--stupid code to fix empty values
select
 @zip
  =case when @zip = ''
  then null else @zip end 
 , @latitude
  =case when @latitude = 0
  then null else @latitude end 
 , @longitude
  =case when @longitude = 0
  then null else @longitude end 
 , @city
  =case when @city = ''
  then null else @city end 
 , @state
  =case when @state = ''
  then null else @state end 
 , @county
  =case when @county = ''
  then null else @county end 
 , @zip_class
  =case when @zip_class = ''
  then null else @zip_class end 

--get our values
select
 zip
 , latitude
 , longitude
 , city
 , state
 , county
 , zip_class
from
 zip_codes
where
 zip    like coalesce(@zip,zip)
 and latitude = coalesce(@latitude,latitude)
 and longitude = coalesce(@longitude,longitude)
 and city  like coalesce(@city,city)
 and state  like coalesce(@state,state)
 and county  like coalesce(@county,county)
 and zip_class like coalesce(@zip_class,zip_class)

go

--create an endpoint to share proc
CREATE ENDPOINT zipcodes
STATE = STARTED
AS HTTP (
    AUTHENTICATION = ( INTEGRATED ),
 SITE = '+',
    PATH = '/zipcodes',
    PORTS = ( CLEAR )
)
FOR SOAP (
  WEBMETHOD 
    'http://localhost/zipcodes'
    (NAME = 'zipcodes.dbo.zipcodes'),
    BATCHES = ENABLED,
    WSDL = DEFAULT
  ) 
go

and here is the code for a simple c# command line application to consume this service. you'll need a web reference to the localhost wsdl. you can name it something else, but i just left it as localhost. you will also need to reference system.web.services. you can make tons of modifications to this default to add functionality, but this should get you started.


using System;
using System.Data;
using System.Net;

namespace zipcodes
{
    class Program
    {
        static void Main(string[] args)
        {
          
            string zip = string.Empty;
            string city = string.Empty;
            string state = string.Empty;
            string county = string.Empty;
            string zip_class = string.Empty;
            double latitude = 0;
            double longitude = 0;
            bool showhelp = true;
            
            foreach (string a in args)
            {
                if (a.Contains("zip=")) zip = a.Remove(0, 4);
                if (a.Contains("city=")) city = a.Remove(0, 5);
                if (a.Contains("state=")) state = a.Remove(0, 6);
                if (a.Contains("county=")) county = a.Remove(0, 7);
                if (a.Contains("zip_class=")) zip_class = a.Remove(0, 10);
                if (a.Contains("latitude=")) latitude = Double.Parse(a.Remove(0, 9));
                if (a.Contains("longitude=")) longitude = Double.Parse(a.Remove(0, 10));
                if (a.Equals("nohelp=true")) showhelp = false;
            }

            if (showhelp)
               Console.WriteLine(
                 String.Format("{0}\n{1}\n{2}\n{3}\n\n{4}\n{5}\n{4}"
                    , "royashbrook.com =) sample syntax:"
                    , "zipcodes longitude=-103.847648"
                    , "spaces and wildcards --> zipcodes city=jacksonville \"zip_class=po box %\""
                    , "wildcard support --> zipcodes county=morr% zip=%5%"
                    , "*************************************"
                    , "USE nohelp=true to omit this message!"));
            
            using (localhost.zipcodes z = new localhost.zipcodes())
            {
                z.Credentials = CredentialCache.DefaultCredentials;
                foreach (DataRow dr in (
                    (DataSet)z.httplocalhostzipcodes(
                        zip, latitude, longitude, city, state, county, zip_class
                            )[1]).Tables[0].Rows)
                    Console.WriteLine(
                        String.Format("{0},{1},{2},{3},{4},{5},{6}",
                            dr[0],dr[1],dr[2],dr[3],dr[4],dr[5],dr[6]));
            }
        }
        
    }
        
}

enjoy!!!

what doesn't happen?

2007-01-22T20:54:00.000-05:00

getting hit on your motorcycle? well... that happens sometimes. how about someone running into you at a stop light? i guess that happens sometimes too. how often do you hear about people on motorcycles being run into from behind though?

oh... i see... you are one of THOSE people. you *know* people that have problems, huh?

well, how often does it happen and there isn't any damage to the bike? eh? ha! never! gotcha. well, it happened to me today. the most bizarre thing ever. i saw the lady coming and she was stopping, but not fast enough. fortunately, i pulled up some, but apparently not quite enough. she just bumped my back tire though. thanks to being paranoid about people hitting me.

just a lesson to any of you out there that don't ride much or don't pay attention to the other drivers. YOU MUST WATCH THEM! People *will* kill you. Remember, the stupid people *far* outnumber the smart people, and many of them have cars! =P

i would rant about it, but the lady that hit me seemd really concerned about my safety, and she kind of reminded me of my step mom. my step mom *hates* driving really. she only does it if she has to. so, whatever. no harm, no foul.

God was definitely looking out for me, but he apparently wants to make sure i'm paying attention because if i hadn't of pulled up some myself, i'd probably be really, really hurt right now. =P

=D

daily stuff....

2007-01-22T09:00:00.000-05:00

53 css techniques you couldn't live without

cool railsish site. addictedtonew

microformats are cool

microformat related blog post

cssplay this site is always awesome and i'm gonna link it just because of the sheer amount of times i've had it open when i was posting something. =P

asteriskNOW!

2007-01-16T14:35:00.000-05:00

2007-01-08T00:24:00.000-05:00

Check out this really incredible article on using .net and atlas to create a page just like the Google IG custom home page. You can see the results and at this completely usable page, here!

Check out BitTyrant . It's supposed to be 70% faster than your typical torrent clients. You can read the page for why that is.

Here is a cool article from Techcrunch. Good old Mike lists his favorite web 2.0 apps. Web apps that I use daily are google (mail, calendar, chat), flickr, digg, and youtube. I use skype as well, but i don't know that i would categorize skype as a web 2.0 company like Mike does.

Other apps that I use daily would include Outlook, VS.Net 2005, RadRails, SVN and Firefox.

blogger v 2

2007-01-02T16:07:00.000-05:00

ok, so i'm all migrated to google v2. pretty nice. the tumblog has been on there for a while. is that even the right way to spell that? whatever. i like the new blogger. i still want to switch to self hosted and that may be coming this year. i'm sure my "vast" audience is concerned =P

svn weee

2006-12-31T18:40:00.000-05:00

so i finally got around to moving all of my data into svn. it's at http://svn.devjavu.com/royashbrook/.

it's been on my list of things to do for.... oh forever to get my 'code' stuff into an svn somewhere. i probably need to thin it out since there is probably stuff out there that i really don't care to have out there. it's private for now, but i plan on making a public portion of it soon as i reorganize the code.

i have to give serious props to devjavu for the incredible service they provide. i'm storing multiple projects on there currently and it's working great. i didn't have any problems running into limits or anything and i'm storing just over 1.5GB in my code folder right now.

i'll be pruning this down at some point and migrating all of the archive data to my s3 account which is also pretty slick.

fin

2006-12-30T14:59:00.000-05:00