Posted by
Andrew Gould
on 23 July 2012
If your SQL queries return lots of records you'll probably want to sort the results in some kind of order. This blog teaches you how to use the ORDER BY clause to do exactly that!
Posted by
Andrew Gould
on 23 July 2012
This blog teaches the absolute basics of writing queries in Microsoft SQL Server Management Studio. You'll learn how to use the SELECT and FROM keywords to create simple queries showing all of the records from a single table.
Posted by
Andy Brown
on 24 May 2012
Stored procedures are programs in SQL which allow you to pass parameters to queries and manipulate sets of rows in tables. Find out how to write them with this online training blog!
Posted by
Andrew Gould
on 30 April 2012
Before you get into writing SQL Queries you should take some time to familiarise yourself with the application in which you'll be spending most of your time. This blog shows you the basics of SQL Server Management Studio.
Posted by
Andy Brown
on 07 July 2023
Designing relational databases is easy once you learn the few basic rules, and the procedure is identical whether you're using SQL Server or Access. This blog illuminates the subject!
Posted by
Andrew Gould
on 02 August 2023
If you frequently import data into a SQL Server database from the same source you'll probably be sick of going through the import wizard again and again. So why not learn how to schedule an automatic import of your data using SSIS packages and the SQL Server Agent? This blog explains how to do exactly that!
Posted by
Andrew Gould
on 16 February 2012
This blog explains how you can get access to all of the records in a SQL Server 2008 table when you try to edit them, rather than just the top 200.
Posted by
Andrew Gould
on 16 February 2012
A common requirement in SQL queries is calculating a person's age. The expression you need to do this accurately is relatively long, so why not replace it with a user-defined function? This blog shows you how!
Posted by
Andrew Gould
on 16 February 2012
If you've spent time in the SQL Server Management Studio application you'll probably have noticed that it's not the most user-friendly environment for writing SQL queries. This blog explains how to change a few settings to make your query writing just a little easier.
Posted by
Andrew Gould
on 13 February 2012
This article provides a comprehensive tutorial in Microsoft SQL Server, taking you from the basics of writing SELECT statements all the way through to creating complex stored procedures.
Posted by
Andrew Gould
on 13 February 2012
Dates and times can be the most frustrating data types to work with in SQL Server. Learn everything you need to know about the way dates work with this handy blog series and enjoy happier times!
Posted by
Andy Brown
on 20 October 2011
This blog gives training on writing CTEs in SQL, or Common Table Expressions to give them their full title. The blog also includes a section on creating recursive CTEs.
Posted by
Andy Brown
on 20 October 2011
If you want training in how to use temporary tables in SQL, read on! This blog shows how to create temporary tables and how to drop them safely whether or not they exist. Finally, the blog lists the pros and cons of using temporary tables in SQL.