How to Create a Database Using T-SQL
Produced: 24/02/2013 10:26:00
This article will show you how to create your very first database using T-SQL code. This is a very simple process and will allow you to then move on to creating tables and other objects in which to store your data.

Basic Guide to SQL Server Configuration (sp_configure)
Produced: 17/02/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.

I won’t go into every single configuration option, just those which I tend to change and tamper with when installing and running a new SQL Server instance.

Basic GROUP BY Usage
Produced: 10/02/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: 03/02/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.