Date and Time Formats in SQL Server
Produced: 28/04/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.

Running the following script will show the different date and time formats you have available…

Produced: 21/04/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: 14/04/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: 07/04/2013 12:46:00
There are 4 main system databases and 1 other used when replication is in place. This article will explain the differences between the databases, what they're for and how to use them to improve your setup.