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

Filter

Automate Open Query in MS SQL Server

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

Using SQL Server data effectively

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

A complete maintenance plan for SQL Server 2008

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

Database Tools

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

SQL Server - Learning 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

SQL Server flexible date Functions and calendar Table

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.

Introduction into SQL Server Functions, their benefits and drawbacks

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