Browsing Posts published by admin

I had a problem, I had to work in 2 different networks but with only one default gateway i was not able to talk to both networks. So if you open up a command prmp(cmd) but open it by right clicking and then clicking open as admin. Once your at the command prompt type this but change my network numbers to the ones you want to get to. “route add 10.128.0.0 mask 255.255.0.0 10.100.1.91″
and boom without haveing to configure anything on my default gateway now i can access both networks from my one machine. Thanks and let me know if you have anty questions.

Okay I used this SQL Script to join two tables but a certain amount of rows has to be joined with another table, here is how i did it with a join and union operation

UPDATE tbl_grocery_inventory set col_curry_qty = col_curry_qty – 1
WHERE col_ID in (select col_id
from tbl_fruit
where col_id=2)

In Solaris the command line has to be used all the time. One task that you will run into either through Solaris, Linux, OSX, or even the iphone OS is the moving of files. here is the command and you can use it at will.

Move all files in directory to test directory: mv * /test

Move one file only: mv onefilename /test

Let me know what you think and if you have any tips yourself!

Thanks

Scott @ http://scottalvarino.com

This is a SQL SELECT Statement that is joining 3 tables. Please tell me what do you think to make it quicker and faster.  Let me know what you think about this confusing subject of SQL joins!

Thanks

Scott @  http://scottalvarino.com

continue reading…

Sybase Ase 12.5 Video To find Out Address and Ports

This is for A Unix Solaris Box, I never had access to its Sybase before and needed to find out how to remotely connect with it to use different tools to write reports and administer the system. this is much like in the Microsoft SQL DB world where you have SQL Query Analyser and Enterprise Manager For the Windows Side of things.

Will have up soon, please let me know if this of any interest?

Scott

Check out the latest article from apple insider to read the details about this.

Click HERE!!

What browser is most secure?

1 comment

I just wanna give my two cents about what browser I feel is the best to use while surfing the net. The one I have been using is Opera Version 10.10

I also use Firefox whenever a site is not compatible with Opera http://www.opera.com. Let me know what you think with a comment. Also let me know if you want me to test each browser with a couple test to see which one is the most secure. Let me know

SA

Hi everyone, I have been tasked with converting the data that is in a log file from Hexadecimal to a regular number value or decimal value. I was stuck because the user didn’t even know what columns were the ones that I was supposed to extract the data from. Well when I finally figured what columns to convert, I found out what program would be the easiest for me. Can you gues what tool I used? Well I will give you one hint, mostly all office workers use this. Well I will be posting the video soon on how!! Let me know what you think with a Comment.

Thanks

SA

Check out my latest project!

5 comments

The Official Gamers Network

Is the latest project I have been working on. These are just a couple of the things that can be done with my favorite blogging software Wordpress!. Anyways I been super busy at work and have been trying to finish all my tasks, But I have alot of video that just needs to be uploaded and I am still working on My Cisco Command Cheat Sheet for all you Network Junkies.

Bye For now