Site hosting news, tutorials, tips, How Tos and more

Archive for April, 2012


php? Yes, we have it!

featureoftheweek

phpIt’s not surprising that most of our customers use Winhost for .NET or asp applications. We run Windows servers exclusively after all. But don’t forget that we also offer php!

If you used php on a Windows server 5 or 6 years ago you might be thinking, “Why would I want to put myself through that torture again?” But the Windows php implementation has improved significantly in the past few years, and performance is equal to what you would see on any Linux server. Seriously.

Evidence of that improved performance is the growing number of Winhost users installing WordPress, phpBB and other php/MySQL applications. And why not? Especially since the App Installer in Control Panel makes installing many php/MySQL applications quick and easy.

You don’t have to do anything to use php with your Winhost site. It’s there waiting for you, right now. And frankly, it’s a little sad that you’ve been neglecting it.

By the way, if you have an account at an old fashioned Linux host because you thought you needed it to run your php app – free yourself! Move the site over to your truly flexible Winhost account.

Because at Winhost you can have it both ways.



Microsoft going a TAD bit too far?

Microsoft is still at it with their TAD VMLimited character campaign.

[Video deleted.]



How to add a subdomain to your site

howto

A subdomain is an extension of your domain name; a prefix that allows you to use URLs such as blog.HostingAccountDomain.com, forum.HostingAccountDomain.com, etc. A subdomain typically routes traffic to a specific subdirectory within your account.

To create a subdomain, log in to Control Panel, click the “Sites” tab and click the “Manage” link for the domain you wish to work with.

In the Site Tools section, click the “Subdomain Manager” icon or link.

Next, click the “Add” button.

Enter the subdomain and click the “Create” button.

Finally you’ll see confirmation that your subdirectory has been created.

For tips on redirecting subdomain traffic to a subdirectory, see this Knowledge Base article, or our forum.



Winhost customer spotlight: Jeremy Foster

customerspotlight

jeremy-foster

Jeremy Foster works for Microsoft as a Developer Evangelist in Seattle, WA. By way of introduction he says, “It is my job to connect with developers in our northwest region – to inform and inspire them in the use of Microsoft’s amazing development tools and frameworks. I use my own website codefoster.com to blog and stay connected with the development community. I plan to expand it in the future to include robust developer resources, screencasts, podcasts, and more.”

When did you first become interested in web technologies?

I started doing software development in the early 90’s and built my first website around ’93. It was an exciting venture at the time to create a personal place on the web that was visible to the world. It was a venture that I have never really shaken. Around ’97 I started working with programmatic, data-driven website applications and it has been a strong part of my career track ever since.

Which technologies are you using for your web site?

I’m a big fan of ASP.NET MVC. I like using MS SQL for the data and usually interact with it using Entity Framework code first, although at this point my site doesn’t have any database dependencies.

How long have you hosted your site with Winhost?

I’ve been using Winhost for a few months – perhaps half a year, but I’ve only recently (February 2012) begun working at Microsoft and started up my codefoster.com site to support that.

Why did you choose Winhost?

I believe I found some positive reviews and was enough dismayed by my former host and enough attracted by the low introductory rates to just give it a try.

Thanks, we’re glad you did. What do you consider to be the key benefits of using Winhost?

Winhost has impressed me all around. The control panel seems more unified and intuitive than most, the temporary site URLs are good, and the support has been great (one time responding within an hour on a weekend).

What future plans do you have for your web site?

I will likely be adding test and demo apps within my site for educational purposes and will continue to flesh out the codefoster.com main site in whatever ways will best support my audience.

Which future technologies or trends are you most excited about?

I am very excited about Windows 8 and cloud computing. With Windows 8 I get to take my many years of web application development experience into the client platform that’s already installed on hundreds of millions of computers.

What do you like to do when you aren’t up to your neck in technology?

I really enjoy getting out on the water sailing or under the water scuba diving in the Pacific Northwest. My wife and I also enjoy hiking, traveling, and finding good happy hour restaurants in Seattle.

Thanks, Jeremy, for being the first Winhost customer spotlight interview, we really appreciate it.



How to work around an annoying SQL Management Studio Designer error

howto

This may be an old topic but it’s worth mentioning.

Ever since SQL 2005 was released, there is a weird setting in SQL Management Studio that prevents you from saving the changes on your database.  The error is very misleading because it gives an impression that the security error is coming from the SQL Server itself, when in fact it’s your SQL Management Studio that is generating the error.

I was hoping this would be fixed in SQL 2012 Management Studio, but it still seems to exist.

This is the error you will see in Management Studio:

Saving changes is not permitted. The changes 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.

What will lead to this error is when you create a table, save it, then go back into the table and impose changes such as setting auto increment on a specific column.

The reason is because these types of changes will actually cause Management Studio to delete the table and recreate it.  This is done behind the scenes by SQL Management Studio.  So I guess SQL Management Studio wants to make sure it has permission before making such life altering changes.

Odd right? Fortunately the fix is really easy.  In SQL Management Studio (it does not matter whether you are connected to a database or not) go to Tools/Options/Designers/Table and Database Designers.  Make sure you uncheck “Prevent saving changes that require table re-creation.”

Now keep in mind, I’m using SQL 2012 Management Studio, but I believe this should be the same for the older SQL Management Studios, such as 2005 and 2008.  And as you can see, since I do not need to connect to the SQL Server to make this change, the setting is associated with Management Studio, not the SQL Server itself.



Related Knowledge Base articles

featureoftheweek

Did you know that on just about every page of Control Panel there is a list of related Knowledge Base articles?

There are a lot of articles in our Knowledge Base (318 and counting!), and we understand that sometimes it can be difficult to quickly find exactly what you are looking for. That’s why we have included a “Related KB Articles” list in many sections of Control Panel.

When you are in the Email section, for example, you have direct access to the most relevant and popular Knowledge Base articles about email.

Also, if you feel that there is a Knowledge Base article that is missing, or that needs updating or clarification, please let us know. We work hard to maintain the best Knowledge Base in the industry, and your help is one of our most valuable tools!



MS SQL 2012 is available now

announcements

Ready or not, here comes SQL 2012!

I know, you weren’t expecting us to roll it out so soon, were you? We’ve been busy prepping behind the scenes for the Microsoft release, and ensuring that we could offer it to you as soon as it was publicly available.

So you can log in to Control Panel and use SQL 2012 right now.

When you log in to the Site Tools section, the first thing you may notice is that the MS SQL 2008 section has been renamed MS SQL Manager.

Once you’re inside, you’ll see that when you create a new database, you now have the option to choose SQL 2012.

That’s all there is too it.

We’re happy to be able to make SQL 2012 available to you quickly. We’re working hard to make Winhost the only web host you’ll ever need.