Permanent IT Jobs Contract IT Jobs
Job Type
Source

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

LinkTransact-SQL (T-SQL)
Location
3 months to
29 Aug 2008
Same period last year
Rank3529
Rank change on same period last yearDown-6
Matching permanent IT job ads6058
As % of all UK permanent IT job ads sampled0.033 %0.024 %
As % of the category below9.934 %10.68 %
Salaries quoted4952
Average minimum salary£31,286£30,400
Average salary£32,959£32,909
% change on same period last year+0.15 %
Average maximum salary£34,633£35,418
UK excluding London average salary£35,069£35,683
% change on same period last year-1.72 %
Lancashire IT Job Market, Programming LanguagesProgramming Languages
Lancashire
Matching permanent IT job ads604543
As % of all UK permanent IT job ads sampled0.330 %0.228 %
Salaries quoted485450
Average minimum salary£28,012£29,297
Average salary£30,805£31,560
% change on same period last year-2.39 %
Average maximum salary£33,597£33,822
UK excluding London average salary£35,257£35,638
% change on same period last year-1.07 %
Transact-SQL North WestTransact-SQL
North West

Transact-SQL
Demand Trend

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

Lancashire Transact-SQL Demand Trend

Transact-SQL
Salary Trend

The chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Transact-SQL across the Lancashire region.

Lancashire Transact-SQL Salary Trend

Transact-SQL
Salary Histogram

The chart provides a salary histogram for IT jobs citing Transact-SQL across the Lancashire region over the 3 months to 29 August 2008.

Lancashire Transact-SQL Salary Histogram

Transact-SQL
Job Locations

This section looks at the demand and provides a guide to the average salaries quoted in IT jobs citing Transact-SQL within the Lancashire region over the 3 months to 29 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.

LocationRank Change
on Same Period
Last Last
Matching
Permanent
IT Job Ads
Average Salary
Last 3 Months
Average Salary
% Change
on Same Period
Last Year
PrestonUp+1038£33,568+3.28 %
BlackburnDown-82£29,500+9.25 %
BlackpoolNew entry-1£36,000-
Transact-SQL North WestTransact-SQL
North West

Transact-SQL
Top 30 Related IT Skills

For the 6 months to 29 August 2008, IT jobs across the Lancashire 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 IT job ads sampled that cited Transact-SQL.

1124 (100.00 %)SQL
2112 (90.32 %)SQL Server
380 (64.52 %).NET
467 (54.03 %)SQL Server 2000
559 (47.58 %)VB.NET
647 (37.90 %)VB
746 (37.10 %)ASP.NET
842 (33.87 %)XML
842 (33.87 %)SQL Server Reporting Services
935 (28.23 %)VB6
1034 (27.42 %)SQL Server 2005
1133 (26.61 %)C#
1230 (24.19 %)Crystal Reports
1329 (23.39 %)MS Excel
1428 (22.58 %)Microsoft
1525 (20.16 %)WebServices
1525 (20.16 %)JavaScript
1622 (17.74 %)Health
1720 (16.13 %)WinForms
1720 (16.13 %)N-Tier
1818 (14.52 %)Datawarehouse
1818 (14.52 %)AJAX
1917 (13.71 %)OO
2015 (12.10 %)Data Mining
2015 (12.10 %)ASP
2114 (11.29 %)Windows
2114 (11.29 %)Pharmaceutical
2114 (11.29 %)Unit Testing
2213 (10.48 %)SharePoint
2312 (9.677 %)CRM

Transact-SQL
Top Related IT Skills by Category

For the 6 months to 29 August 2008, IT jobs across the Lancashire 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 IT job ads sampled that cited Transact-SQL. Up to 20 skills are shown per category.

Lancashire IT Job Market, Application DevelopmentApplication Development
180 (64.52 %).NET
246 (37.10 %)ASP.NET
342 (33.87 %)XML
425 (20.16 %)WebServices
520 (16.13 %)WinForms
618 (14.52 %)AJAX
715 (12.10 %)ASP
810 (8.065 %)HTML
810 (8.065 %)COM+
98 (6.452 %)WCF
106 (4.839 %).NET Framework
106 (4.839 %)ASP.NET 2.0
115 (4.032 %)WF
124 (3.226 %)XHTML
124 (3.226 %)XSL
124 (3.226 %)COM
133 (2.419 %)XSLT
133 (2.419 %)EDI
142 (1.613 %)NHibernate
142 (1.613 %)MDX
Lancashire IT Job Market, Application PlatformsApplication Platforms
113 (10.48 %)SharePoint
27 (5.645 %)SharePoint Server 2007
33 (2.419 %)SharePoint Portal Server
33 (2.419 %)BizTalk Server
41 (0.806 %)CMS
41 (0.806 %)MS Exchange
Lancashire IT Job Market, ApplicationsApplications
129 (23.39 %)MS Excel
21 (0.806 %)MS Visio
21 (0.806 %)MS Office
Lancashire IT Job Market, Business ApplicationsBusiness Applications
12 (1.613 %)Dynamics CRM
Lancashire IT Job Market, Communications & NetworkingCommunications & Networking
110 (8.065 %)Internet
23 (2.419 %)Intranet
Lancashire IT Job Market, Database & Business IntelligenceDatabase & Business Intelligence
1112 (90.32 %)SQL Server
267 (54.03 %)SQL Server 2000
342 (33.87 %)SQL Server Reporting Services
434 (27.42 %)SQL Server 2005
530 (24.19 %)Crystal Reports
618 (14.52 %)Datawarehouse
715 (12.10 %)Data Mining
88 (6.452 %)SQL Server Integration Services
96 (4.839 %)SQL Server Analysis Services
105 (4.032 %)BusinessObjects
105 (4.032 %)DTS
113 (2.419 %)OLAP
113 (2.419 %)ETL
121 (0.806 %)Microsoft Analysis Services
121 (0.806 %)Data Cleansing
Lancashire IT Job Market, Development ApplicationsDevelopment Applications
17 (5.645 %)Visual Studio
17 (5.645 %)VSS/SourceSafe
17 (5.645 %)InstallShield
24 (3.226 %)NUnit
Lancashire IT Job Market, GeneralGeneral
122 (17.74 %)Health
214 (11.29 %)Pharmaceutical
312 (9.677 %)Retail
410 (8.065 %)Finance
56 (4.839 %)Pensions
64 (3.226 %)Auditing
73 (2.419 %)Insurance
81 (0.806 %)Marketing
81 (0.806 %)Publishing
Lancashire IT Job Market, Job TitlesJob Titles
193 (75.00 %)Developer
232 (25.81 %).NET Developer
318 (14.52 %)C# Developer
416 (12.90 %)Analyst
515 (12.10 %)VB Developer
614 (11.29 %)VB.NET Developer
713 (10.48 %)SQL Developer
812 (9.677 %)Analyst Programmer
812 (9.677 %)Programmer
910 (8.065 %)Software Developer
108 (6.452 %)Web Developer
117 (5.645 %)DBA
117 (5.645 %)Database Developer
117 (5.645 %)VB Analyst Programmer
117 (5.645 %)SharePoint Developer
126 (4.839 %)Web Analyst
126 (4.839 %)Web Programmer
126 (4.839 %)SQL DBA
126 (4.839 %)SQL Server DBA
135 (4.032 %)Database Analyst
Lancashire IT Job Market, MiscellaneousMiscellaneous
120 (16.13 %)N-Tier
23 (2.419 %)Clustering
31 (0.806 %)Management Information System
31 (0.806 %)Replication
Lancashire IT Job Market, Operating SystemsOperating Systems
114 (11.29 %)Windows
21 (0.806 %)Windows 2000
Lancashire IT Job Market, Processes & MethodologiesProcesses & Methodologies
117 (13.71 %)OO
214 (11.29 %)Unit Testing
312 (9.677 %)CRM
410 (8.065 %)E-Commerce
410 (8.065 %)UML
58 (6.452 %)OOP
58 (6.452 %)OOA/OOD
66 (4.839 %)Web Development
75 (4.032 %)Workflow
75 (4.032 %)Configuration Management
83 (2.419 %)SEO
92 (1.613 %)Data Analysis
92 (1.613 %)Security Management
92 (1.613 %)Disaster Recovery
92 (1.613 %)ERP
101 (0.806 %)GAP Analysis
101 (0.806 %)ITIL
101 (0.806 %)Migration
101 (0.806 %)Content Management
101 (0.806 %)WFM
Lancashire IT Job Market, Programming LanguagesProgramming Languages
1124 (100.00 %)SQL
259 (47.58 %)VB.NET
347 (37.90 %)VB
435 (28.23 %)VB6
533 (26.61 %)C#
625 (20.16 %)JavaScript
75 (4.032 %)VBA
84 (3.226 %)PL/SQL
84 (3.226 %)Delphi
93 (2.419 %)C++
102 (1.613 %)VBScript
Lancashire IT Job Market, QualificationsQualifications
111 (8.871 %)Degree
26 (4.839 %)Microsoft Certification
33 (2.419 %)MCDBA
33 (2.419 %)MCITP
42 (1.613 %)MCTS
42 (1.613 %)MCP
51 (0.806 %)MCAD
51 (0.806 %)MCSE
51 (0.806 %)MCSA
51 (0.806 %)Cisco Certification
Lancashire IT Job Market, Quality Assurance & ComplianceQuality Assurance & Compliance
11 (0.806 %)QA
Lancashire IT Job Market, System SoftwareSystem Software
18 (6.452 %)MSMQ
21 (0.806 %)Active Directory
Lancashire IT Job Market, VendorsVendors
128 (22.58 %)Microsoft
25 (4.032 %)Business Objects
31 (0.806 %)Cisco
31 (0.806 %)IBM