Tag Info

Hot answers tagged

4

What you are looking for is XAMPP Portable Lite http://www.apachefriends.org/en/xampp-windows.html. XAMPP is a "Apache distribution containing MySQL, PHP and Perl" and you can use it for developing your website on your local pc.


2

This Microsoft site page lets you search for hosting providers based on parameters like type of server (shared, dedicated, virtual server) cost, technologies supported, storage, number of SQL Databases, number of e-mail accounts, bandwidth per month, support, uptime


2

You could consider using Microsoft's Window Azure cloud platform instead of Amazon's cloud as there is good in-built support for the technologies you have mentioned. To start experimenting with Azure, you can try it out with a free Windows Azure Platform 30 Day Pass & see if it fits your requirements.


2

Express is still SQL Server, has the same primary abilities and can easily be backed up and restored to Standard, Enterprise, etc when the growth requires it. You can compare express with other editions at http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx The primary difference is resource limitations. Express can only use a single CPU, 1 ...


2

You need to create an A record for sqldb1234.db in your DNS area for GoDaddy. http://support.godaddy.com/help/article/2290/how-do-i-create-a-subdomain-in-simple-control-panel Once the A record has propagated you should be able to use the subdomain sqldb1234.db.mydomain.com in your connection string.


2

If you're talking about dedicated servers, then it won't be such a big problem to transfer the database. You can use SSH in order to transfer it directly from one server to another, without even downloading it. Then you can import it in a new database from the command line pretty fast. If you don't want to worry about storage and performances, then go for ...


1

What you need is any kind of a so-called "WAMP stack". There are many solutions out there to choose from, see a comparison of WAMPs. Although the most popular one is probably XAMPP, my recommendation would be to use Uniform Server instead. Uniform Server is much lighter and easier to manage than XAMPP. And it doesn't need an installation, so you can even ...


1

It's pretty standard practice to have a data warehouse separate from your application database to run reports off of. This keeps your app from slowing down when generating reports and allows you to keep more data and in a more suitable (denormalized if necessary) format for running reports. It's analogous in principle to Command Query Separation/CQRS in ...


1

It sounds like you've been left with enough access for someone who knows what they are doing to make the changes you need, apart from the question of where the database actually lives. (Sometimes the problems posted here on this site are that people don't have enough access.) If someone can access the site via FTP they can find a bit more about where the ...


1

Not sure how GoDaddy has their servers set up, but many/most web hosts run dedicated MySQL servers, offloading the DB workload from the web server. As for security, SQL Server 2008 at least supports cell-level encryption like Server 2005 as well as full database-level encryption. Windows also supports file-level encryption via EFS and BitLocker. Given these ...



Only top voted, non community-wiki answers of a minimum length are eligible