Ycsoftware.net

Whois lookup standalone tools

If you are tired of searching through 3 millions sites to get some basic whois information

, maybe you want to just download a tool and do it on your local computer.

Advantage
1. Faster
2. No more searching
2. No Ads
3. Ability to save the information to text files

These Tools are :

http://www.gena01.com/win32whois/download.shtml

http://www.barisione.org/files/WinWhoisSetup.exe

Note:
Note that YCSoftware is not affiliated with the makers of these tools. They just happen to have a good tool that deserve some press. Check them out and post your comments.

DNS Tools For Windows

I remember back in the days (2005) when I used to use a very popular website to query DNS information.

The information was very easy to find and queries were very fast.

However, it was a matter of time before they got greedy and wanted to charge for simple DNS queries.

I found this windows tools and it works for me whenever i want to get basic DNS information and hopefully it will do the same for you.

http://www.nirsoft.net/utils/dns_records_viewer.html

Note that YCSoftware is not affiliated with the makers of these tools. They just happen to have a good tool that deserve some press. check them out and post your comments.

How To Move A (Microsoft) Window With just Keyboard Commands

Here are the commands:

1. Hold Down the ALT key + Spacebar key

2. While Holding the above keys Down, Press the letter "M" 

3. Then release all Keys

4. Now user the Arrow keys to move the pop up window.

Add and Subtract Hours to T-SQL Datetime

Add to 1 hour to the Current Date

 DATEADD(hh,1,getdate())

Subtract 1 hour to the Current Date

 DATEADD(hh,-1,getdate())

Add 1 hour to the Current Time and returns just the time part

select Convert(varchar,( DATEADD(hh,-1,getdate())),8)

Reference
http://msdn.microsoft.com/en-us/library/ms186819.aspx

Saving Changes is not Permitted

Saving changes is not permitted. The changes that you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.

There is nothing to say, this website below does a great job at explaining how to fix this issue.
http://www.sql-server-performance.com/faq/saving_changes_not_permitted_p1.aspx

The most common operation I usually do is to change a Column Size in Real time.

ALTER TABLE NAMEOFTABLE  ALTER COLUMN ycsoftware varchar(1000);

For more information about altering table with Command Lines visit the following Microsoft Article:
http://msdn.microsoft.com/en-us/library/ms190273.aspx