Information Technology « peshvar.com

Generic list of Business Categories and Subcategories

By peshvari, on August 13th, 2009%

This usually comes handy for Web Developers. these two CSV file contains Business Categories and Subcategories

Business Categories and Subcategories
Business Categories . . . → Read More: Generic list of Business Categories and Subcategories

Who should add/modify DNS PTR Record?

By peshvari, on August 10th, 2009%

that would be your ISP or the hosting facility.

A PTR record (sometimes called a “host PTR record”) is what lets someone do a “reverse” DNS lookup – that is, they have your IP address and want to know what your . . . → Read More: Who should add/modify DNS PTR Record?

IPHONE headphone

By peshvari, on July 20th, 2009%

it has been awhile since my last post… I have been very busy lately.

I have tried to search for this but didn’t find anything… my iphone keeps changing to Headphone mode when no headphone is plugged in.

I called Apple support and they told me to do a software upgrade which I did, but no luck. then . . . → Read More: IPHONE headphone

Linux VS Windows (2)

By peshvari, on April 14th, 2009%

I finally managed to install Ubuntu, well I actually installed Kubuntu . Kubuntu uses KDE environment instead of GNOME.

Very easy to use, user friendly, great operating system.You can keep your NTFS paritions or hard drives and you can view and browse within Kubuntu. Sharing file, pic, music and etc worked like a charm.

Once you install Kubuntu, . . . → Read More: Linux VS Windows (2)

MS SQL reindexing Database

By peshvari, on March 31st, 2009%

You guys might be already know this:

Script to automatically reindex all tables in a database. Please note that this might take up to 12 hours. I run this on my database and took 4 hours. the database size was 21 G. You also need (size of your db * 2) free space to run this…

USE Databasename

DECLARE . . . → Read More: MS SQL reindexing Database

SQL breakdown TIME

By peshvari, on March 19th, 2009%

This statement will count number of records in a given month and breakdown it every 30 minutes.

select count(ID) as ID_Count, Date_30min from
( select ID, convert(datetime,convert(varchar(14),calldatetimefield,120) + case when datepart(minute,calldatetimefield) < 30 then '00' else '30' end) as date_30min from tablename where calldatetimefield between '2009-02-01 00:00:00.000' and '2009-02-28 23:59:59.997' and ......) . . . → Read More: SQL breakdown TIME

SQL updating field with current timestamp

By peshvari, on March 10th, 2009%

MS SQL to update a field to current time:

update tbl1 set col1 = convert(varchar(5),getdate() ,108)

result:

col1 . . . → Read More: SQL updating field with current timestamp

Linux VS Windows

By peshvari, on March 5th, 2009%

The first OS that I used was DOS… I guess it was version 6.2 if I recall correctly…

then Widows 3.1, way easier than typing command and things like that… well, then Windows 95, 98, 2000 etc… so I kind of grew up with Windows… Not that I don’t link Linux but I never had the chance . . . → Read More: Linux VS Windows

EBAY

By peshvari, on March 5th, 2009%

I love ebay… If you want to have fun online, ebay is the place to go.

I have so far sold about 10 to 15 different items on ebay, made about 500$ from things that I didn’t need anymore. Trust me, people will buy it. Try it, you wont . . . → Read More: EBAY

Sponsors