ASPHostCentral.com ASP.NET and Windows Hosting BLOG

All about ASP.NET 4.5 Hosting, ASP.NET 4 Hosting, ASP.NET MVC 4.0 Hosting, Sharepoint 2013 Hosting, and all Windows 2012 Hosting articles

Why is an email categorized as SPAM and what should we do to :: ASP.Net Hosting

clock October 17, 2013 20:53 by author Herry

Electronic Spamming is the use of  email systems to send unsolicited bulk messages (spam), especially advertising, indiscriminately.

Why is an email categorized as SPAM ?, the reason is 

1.       Your email server contains a virus and has been sending out spam. 

2.       Your email server may be improperly configured. 

3.       Your PC may be infected with a virus or botnet software program.

4.       Someone in your organization may have an infected PC with a virus or botnet program.

5.       Your marketing department may be sending out bulk emails that do not comply with the CAN-SPAM Act.

6.       You may have an insecure wireless network which is allowing unknown users to use your network to send spam

7.       Your IP was Blacklisted

 

How to fix it ?

Be sure that your emails don’t look like typical spam emails: don’t insert only a large image; check that the character-set is set correctly; don’t insert “IP-address only” links. Write your communication as you would write a normal email. Make it really easy to unsubscribe or opt-out. Otherwise, your users will unsubscribe by pressing the “spam” button, and that will affect your reputation.

On the technical side: if you can choose your SMTP server, be sure it is a “clean” SMTP server. IP addresses of spamming SMTP servers are often blacklisted by other providers. If you don’t know your SMTP servers in advance, it’s a good practice to provide configuration options in your application for controlling batch sizes and delay between batches. Some mail servers don’t accept large sending batches or continuous activity.

Use email authentication methods, such as  SPF and  Domain Key to prove that your emails and your domain name belong together. The nice side-effect is you help in preventing that your email domain is spoofed. Also check your reverse DNS to make sure the IP address of your mail server points to the domain name that you use for sending mail.

Make sure that the reply-to address of your emails are a valid, existing addresses. Use the full, real name of the addressee in the To field, not just the email-address

 



SmarterMail v10 :: Hosting with ASPHostCentral.com

clock October 17, 2013 19:57 by author Herry

SmarterMail gives email administrators and users and more power and control than ever before with the most flexible email server currently available.
SmarterMail is built and priced to be both beneficial and accessible to individuals, small businesses, and enterprise-level organizations alike, and is able to support anywhere from one to an unlimited number of domains and an unlimited number of email addresses. In addition to providing end users with advanced features like mail account statistics and precise user-controlled spam and content filtering, end users with administrator permissions for the domain have the ability to set and retrieve domain level statistics, provide domain-level spam and content filtering (versus having individual end users set their own), administer spam using any number of different spam and black lists (e.g. SpamCop, ORDB, and others), set domain-level aliases, implement SMTP authentication, and much more.


As an added benefit, SmarterMail is accessible from a standard web browser, giving administrators and end users email capabilities anytime, from anywhere. SmarterMail uses industry standard mail protocols, like POP3 and IMAP4 for incoming mail and SMTP for outgoing mail, and is compatible with the most popular desktop email clients (e.g. Microsoft's Outlook and Outlook Express or Qualcomm's Eudora).
A New Version and a few of Update and fixed from smarter mail v.10

FIXED: Fixed an issue which could cause a mailbox to be in memory multiple times. This could happen when using IMAP.

FIXED: SMTP will no longer return a Data Transfer Failed status when "Mail From" address is blank.

CHANGED: IP Addresses that are whitelisted will no longer be added to email harvesting blocks.

FIXED: An issue with IMAP processing where multiple consecutive spaces in a command would be replaced with a single space which would prevent folders named with multiple consecutive spaces from getting selected properly.

FIXED: An uncommon issue with the spool stalling with certain formats of email address.

FIXED: Mobile interface will not error on apostrophes when sending.

ADDED: Implemented the UIDPlus extension for IMAP.

ADDED: Spam check results for outgoing SMTP spam checks are now logged in the delivery log.

FIXED: An issue where the IMAP Append command was not handled properly which would cause it to randomly fail.

FIXED: Creating appointments using Exchange ActiveSync now saves correctly.

FIXED: Domain archiving now properly archives messages sent from a remote address to one of the domains aliases that contains only remote addresses.

FIXED: Messages with null characters will no longer stall Exchange ActiveSync.

FIXED: SmarterMail no longer modifies message parts of text/calendar when sending through a mailing list or attaching footer text.

 

Hosting your Smartermail V10 with aspHostCentral.com



SQL Hosting:: Restore database using Script

clock September 25, 2013 21:23 by author Herry

If you intend to create a back up of your database in Server A and restore it on a Server B, here's how to go about it. Create a .bak file (Open SSMS > Database > Right Click your database > Tasks > BackUp > Specify the destination). this step took a lot of time.

There are another step using script to restore database more easy. 

we assume that the .bak is created,  copy this file from Server A to a Server B. We will assume that the file has been copied at the location ''D:\HerryDB "  at Server B.  It can any location that you desire.

Ok this is the script

RESTORE DATABASE  yourDB

FROM DISK = 'D:\HerryDB\yourDB.BAK'

WITH REPLACE,

MOVE 'yourDB' TO 'C:\Data\yourDB.MDF',

MOVE 'yourDB_log' TO 'C:\Data\yourDB _log.LDF'

 

Notes:
yourDB= Your database name
‘yourDB’ and ‘yourDB_log’  is the name of  . MDF  and. LDF  file,  so you must ensure that the names is the same as files in C: \Data directory , to ensure it,  check  C:\Data and note the name of .MDF and .LDF file before you execute the script.

 



SQL Hosting:: Script Backup All database in MS SQL and MySQL

clock September 25, 2013 17:57 by author Herry

Sometimes things that seem complicated are much easier then you think and this is the power of using T-SQL to take care of repetitive tasks.  One of these tasks may be the need to backup all databases on your server.   This is not a big deal if you have a handful of databases, but I have seen several servers where there are 100+ databases on the same instance of SQL Server.  You could use SQL Server Management Studio to backup the databases or even use Maintenance Plans, but using T-SQL is a much simpler and faster approach.

This script is a script  that you can use  to backup All your databases in the  server without any right click > backup anymore. Make your backup more  simple and faster

Bay the way You need to change the @path to the appropriate backup directory.

 

DECLARE @name VARCHAR(50) -- database name 

DECLARE @path VARCHAR(256) -- path for backup files 

DECLARE @fileName VARCHAR(256) -- filename for backup 

DECLARE @fileDate VARCHAR(20) -- used for file name

 

-- specify database backup directory

SET @path = 'C:\Backup\' 

 

-- specify filename format

SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112)

DECLARE db_cursor CURSOR FOR 

SELECT name

FROM master.dbo.sysdatabases

WHERE name NOT IN ('master','model','msdb','tempdb')  -- exclude these databases

OPEN db_cursor  

FETCH NEXT FROM db_cursor INTO @name    

WHILE @@FETCH_STATUS = 0  

BEGIN  

       SET @fileName = @path + @name + '_' + @fileDate + '.BAK' 

       BACKUP DATABASE @name TO DISK = @fileName 

       FETCH NEXT FROM db_cursor INTO @name  

END  

CLOSE db_cursor  

DEALLOCATE db_cursor

 

now how about backup database from Mysql, fortunately  the only script to backup all database in Mysql in below this

mysqldump --all-databases > all_databases.sql

all_databases.sql is the name for .sql file database, so you can change it to whatever you want

 

 

 



SQL Hosting:: Fulltext indexing

clock September 11, 2013 14:49 by author Herry

What is fulltext indexing ?

The Simple word to describe what is full text indexing is creating an "index" for each "word" in the specified column. This indexing technique are very useful when you make a search in a huge database with a lot of table, with fulltext indexing you can search two words near each other, multiple words with distinct weightings and A word or phrase close to the search word or phrase.

How to Enable fulltext indexing ?
First of all start SQL server and select the database, after that right-click on the table, example Company table, after that select  Full-Text index -> Define Full-Text Index..

Now click Next
This form will show up

Now click Next and select  columns from the company  table to create full text search index


Now click on the Next Button and the automatically the default is correct.


Now click on the next button and give the name of the catalog


Now click on next button


Press Next button again and this wizard will finish  after click finish button


Now click the close button and you will see the catalog after expanding full-text catalogs.


Now right click on the company table and select Full-text index to start full population


Searching Using a Full-Text Index 

Now you're ready to actually do some searches. Four T-SQL predicates are involved in full-text searching:

FREETEXT: This finds the word or words you give it anywhere in the search column.

FREETEXTTABLE: This works like freetext except that it returns its results in a Table object.

CONTAINS: You can search for one word "near" another this way.

CONTAINSTABLE: This works like contains except that it returns its results in a Table object.

Example

I added a full-text index to the Title column in the News table and using the FreeText Predicate:

SELECT * FROM Company WHERE Adress1  LIKE '%Statements%'

SELECT * FROM Company WHERE FREETEXT ( Adress1, 'Statement')



SQL 2012 Hosting: How to truncate the log file in SQL server

clock September 8, 2013 19:22 by author Herry

If log records were never deleted from the transaction log, the logical log would grow until it filled all the available space on the disks holding the physical log files. At some point in time, old log records no longer necessary for recovering or restoring a database must be deleted to make way for new log records. The process of deleting these log records to reduce the size of the logical log is called truncating the log.

To truncate a log file following this step
First, make new query from your Microsoft SQL management studio
After that copy / type SQL query bellow  

ALTER DATABASE @DBName SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(@DBName_log, 1)
ALTER DATABASE @DBName SET RECOVERY FULL WITH NO_WAIT
GO 

Change @DBName to your <database name>, and change  @DBName_log to your <log file name>

For example

ALTER DATABASE PartnerDB SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(PartnerDB_log, 1)
ALTER DATABASE PartnerDB SET RECOVERY FULL WITH NO_WAIT
GO 

Execute the query by pressing  F5 

The other way to truncate the log file is by shrinking the file
First  right click on your database  -> tasks -> shrinks -> database
This form will show up
 
 

Click OK
To make sure the log file was shrink check log file backup path, how to know where is log file backup path ?, right click on your database-> properties 

 
SQL server can be handled by asphostcentral
 
 


SQL 2012 Hosting : the difference between incremental, differential and full SQL backup

clock September 8, 2013 15:40 by author Herry

Now we are talking about backup, there are three type of backup, the full backup, the incremental and differential SQL backup.  Both differential and incremental backups are "smart" backups that save time and disk space by only backing up changed files. But they differ significantly in how they do it, and how useful the result is.

A full backup created from within Windows, of course, backs up all the files in a partition or on a disk by copying all disk sectors with data to the backup image file. Creating a full backup for unknown or damaged filesystems  Acronis True Image copies all sectors to the image file, whether or not the sector contains data. This is the simplest form of backup, but it is also the most time-consuming, space-intensive and the least flexible.

Typically full backups are only done once a week and are part of an overall backup plan. Sometimes a full backup is done after a major change of the data on the disk, such as an operating system upgrade or software install. The relatively long intervals between backups mean that if something goes wrong, a lot of data is going to be lost. That's why it is wise to back up data between full backups.

Most of the information on a computer changes very slowly or not at all. This includes the applications themselves, the operating system and even most of the user data. Typically, only a small percentage of the information in a partition or disk changes on a daily, or even a weekly, basis. For that reason, it makes sense only to back up the data that has changed on a daily basis. This is the basis of sophisticated backup strategies.

Differential backups were the next step in the evolution of backup strategies. A differential backup backs up only the files that changed since the last full back. For example, suppose you do a full backup  on Sunday. On Monday you back up only the files that changed since Sunday, on Tuesday you back up only the files that changed since Sunday, and so on until the next full backup. Differential backups are quicker than full backups because so much less data is being backed up. But the amount of data being backed up grows with each differential backup until the next full back up. Differential backups are more flexible than full backups, but still unwieldy to do more than about once a day, especially as the next full backup approaches.

Incremental backups also back up only the changed data, but they only back up the data that has changed since the last backup — be it a full or incremental backup. They are sometimes called "differential incremental backups," while differential backups are sometimes called "cumulative incremental backups."

If you do an incremental backup on Tuesday, you only back up the data that changed since the incremental backup on Monday. The result is a much smaller, faster backup. The characteristic of incremental backups is the shorter the time interval between backups, the less data to be backed up. the backups are so small and so fast you can actually back up every hour, or even more frequently, depending on the work you're doing and how important it is to have current backups.

While incremental backups give much greater flexibility and granularity (time between backups), they have the reputation for taking longer to restore because the backup has to be reconstituted from the last full backup and all the incremental backups since. 

 

 



SSL hosting on SharePoint Foundation 2010

clock September 2, 2013 19:51 by author Herry
What is SSL ?

the Secure Sockets Layer (SSL) is a commonly-used protocol for managing the security of a message transmission on the Internet. SSL has recently been succeeded

by Transport Layer Security (TLS), which is based on SSL. SSL uses a program layer located between the Internet's Hypertext Transfer Protocol (HTTP) and

Transport Control Protocol (TCP) layers.

Configuring SSL in SharePoint 2010 development environment

1. open IIS manager

2. In the Connections list select your local IIS server , and then from the IIS section select the server certificates



3.  Choose the Create self-signed certificate option from Actions

 



4.  enter the friendly name  of the certificate like  secure.asphostcentral.local and confirm the creation process by clicking the OK button.

double click on this created certificate and go to details tab and click copy to file

 

 

select No, do not export the private key, click next 

select DER encoded binary and click next

specify location , click next and finish 

next step is import for the certificate to sharedpoint certificate store 

first open manage compute certificate on windows server , goto SharePoint and right click >> alltaks >> import

make sure certificate store is sharepoint and click next then finish

 

 

after that goto central administration >> security >> manage trust and click NEW 

add a name and specify the location for certificate and click OK 

   

next step is associate the newly created self-signed certificate with our web application.

Although IIS Manager allows you to configure a variety of settings for your Web Sites, one thing it doesn’t support is configuring a secure binding based on

hostname. as soon as you select an SSL certificate to associate with binding IIS manager

 

 

 Confirm changes by clicking OK button

 Now you have a new SSL binding on your site and all the remains is to verify that works

 go to central administration >> alternate acess mapping and Choose your web aplication

 and click on edit public URLs and then add HTTPS URL 

 

  
and click save

now try to browse your website with HTTPS URL.

Because not everyone understands how to configure SSL, asphostcentral can help you to configure SSL on your website



Web Deploy 3.0 Hosting with ASPHostCentral.com

clock September 2, 2013 17:11 by author Herry

What is web deploy ?

Web Deploy simplifies deployment of Web applications and Web sites to IIS servers. Administrators can use Web Deploy to synchronize IIS servers or to migrate to newer versions of IIS. Web Deploy Tool also enables administrators and delegated users to use IIS Manager to deploy ASP.NET and PHP applications to an IIS server.

Web Deploy enables you to package your Web application content, configuration, databases and any other artifacts like registry, GAC assemblies etc., which can be used for storage or redeployment. If the package needs to be redeployed to a different environment, configuration values within the package can be parameterized during deployment without requiring modifications to the packages themselves. Once created, these packages can be deployed using Web Deploy cmdline or IIS Manager without requiring administrative privileges.

 

What is web matrix ?

WebMatrix is a free, lightweight, cloud-connected web development tool. 

With webmatrix you can Create, publish, and maintain your website with ease.

 

Setup Web Platform Installer

The Microsoft Web Platform Installer (Web PI) is a free tool that makes getting the latest components of the Microsoft Web Platform, including Internet Information Services (IIS), SQL Server Express, .NET Framework and Visual Web Developer easy.

    1. Download web platform installer

    2. Click the search bar  in the upper-right hand corner and search for "Recommended"

    3. Add the "Recommended Server Configuration for Web Hosting Providers" product and click Install

 

  

    5.   Add the "Web Deployment Tool 2.1 for Hosting Servers" product and clickInstall.

 

How to Configure a Site for Delegated Non-Administrator Deployment?

First you can Create a new site or set permissions on an existing Web site for a new or existing non-administrator user using Web Deploy PowerShell scripts

OR you can Configure publishing on an existing site for an existing user using the IIS Manager UI: 

   1. Start IIS manager with type inetmgr in Start menu

   2. Choose the Sites node and right click a site

   3. Right click > deploy >Configure for Web Deploy Publishing...

   4. The following UI will appear

 

   5.  Click select  on radio button Windows and Type the name of a non-administrator Windows user such ‘test’ and click Ok 

   6.  Click setup and the following log will appear:            

  • publish enabled for 'test'

  • Successfully created settings file 'C:\Users\JohnDoe\Desktop\test_Default Web Site.PublishSettings'

  • Granted 'NonAdminUser' full control on 'C:\inetpub\wwwroot\test'

 if you don't want any trouble, web deploy is supported by asphostcentral.com



WebMatrix 3 Hosting with ASPHostCentral.com

clock April 28, 2013 16:30 by author Administrator

ASPHostCentral.com offers the latest WebMatrix 3 hosting service to all our new and existing customers.           

You can always start with our Standard Plan (from @$4.49/month) to deploy WebMatrix 3 applications to our server. Should your requirement changes in the future, you can always request for an upgrade without causing any downtime. Remember, everything is just one-click away from your mouse! So, why wait longer?

What is WebMatrix?

WebMatrix is a free, lightweight, cloud-connected web development tool.

Designed for Top Languages

Create websites using our ASP.NET, PHP, Node.js, or HTML5 templates, and take advantage of the latest web standards, emerging standards(CSS3, HTML5), and popular JavaScript libraries such as JQuery

Your Companion for the Cloud

When you create local projects, you’ll be able to instantly get a companion website in Windows Azure without ever leaving WebMatrix. Using the Publish button, you can easily keep these sites in sync and save your changes to the cloud

Source Control with Git

Plug into GitHub, CodePlex, and Team Foundation Service to start sharing your code with the world. Whether you’re a newcomer to git, or a seasoned pro, you’ll find all of the features you would expect in a powerful but easy to use too

Remote Site Editing

Simply open your remote sites, make changes, and hit Save. The lightweight performance and full editing capability (including intellisense) make it feels like you are editing a local site!

Optimized for Open Source

Install popular web apps with a few clicks, customize them easily with app-specific code completion, and publish them quickly to the web.

Designed for Mobile

Optimize your websites for mobile browsing with built-in templates, device emulators and code completion for JQuery mobile

Source Control with TFS

Team Foundation Service is Microsoft’s hot new source control service in the cloud. WebMatrix 3 makes it simple and fun to work with your code using TFS for any project in the cloud, or on site.

Extended by the Community

Want an iPhone simulator or power tools for Node.js? Find extensions that add even more functionality to WebMatrix, or create your own




ASP.NET Hosting

ASPHostCentral is a premier web hosting company where you will find low cost and reliable web hosting. We have supported the latest ASP.NET 4.5 hosting and ASP.NET MVC 4 hosting. We have supported the latest SQL Server 2012 Hosting , SharePoint 2013 hosting and Windows Server 2012 Hosting too!






Sign in

Technology