Posts

Showing posts from 2007

a Sports Coupe Toyota Celica GTS 2001

Image
I want to write a small review on my new celica gts 2001.There are few things that I am impressed with the car but there are a few that annoys a little bit.

Handling:
I read so many reviews on the web the car really handles well on the curves but I couldn't get the feeling when I make the turns in the car.This is maybe because I had driven stable cars like accord,civic,dodge neon,nissan sentra.

HorsePower:
As many people mentioned in their reviews, car needs a little more horse power for it to fly.A V6 engine would have been a good idea too.

Gas Mileage:
I always keep the rpm low when I drive the car, I get 30-32mpg with a mix of city and freeway.When compared with other cars in its class this is a nice car with a decent mileage.Ofcourse it takes premium grade gas.

Interior:
I waited little longer to find a car that is fully loaded,interior leather is very nice but the cheap plastic thrown in the dash makes it look cheaper.

View:
I used to park really well with my other cars, celica parking…

Tiny peice of SQL - To find if a sql server guid is a hex

I know guid is a hex, but for very little fun I wrote the following sql to find it out.I got some of the code from Books On Line.Just want to throw it out there to see if something in it helps.
Begin

Declare @Iteration int;
Declare @isHex bit;
Set @Iteration = 1;

WHILE (@Iteration < 100000)
Begin
SET TEXTSIZE 0;
DECLARE @position int;
DECLARE @string char(8);
SET @position = 1;
SET @string = REPLACE(Cast( newid() as varchar(36)),'-','A')
WHILE @position <= DATALENGTH(@string)
BEGIN
Set @isHex =
Case when ASCII(SUBSTRING(@string, @position, 1))> 70 then 0
else 1
End
SET @position = @position + 1;
END
Set @Iteration = @Iteration + 1;
End

If @isHex = 0
Print 'Guid is not a hex';
Else
Print 'Guid is a hex';

End
Go

Internet wireless gateway with Fedora Linux ,Chillispot,FreeRadius and Apache

Image
One of the projects I want to do is to create a wireless hot Spot and control the usage of it(bandwidth,sites users visit, place ad's(for not-for-Profit orgs)). With my limited knowledge of networking I couldn't do it in windows,so I chose Linux as my platform.

After spending more than 100 hours of my time,I finally made my wireless router to work.You should have seen the happiness in my face after the first client machine saw the ad and successfully logged into the wireless network,but there was a little disappointment because I didn't write the code for freeradius ,Apache, chillispot or Fedora Linux. But that's OK for now!

Ubuntu 6 blew my monitor,monitor got stretched horizontally I thought there was something wrong with the Linux video driver,but see the same after formatting and installing windows on the machine.Fortunately I had an extra monitor with which I continued my work.Ububtu didn't detect my second network interface card,so had to move with another flav…

Over clocking of AMD 64 2800 CPU

As I mentioned before I had this opportunity to assemble a new system for basic word processing and emails,I went with AMD 64 2800 CPU with MB BIOSTAR K8M800-M7A K8M800 754 motherboard.

Biostar motherboard came with a nice overclocking utility, that did the overclocking of the cpu.

Following are the details of the overclocked CPU.

------------ Normal ----------OverClocking
CPU Freq-- 1.6Ghz ---------- 1865Mhz
Clock Freq-- 200Mhz -------- 221Mhz
Ram Freq-- 188Mhz --------- 203Mhz

after overclocking, the system was very stable.

----------------------------

Hardware Used:

Mother Board
MB BIOSTAR K8M800-M7A K8M800 754

Processor
CPU AMDSEM64 2800+ 1.6G 754 256K %

Ram
1 GB Module for Dell OptiPlex GX270 Small Form Factor System PC 2700 184 pin DDR.
----------------------------

Hope this information will help if you want to buy any of the above products.

Atx Power Supply for a Micro Atx MotherBoard

After long time , I had the oppurtunity to assemble a basic system for emails and word processing.I have never ordered a microAtx motherboard for a Atx Power Supply, but by mistake I did it this time.

I was thinking that there is only a phsical difference(dimensions) between a microAtx and Atx power supply, I didn't realize my assumption was wrong until I connected all my compenents and nothing worked.

There were no beeps nor the processor fan is working(no display) when I turned the computer on, but the power light turned on.

I ordered a new microAtx PS and everything worked fine except my microAtx PS didn't fit into the Atx Case.I had to search for the burried toolkit to make the PS fit into the case.

what a mess , for ordering one wrong component.

which search engine is the best; google or msn or yahoo . . .

I started my blog on Tuesday, February 27, 2007, Google crawler was able to look at the blog and grab the content of it by the 22nd of March ,2007,but other search engines couldn't do it.

There are many other factors involved in judging a search engine .The first one is definitely the content that comes after the search. Other search engines seem far behind(at least for me) Google in maintaining their search databases.

The other reason why Google picked my blog is may be because it owns blog spot.

Anyways, I prefer Google over other search engines.

ubuntu . . . you have to try

Image
Linux operating systems usability has been changed a lot since I started using them in late nineties. It was a pain to even install Linux on a machine, forget using them for daily purposes. Thanks to many flavors of Linux for creating a easy partition tool for installing Linux.

After hearing the entire buzz about Ubuntu Linux, I want to try it and feel the operating system (Linux) for human beings.

Some of the following features I like the best in ubuntu is its vnc support, multi language support, ability to Remote Desktop to a windows machine, IPV6 support,open office2.0 and Keyboard shortcuts.

I wish I could write a lot about the features of ubuntu. As "A Picture's Worth a Thousand Words" I am going with pictures instead of words.

1.Keyboard Shorcut assigning screen

2. Context menu of a opened item in task bar.


3. Add Remove Applications


4.Synaptic package Manger


5. Accessories


6.Remote Desktop Connection Dialog


7. Remote Desktop Preferences


8.Sound & Video



9. Office (Open Off…

RoboCopy to manage files SQL server

Sometimes you would have to manage files using t-sql jobs/packages in sql server, then xp_cmdshell with robocopy can serve the purpose.

I like xp_cmdshell a lot as it can be used to execute various dos Command Line Commands.
Grant Permissions carefully to the users who can run xp_cmdshell as it has the power to get the system details,network details and much more.

Robocopy, or "Robust File Copy" is a tool from Microsoft and is available for licensed windows users in the resource kit(also included in windows vista by default).

One very nice cool feature of this tool is its ability to copy the permissions on the folder(/copyall).

For more info on the parameters of robocopy
http://www.ss64.com/nt/robocopy.html

Lets jump into the sql ..

DECLARE @SrcFolder varchar(300)
DECLARE @DesFolder varchar(300)
DECLARE @Cmd varchar(1000)

-----------------------------------------------------------
SELECT @SrcFolder = 'C:\tst'
SELECT @DesFolder = 'C:\tst1'
SELECT @Cmd = 'robocopy ' …

Why Blogging?

I am really amazed at the time people spend on sharing their experiences and knowledge with everyone all over the world.

Thanks everyone.. !

I also would like to do the same for everyone and is taking the first step to my contribution by creating this blog.

Some Cool Pics from Chicago

Image
With my little photographic skills, I couldn't capture all the beauty of Chicago. But tried to get some of it though . . !











Generic Stored Procedure for Updating different Datatype Columns

Generic Stored Procedure to Update Columns of different datatypes.

userPreferences Table

UserName(varchar) ShowBorder (bit) RecentLinks(int) UserLocation
A 1 4 US
B 0 5 IN

CREATE PROCEDURE [dbo].[UpdateUserPreferences]
@UserPreferenceName Varchar(50),
@UserPreferenceType Varchar(50),
@UserPreferenceValue Varchar(50)
AS
Declare @UpdateSql Varchar(500)

SET @UpdateSql = 'update [tblUserPreferences] Set '+ @UserPreferenceName + ' = Cast('

If (@UserPreferenceType = 'Char' or @UserPreferenceType = 'Varchar')
SET @UpdateSql = @UpdateSql+ '''' + @UserPreferenceValue + '''' + ' As ' + @UserPreferenceType + '(50)) where userName = SYSTEM_USER'
ELSE
SET @UpdateSql = @UpdateSql + @UserPreferenceValue + ' As ' + @UserPreferenceType + ') where userName = SYSTEM_USER'
EXEC (@UpdateSql)

Usage:

EXEC UpdateUserPreferences ‘ShowBorder’,’bit’,’0’

EXEC UpdateUserPreferences ‘UserLocation’,’Varchar’,’AUS’

This is not the optimal so…

freeware open source

Support Small amd open Source Solutions. Appreciate the work and share your work.

These are some of the freewares that I use almost everyday in my life.

Remote Connection
1.Real VNC -
2.CrossLoop
3.Himachi
4.Remote Desktop Connection

Spyware Tools
1.LavasoftAdware
2.Spybot Search & Destroy
3.Windows Defender
4. Spyware Terminator
5. SUPERAntiSpyware
6.Hijack This

Document Viewers
1.Adobe reader 8.0
2.FoxiT Reader

Hot Key Managers
1.HotKeyz

Broken Link Testers
1.Xenu's Link Sleuth -

File Copy Tools
1.RoboCopy - Windows 2003 ResourceKit
2.Syn Toy From Microsoft

Video Players
1.VideoLan (nice stream ing software)
2.Divx Player
3.Al Show Player( Nice Codecs , Some other awesome tools - http://www.altools.net/ALTools/ALShow/tabid/57/Default.aspx)
4.Real Player
5.Winamp


Zip Tools
1. ZipGenius
2.7zip (with Command line - very flexible )
3.WinRar
4. IZArc


Password Management

AxsoftRoboForm (very nice integration with internet explorer, 10 passwords for a free version, just 25$ to avoid that)

Renaming Tools
Lupas Rename – …

Information Usage Policy

Any code or information in here is provided as-is with no warranty of any sort. Please do not use any of the code in your production environment.

Blog Dedicated To

This blog is dedicated to Service Men and Women who protects every one day and night and for all the physically and mentally challenged.

Free software help for Not-For-Profit Orgs

Non Profit Organizations

If you are a "not-for-profit organization" and need some small software applications in VB,VB.net,Access,HTML,ASP,ASP.Net,C#,C,C++,T-SQL,SSAS,SSIS,SSRS,Tableau,Hadoop,PostGres,MVC,Angular feel free to contact me.

Product Reviews

Product Reviews

Here I would like to post about the products I have used in the post.

Sony N80

Motorola V7 phone

Dell inspiron 600m

Dell Precision M60

Dell Latitude 600

Dell Optiplex gx270

Microsoft FingerReader wireless keyboard and Mouse.

Dlink 614+ wireless router

Links Bfw154 ver4 wireless router

Sanyo 29" Flat Screen Tv

Hp 2035 LCD Monitor

Compaq Presario

Dell xps 1200

Windows 2000

Windows 2003

Windows Xp

SQL Server 2000

SQL Server 2005

and many more

My Favorite Sites

FQL insted of SQL

Teens are going to know FQL instead of sql. see why at facebook
http://developers.facebook.com/documentation.php?v=1.0&doc=fql
I am amazed at the work done by Microsoft.Follow the link to feel it.
http://labs.live.com/photosynth/