Backup Types
Produced: 30/06/2013 09:14:00
There are 3 backup types within SQL Server… Full, Differential, and Transactional.

The reason for there being 3 types are not immediately obvious but understanding them is key to having a good backup strategy within your system. These are also relevant to the Recovery Mode of your databases.

Continued...
Configure Distribution
Produced: 23/06/2013 18:25:00
In order to get up and running creating Publications on your server, you first need to either set up a Distributor, or register a pre-existing remote Distributor. To do this we’ll use the Wizard.

In SSMS, right click Replication and select “Configure Distribution…

Continued...
Replication Article Properties
Produced: 16/06/2013 17:32:00
When adding articles to replication one of the most important things to consider are its properties. Get these wrong and your replication may not work as expected, but get them right and you’ll be plain sailing.

Continued...
How to Set Up a Linked Server Using SSMS
Produced: 09/06/2013 11:42:00
In environments in which multiple SQL Servers (or other databases such as mySQL) are present, there are many times in which server A could require data from a database on server B. In order to accommodate this scenario SQL Server presents us with the Linked Server.

This is basically an integrated means of connecting to other SQL Servers whilst also giving a level of control between the systems such as security settings.

Continued...
SQL Server 2008 R2 Installation Guide
Produced: 02/06/2013 14:01:00
Need to do a clean install of SQL Server 2008 R2? There are numerous configuration options, choices, and pitfalls involved in performing a clean install. Here I will run through a basic installation of SQL Server 2008 R2 covering all the screens involved, the options therein, and what they mean.

Continued...