Table Value Variables
Produced: 30/12/2013 12:06:00
As with single value variables, these are very simple and powerful objects which are also only active and present during the execution of your code. They are automatically dropped and tidied up once execution finishes.

Could not find stored procedure dbo.sp_MScheckIsPubOfSub
Produced: 23/12/2013 15:46:00
I was working on one site when we got a very strange replication error appear. I’ve still no idea what caused it, but that won’t stop me posting the error message itself along with the simple solution…

Backup Types
Produced: 16/12/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.

Configure Distribution
Produced: 09/12/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…”:
Replication Article Properties
Produced: 02/12/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.

How to Set Up a Linked Server Using SSMS
Produced: 25/11/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.

SQL Server 2008 R2 Installation Guide
Produced: 18/11/2013 14:01:00
Here I will run through a basic installation of SQL Server 2008 R2. This does not include Analysis Services or Reporting Services as they are out of the scope of this article. This literally covers the basic install and key settings that need to be considered prior to running SQL Server for the first time.

Continuous or Scheduled Replication (my two cents)
Produced: 11/11/2013 14:37:00
This defines how often the SQL Server Agent job runs… does it run to a schedule, or does the job run continuously.

How to Subscribe to a Publication
Produced: 04/11/2013 19:50:00
Once you have created your publication you will need to subscribe to it (otherwise it’s pretty pointless really).

PATINDEX
Produced: 28/10/2013 18:46:00
In terms of functionality, this is very similar to CHARINDEX in that it simply looks for a pattern within a string.

However, where it differs is that PATINDEX requires you to use wildcard characters as part of your search, something that CHARINDEX will not, but it is less powerful in some ways in that it does not allow you to specify a starting point and therefore will only ever find the first occurrence of a pattern in a string.

How to Create a Publication
Produced: 21/10/2013 16:27:00
This is generic guide as, to be honest, setting up all replication is pretty much the same. There are a couple of extra screens for Merge replication and I’ll highlight those where necessary. Otherwise it’s all the same.

Date and Time Formats in SQL Server
Produced: 14/10/2013 09:27:00
There are numerous times you might want your dates returned in a different format and SQL Server will cater for this.

REPLACE
Produced: 07/10/2013 09:44:00
This is a very common function when performing string manipulation… you simply pass in a character or string that you wish SQL to look for, the text in which to look, and what you want the character or string replacing with.

Push vs Pull Subscription
Produced: 30/09/2013 20:14:00
When Subscribing to a Publication you will need to decide whether you want to use a Push or a Pull subscription. The difference may not sound much on paper, but there are some key points that really need to be noted before you make your choice.

Guide to System Databases
Produced: 23/09/2013 12:46:00
There are 4 main system databases and 1 additional database. These are:
DATEADD, DATEPART, and DATEDIFF
Produced: 16/09/2013 18:41:00
I’ve always found that no matter what I end up coding, I always have to manipulate a date or two. Whether it’s finding last week’s date, extracting the minute from a datetime, or calculating how long someone has taken between orders, it always comes down to manipulating dates.

List of Datatypes
Produced: 09/09/2013 18:46:00
A datatype is exactly how it sounds... it defines the type of data. We use these all the time in our normal lives but may not even realise it.

Numeric DataTypes
Produced: 02/09/2013 09:50:00
I will presume that you know the most common numerical datatypes (if not, please refer to the list here).

Create a Database Using SSMS
Produced: 26/08/2013 13:04:00
IMPORTANT: The majority of the settings you’re about to see are actually taken from the system database “model”. The model database is, as its name implies, the “model” by which all others are created. Therefore if you change settings, initial sizes, growth rates, and recovery options in the model database, then those are the defaults you will be presented with when creating a new database from scratch following the method below. If you have some settings that you wish to apply generically to all databases, then simply change them on the model database.

Create a Database Using SSMS
Produced: 26/08/2013 13:04:00
IMPORTANT: The majority of the settings you’re about to see are actually taken from the system database “model”. The model database is, as its name implies, the “model” by which all others are created. Therefore if you change settings, initial sizes, growth rates, and recovery options in the model database, then those are the defaults you will be presented with when creating a new database from scratch following the method below. If you have some settings that you wish to apply generically to all databases, then simply change them on the model database.

How to Create a Table in SQL Server
Produced: 19/08/2013 19:00:00
There are a couple of ways of achieving this, the first is using SQL Server Management Studio as a “point and click” tool, and the other is using T-SQL code.

How to Create a Database Using T-SQL
Produced: 12/08/2013 10:26:00
IMPORTANT: The majority of the settings you’re about to see are actually taken from the system database “model”. The model database is, as its name implies, the “model” by which all others are created. Therefore if you change settings, initial sizes, growth rates, and recovery options in the model database, then those are the defaults you will be presented with when creating a new database from scratch following the method below. If you have some settings that you wish to apply generically to all databases, then simply change them on the model database.

How to Create a Database Using T-SQL
Produced: 12/08/2013 10:26:00
IMPORTANT: The majority of the settings you’re about to see are actually taken from the system database “model”. The model database is, as its name implies, the “model” by which all others are created. Therefore if you change settings, initial sizes, growth rates, and recovery options in the model database, then those are the defaults you will be presented with when creating a new database from scratch following the method below. If you have some settings that you wish to apply generically to all databases, then simply change them on the model database.

Basic Guide to SQL Server Configuration (sp_configure)
Produced: 05/08/2013 11:49:00
Configuring your SQL Server correctly is one of the key tasks that must be completed in order to get the best performance out of your system.

Basic GROUP BY Usage
Produced: 29/07/2013 09:45:00
This is a key phrase when referring to any aggregate function as all aggregate functions require grouping in order for the data to have any meaning. As such this is a mandatory key phrase to be used within all aggregation.

Basic DELETE statement
Produced: 22/07/2013 20:26:00
Okay, this time an UPDATE simply won’t suffice. Something is badly wrong and we need to remove a record rather than just update it.

Basic INSERT statement
Produced: 15/07/2013 14:59:00
This article is a simple and brief introduction to the INSERT statement within SQL Server. This, as the name suggests, is the method used to enter data into our databases.

For this example we'll use a Person table which you'll need to create using the following script:

Basic SELECT statement (with WHERE clause)
Produced: 08/07/2013 17:28:00
This article is a simple and brief introduction to the SELECT statement within SQL Server. This is the most basic and most useful tool in the SQL language. It allows us to see what data is being held in our databases.

Basic UPDATE statement
Produced: 01/07/2013 11:29:00
Okay, we’ve inserted data, selected data, but what happens if we find some of our data is wrong? That’s where we need to UPDATE our records.