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.

Continued...
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.

Continued...
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.

Continued...
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.

Continued...