Scotland Transact-SQL Contracts

This section looks at the demand for Transact-SQL (T-SQL) skills within the Scotland region with a comparison to our Programming Languages category. Included is a guide to the contractor rates offered in IT jobs that have cited Transact-SQL over the 3 months to 21 August 2008 with a comparison to the same period last year.

Transact-SQL (T-SQL)
Location Banbury Basingstoke Bath Bedfordshire Belfast Berkshire Birmingham Blackpool Bradford Brighton Bristol Buckinghamshire Bury St Edmunds Cambridge Cambridgeshire Canary Wharf Cardiff Channel Islands Chatham Chelmsford Cheltenham Chertsey Cheshire Chester Chorley City of London Clapham County Antrim Coventry Crawley Croydon Derby Derbyshire Docklands, London Dorking Dorset Durham East Anglia East Midlands East of England East Sussex East Yorkshire Edinburgh England Essex Farnham Gatwick Glamorgan Glasgow Gloucester Gloucestershire Guildford Halifax Hampshire Hemel Hempstead Herefordshire Hertfordshire Hull Huntingdon Huntingdonshire Kent Knutsford Lancashire Leeds Leicestershire Liverpool Livingston London Manchester Merseyside Middlesex Midlands Milton Keynes Newcastle Newcastle Upon Tyne Newport Norfolk North East North West North Yorkshire Northamptonshire Northern Ireland Norwich Nottingham Nottinghamshire Oxford Oxfordshire Peterborough Portsmouth Reading Redhill Scotland Sheffield Sidcup Slough Somerset South Coast South East South Wales South West South Yorkshire Southampton St Helens Staffordshire Staines Stoke-on-Trent Suffolk Surrey Swindon Thames Valley Tonbridge Tyne and Wear UK Uxbridge Wales Warrington Warwickshire Watford West Lothian West Midlands West Sussex West Yorkshire Wiltshire Woking Worcester Worcestershire York Yorkshire	3 months to 21 Aug 2008	Same period last year
Rank	92	91
Rank change on same period last year	-1
Matching contract IT job ads	10	40
As % of all UK contract IT job ads sampled	0.013 %	0.040 %
As % of the category below	1.368 %	3.298 %
Daily rates quoted	1	11
Average minimum daily rate	£200	£339
Average daily rate	£250	£351
% change on same period last year	-28.84 %
Average maximum daily rate	£300	£364
UK excluding London average daily rate	£297	£334
% change on same period last year	-11.06 %
Hourly rates quoted	0	3
Average minimum hourly rate	-	£60.00
Average hourly rate	-	£61.67
% change on same period last year	-
Average maximum hourly rate	-	£63.33
UK excluding London average hourly rate	£37.24	£34.51
% change on same period last year	+7.92 %
Programming Languages Scotland
Matching contract IT job ads	731	1213
As % of all UK contract IT job ads sampled	0.965 %	1.208 %
Daily rates quoted	162	265
Average minimum daily rate	£304	£313
Average daily rate	£326	£329
% change on same period last year	-0.85 %
Average maximum daily rate	£347	£344
UK excluding London average daily rate	£330	£335
% change on same period last year	-1.38 %
Hourly rates quoted	29	36
Average minimum hourly rate	£26.58	£29.13
Average hourly rate	£29.56	£31.20
% change on same period last year	-5.26 %
Average maximum hourly rate	£32.54	£33.27
UK excluding London average hourly rate	£33.40	£33.03
% change on same period last year	+1.11 %
Transact-SQL UK

We calculate average IT contractor rates directly from the figures quoted and do not attempt to derive hourly rates from daily rates or vice versa.

Transact-SQL
Demand Trend

The chart provides a 3-month moving total beginning in 2004 of IT contractor jobs citing Transact-SQL across the Scotland region as a proportion of the total demand within the Programming Languages category.

Transact-SQL
Daily Rate Trend

The chart provides the 3-month moving average for daily rates quoted in IT contract jobs citing Transact-SQL across the Scotland region.

Transact-SQL
Hourly Rate Trend

The chart provides the 3-month moving average for hourly rates quoted in IT contractor jobs citing Transact-SQL across the Scotland region.

Transact-SQL
Contract Locations

This section looks at the demand and provides a guide to the average contractor rates quoted in IT jobs citing Transact-SQL within the Scotland region over the 3 months to 21 August 2008. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year. A positive number indicates a relative increase in demand.

Location	Rank Change on Same Period Last Last	Matching Contract IT Job Ads	Average Daily Rate Last 3 Months	Average Daily Rate % Change on Same Period Last Year
Glasgow	+5	5	-	-
Edinburgh	+7	4	-	-
West Lothian	-	1	£250	-

Transact-SQL UK

Transact-SQL
Top 30 Related IT Skills

For the 6 months to 21 August 2008, IT contractor jobs across the Scotland region citing Transact-SQL also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of contract IT job ads sampled that cited Transact-SQL.

1 48 (100.00 %) SQL 2 36 (75.00 %) SQL Server 3 27 (56.25 %) XML 4 22 (45.83 %) SQL Server 2005 4 22 (45.83 %) SQL Server Integration Services 5 18 (37.50 %) .NET 6 16 (33.33 %) SQL Server Reporting Services 7 14 (29.17 %) AJAX 7 14 (29.17 %) JavaScript 7 14 (29.17 %) ASP.NET 8 13 (27.08 %) C# 8 13 (27.08 %) HTML 9 11 (22.92 %) Microsoft 10 10 (20.83 %) Java 10 10 (20.83 %) Windows

11 9 (18.75 %) J2EE 11 9 (18.75 %) Sybase 11 9 (18.75 %) UNIX 11 9 (18.75 %) Web Design 12 8 (16.67 %) .NET Framework 12 8 (16.67 %) Internet 12 8 (16.67 %) SharePoint 13 7 (14.58 %) Data Modelling 13 7 (14.58 %) WebServices 13 7 (14.58 %) Business Analysis 13 7 (14.58 %) Spring 14 6 (12.50 %) Adobe Flex 14 6 (12.50 %) RIA 14 6 (12.50 %) TDD 14 6 (12.50 %) Workflow

Transact-SQL
Top Related IT Skills by Category

For the 6 months to 21 August 2008, IT contractor jobs across the Scotland region citing Transact-SQL also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of contract IT job ads sampled that cited Transact-SQL. Up to 20 skills are shown per category.

Application Development 1 27 (56.25 %) XML 2 18 (37.50 %) .NET 3 14 (29.17 %) AJAX 3 14 (29.17 %) ASP.NET 4 13 (27.08 %) HTML 5 9 (18.75 %) J2EE 6 8 (16.67 %) .NET Framework 7 7 (14.58 %) WebServices 7 7 (14.58 %) Spring 8 6 (12.50 %) Adobe Flex 8 6 (12.50 %) CSS 8 6 (12.50 %) JSP 9 3 (6.250 %) XSLT 9 3 (6.250 %) ASP.NET 2.0 10 2 (4.167 %) Microsoft Enterprise Library 10 2 (4.167 %) XHTML 10 2 (4.167 %) XSL 10 2 (4.167 %) ADO.NET 10 2 (4.167 %) SOAP 11 1 (2.083 %) EDI	Application Platforms 1 8 (16.67 %) SharePoint 2 4 (8.333 %) BizTalk Server 3 3 (6.250 %) SharePoint Server 2007 4 1 (2.083 %) MQSeries 4 1 (2.083 %) Tomcat
Applications 1 4 (8.333 %) MS Excel	Business Applications 1 1 (2.083 %) Microsoft CRM
Communications & Networking 1 8 (16.67 %) Internet 2 4 (8.333 %) LDAP 3 1 (2.083 %) FTP	Database & Business Intelligence 1 36 (75.00 %) SQL Server 2 22 (45.83 %) SQL Server 2005 2 22 (45.83 %) SQL Server Integration Services 3 16 (33.33 %) SQL Server Reporting Services 4 4 (8.333 %) ETL 4 4 (8.333 %) MS Access 5 2 (4.167 %) Reference Data 5 2 (4.167 %) Microsoft Analysis Services 5 2 (4.167 %) GIS 5 2 (4.167 %) SQL Server 2000 5 2 (4.167 %) RDBMS 5 2 (4.167 %) Oracle 9i 6 1 (2.083 %) Crystal Reports 6 1 (2.083 %) Datawarehouse 6 1 (2.083 %) SQL Server Analysis Services 6 1 (2.083 %) Data Cleansing
Development Applications 1 6 (12.50 %) Visual Studio 1 6 (12.50 %) Ant 2 2 (4.167 %) NUnit 3 1 (2.083 %) JUnit 3 1 (2.083 %) ClearCase 3 1 (2.083 %) JProbe 3 1 (2.083 %) Optimizeit 3 1 (2.083 %) Subversion	General 1 5 (10.42 %) Games 2 3 (6.250 %) Banking 3 2 (4.167 %) Online Banking 4 1 (2.083 %) Retail
Job Titles 1 37 (77.08 %) Developer 2 17 (35.42 %) SQL Developer 3 16 (33.33 %) SQL Server Developer 4 6 (12.50 %) Server Analyst 4 6 (12.50 %) Flex Developer 4 6 (12.50 %) Data Analyst 4 6 (12.50 %) Applications Support Engineer 4 6 (12.50 %) Analyst 4 6 (12.50 %) Support Engineer 4 6 (12.50 %) Applications Support 4 6 (12.50 %) SQL Server Analyst 5 5 (10.42 %) Developer Analyst 5 5 (10.42 %) Java Developer 5 5 (10.42 %) .NET Developer 6 4 (8.333 %) Web Developer 7 3 (6.250 %) Architect 7 3 (6.250 %) Oracle Developer 7 3 (6.250 %) Sharepoint Architect 8 2 (4.167 %) Senior ASP.NET Developer 8 2 (4.167 %) Sybase Developer	Miscellaneous 1 6 (12.50 %) RIA 2 3 (6.250 %) Data Integration 3 2 (4.167 %) Replication 4 1 (2.083 %) Computer Science
Operating Systems 1 10 (20.83 %) Windows 2 9 (18.75 %) UNIX 3 2 (4.167 %) Windows Server 2003 3 2 (4.167 %) Linux	Processes & Methodologies 1 9 (18.75 %) Web Design 2 7 (14.58 %) Data Modelling 2 7 (14.58 %) Business Analysis 3 6 (12.50 %) TDD 3 6 (12.50 %) Workflow 4 5 (10.42 %) Extreme Programming 4 5 (10.42 %) Pair Programming 5 4 (8.333 %) OO 6 3 (6.250 %) Systems Analysis 7 2 (4.167 %) Content Management 7 2 (4.167 %) Web Development 7 2 (4.167 %) Migration 7 2 (4.167 %) OOD 7 2 (4.167 %) SOA 8 1 (2.083 %) UML 8 1 (2.083 %) OOP 8 1 (2.083 %) OOA/OOD 8 1 (2.083 %) Business Intelligence 8 1 (2.083 %) Agile Software Development 8 1 (2.083 %) Software Engineering
Programming Languages 1 48 (100.00 %) SQL 2 14 (29.17 %) JavaScript 3 13 (27.08 %) C# 4 10 (20.83 %) Java 5 5 (10.42 %) Ruby 6 4 (8.333 %) DHTML 6 4 (8.333 %) PL/SQL 7 3 (6.250 %) VB.NET 7 3 (6.250 %) VBA 8 2 (4.167 %) Shell Script 9 1 (2.083 %) PHP 9 1 (2.083 %) VB 9 1 (2.083 %) XPath	Qualifications 1 2 (4.167 %) Degree 1 2 (4.167 %) Microsoft Certification 1 2 (4.167 %) MCAD
System Software 1 4 (8.333 %) Active Directory 2 1 (2.083 %) MSMQ	Vendors 1 11 (22.92 %) Microsoft 2 9 (18.75 %) Sybase 3 6 (12.50 %) Adobe 4 3 (6.250 %) Oracle