Learning Database Design

Over the years we have encountered and solved database related problems. You can browse some of them here and hopefully they may help you to optimise your own systems

Get Open Query

This Table and set of Stored Procedures will enable you to automate the transfer of data from Oracle and Progress databases into SQL Server.

SQL Server Data

Using SQL Server data effectively can save both man and processing hours. Here are some of our best data processing and cleansing articles

SQL Server Maintenance

SQL Server Maintenance Plan that can backup and restore database files on multiple servers, re-organise or rebuild indexes dependent on time

Technical Tools

A selection of tools aimed at making your SQL Server life easier.

The Basics

Our first section on Learning Databases will take you through the basics of SQL Server, from creating tables and datatypes to selecting, updating and deleting data

Using SQL Server Dates

We share some of our most portable functions using a calendar table to store and calculate bank holidays and weekends as well as set recurring frequencies.

Using SQL Server Functions

Any well written database will have a selection of functions, most of the time they are useful but when used in the wrong context they can actually harm performance

Using SQL Server Pivot-Unpivot

A selection of articles on using SQL Server PIVOT & UNPIVOT

Database consultancy services in SQL Server, Oracle and the Cloud