How to shrink the MSSQL transaction log

In this guide I’m going to go through the process of shrinking an MSSQL database transaction log. Shrinking your transaction log will allow you to make more space within your database without removing any of the data stored within the … Continue reading

Kentico 8 – Installation

Kentico 8 has been redesigned from the ground up,  whether it’s a CMS, e-commerce shop or an online community Kentico 8 is a out of the box powerful solution for all your website requirements. In this guide we are going … Continue reading

Tagged ,

Run larger websites with Pipe Ten

You can now run even larger websites on Pipe Ten’s standard shared hosting plans as inclusive database allocations have now been increased at no extra cost.


Exporting and Importing stored procedures MSSQL

In this guide we are going to walk you through exporting and importing your MSSQL stored procedures within SQL management studio. Note: If you are using our littlebackup tools to import/export your database, then this will include a back up … Continue reading

Tagged ,

Shared SQL Server 2008

All shared web hosting customers now have the option to use either MS SQL Server 2008 rather than MS SQL Server 2005.

Connecting to MS SQL Server using MS SQL Server Management Studio

In this tutorial we will show you how to connect to a MS SQL server using MS SQL Server Management Studio. In here you can do database queries in a few clicks.


How to make MySQL work with ASP using the ODBC connection

When enabling classic mode under any .NET version (whether you are using .NET or not) if you enable classic mode your application runs in a worker application pool that is in a 32 bit environment. To fix this we need … Continue reading

Tagged ,

How to use MyLittleBackup

In this tutorial we are going to walk you through backing up your MSSQL databases using MyLittleBackup. This back up process will create a .bak file. myLittleBackup for SQL Server 2000, 2005 and 2008 is the first Backup/Restore solution specially … Continue reading

Tagged ,

Switching MS SQL database servers

There is an occasional requirement to manually move your database from one server to another. Typically this is required as the result of an account migration between data centres.

Tagged , , ,

MS SQL Server Management Studio 2008

When connecting to an MS Sql 2005 Server using MS SQL Server Management Studio 2008 you may come across an error “Failed to retrieve data for this request (Microsoft.SqlServer.Management.sdk.sfc)”. This in turn will prevent you from being able to connect … Continue reading

Tagged ,

How do I import or export MSSQL database?

Please note this guide will only copy database tables, not stored procedures, views, functions, or SQL rules.

Tagged ,