Tuesday, June 30, 2009
How to find duplicated fields and delete them from database? (t-SQL)
Here is the magic :
DELETE T1
FROM CustomerTable T1, CustomerTable T2
WHERE T1.DuplicateField = T2.DuplicatedField
AND T1.UniqueField> T2.UniqueField
This will basically delete all records from the table CustomerTable which have the same value for the field DuplicateField, leaving that record which has the lowest value in UniqueField.
How does DNS service work?
When you type www.google.com your computer asks your DNS server what the IP address is for www.google.com. And your DNS server sends the ip address like this 64.233.169.103. In most cases you may just put the IP address of the website you want to see in your browser's address bar.
Why would you want to use the IP address instead of URL?
This might seam useless but if you are having problems with your internet connections even though your router says it is connected, you might want to try the IP address of the website you are trying to reach. This will show if you really have an internet connection or not.
Saturday, June 27, 2009
Unlimited Web Hosting Product
Dear Customer,
After the launch of our Free Managed DNS Service and our competitively priced Email Hosting Product, our Web Hosting Product is now all set for a revamp.
In a bid to enhance our offering even further, we are now introducing our brand new Unlimited Web Hosting Product at a flat rate of $3.99 on every Domain hosted! Our newest offering comes your way on the 1st of July '09 with a dynamic set of unlimited features that will do away with any scalability issues your Customers may have. Further details are as follows:
New Web Hosting Product Specifications
- Unlimited Bandwidth
- Unlimited Disk Space
- Unlimited Databases
- Unlimited DLLs
- Unlimited Email Accounts
- Capture a greater market share by increasing your volumes.
- A Web Hosting + Email Hosting package with unlimited parameters is now available for a flat rate.
- Scalability will now never be an issue for your company.
Keep a tab on our future mailers for more information on this 'Ultimate Hosting Package'!
Best Regards,
Audrey Xavier
Chief Marketing & Communications Officer
Cadianda.net
Blog.Cadianda.net
Friday, June 12, 2009
Third Level .UK for just $6.59
Visit www.cadianda.net to register your UK domains.
Note:
- This Promo is applicable to all ten years of Registration.
- Renewals & Transfer-Ins will not attract this Promo Pricing.
- There are no restrictions on the number of Domains that can be registered during this period.
- Though the Promo Pricing for Third Level .UK Domains mentioned above is on an annual basis, these can only be registered in multiples of 2 years as mandated by the Registry.