The following table provides summary statistics for permanent job vacancies advertised in Portsmouth with a requirement for T-SQL skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited T-SQL over the 3 months to 25 March 2017 with a comparison to the same period in the previous 2 years.

3 months to
25 Mar 2017
Same period 2016 Same period 2015
Transact-SQL
Hampshire / Portsmouth
Rank 42 28 22
Rank change year-on-year -14 -6  
Permanent jobs citing T-SQL 9 19 38
As % of all permanent IT jobs advertised in Portsmouth 2.84% 7.25% 12.34%
As % of the Programming Languages category 4.48% 11.05% 18.18%
Number of salaries quoted 9 19 38
Median salary £35,000 £45,000 £34,500
Median salary % change year-on-year -22.22% +30.43%  
90% offered a salary of more than £30,750 £40,800 £28,200
10% offered a salary of more than £50,500 £58,500 £58,250
UK excluding London median salary £40,000 £40,000 £40,000

T-SQL is in the programming language skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Portsmouth with a requirement for programming language skills.

Programming Language Skills
Portsmouth
Permanent job vacancies with a requirement for programming language skills 201 172 209
As % of all permanent IT job vacancies advertised in Portsmouth 63.41% 65.65% 67.86%
Number of salaries quoted 176 166 200
Median salary £42,500 £40,000 £40,000
Median salary % change year-on-year +6.25% -  
90% offered a salary of more than £30,000 £32,500 £28,500
10% offered a salary of more than £49,750 £50,450 £52,500
UK excluding London median salary £41,500 £40,500 £40,000
% change year-on-year +2.46% +1.25%  

T-SQL
Job Vacancy Trend in Portsmouth

The job posting trend of jobs advertised in Portsmouth citing T-SQL as a proportion of all permanent or contract IT jobs with a match in the Programming Languages category.

Job vacancy trend for T-SQL in Portsmouth

T-SQL
Salary Trend in Portsmouth

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing T-SQL in Portsmouth.

Salary trend for T-SQL in Portsmouth

T-SQL
Salary Histogram in Portsmouth

The salary distribution of IT jobs citing T-SQL in Portsmouth over the 3 months to 25 March 2017.

Salary histogram for T-SQL in Portsmouth

T-SQL
Top 30 Related IT Skills in Portsmouth

For the 6 months to 25 March 2017, IT jobs citing T-SQL also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the Portsmouth region with a requirement for T-SQL.

1 48 (100.00%) SQL
2 38 (79.17%) C#
3 37 (77.08%) .NET
4 35 (72.92%) ASP.NET
5 34 (70.83%) SQL Server
6 28 (58.33%) MVC
7 21 (43.75%) Agile Software Development
8 20 (41.67%) JavaScript
9 18 (37.50%) HTML
9 18 (37.50%) Team Foundation Server
10 17 (35.42%) CSS
11 16 (33.33%) ASP.NET Web Forms
12 14 (29.17%) Unit Testing
12 14 (29.17%) Scrum
13 13 (27.08%) Microsoft
14 12 (25.00%) SOLID
15 11 (22.92%) Business Intelligence
16 9 (18.75%) Front End Development
16 9 (18.75%) ASP.NET MVC
17 8 (16.67%) SQL Server Reporting Services
17 8 (16.67%) SQL Server Integration Services
18 6 (12.50%) ETL
18 6 (12.50%) Telecoms
18 6 (12.50%) VB.NET
19 5 (10.42%) Data Warehouse
19 5 (10.42%) SQL Server Analysis Services
20 4 (8.33%) Windows
21 3 (6.25%) MDX
21 3 (6.25%) CRM
21 3 (6.25%) Mentoring

T-SQL
Top Related IT Skills in Portsmouth by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same job type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 2 (4.17%) CMS
2 1 (2.08%) IIS
Applications
1 1 (2.08%) MS Excel
Communications & Networking
1 1 (2.08%) Remote Desktop
Database & Business Intelligence
1 34 (70.83%) SQL Server
2 8 (16.67%) SQL Server Integration Services
2 8 (16.67%) SQL Server Reporting Services
3 5 (10.42%) Data Warehouse
3 5 (10.42%) SQL Server Analysis Services
4 3 (6.25%) SQL Server 2016
5 2 (4.17%) Big Data
5 2 (4.17%) OLAP
5 2 (4.17%) OLAP Cube
5 2 (4.17%) Relational Database
5 2 (4.17%) SQL Server 2012
5 2 (4.17%) SQL Server 2014
6 1 (2.08%) Crystal Reports
6 1 (2.08%) SQL Server 2008
Development Applications
1 18 (37.50%) Team Foundation Server
2 2 (4.17%) Selenium
2 2 (4.17%) Visual Studio
General
1 6 (12.50%) Telecoms
2 2 (4.17%) Advertising
2 2 (4.17%) Finance
Job Titles
1 40 (83.33%) Developer
2 28 (58.33%) C# Developer
3 25 (52.08%) .NET Developer
4 22 (45.83%) ASP.NET Developer
4 22 (45.83%) C# .NET Developer
4 22 (45.83%) C# ASP.NET Developer
4 22 (45.83%) SQL Developer
5 15 (31.25%) T-SQL Developer
6 12 (25.00%) Software Developer
7 7 (14.58%) C# Software Developer
8 4 (8.33%) SQL Server Developer
9 3 (6.25%) .NET Software Developer
9 3 (6.25%) ASP.NET MVC Developer
10 2 (4.17%) Business Intelligence Analyst
10 2 (4.17%) C# VB.NET Developer
10 2 (4.17%) Junior ASP.NET Developer
10 2 (4.17%) Junior C# ASP.NET Developer
10 2 (4.17%) SQL Analyst
10 2 (4.17%) VB.NET Developer
10 2 (4.17%) VB.NET/ASP.NET Developer
Libraries, Frameworks & Software Standards
1 37 (77.08%) .NET
2 35 (72.92%) ASP.NET
3 18 (37.50%) HTML
4 17 (35.42%) CSS
5 16 (33.33%) ASP.NET Web Forms
6 9 (18.75%) ASP.NET MVC
7 3 (6.25%) MDX
8 2 (4.17%) .NET Framework
9 1 (2.08%) AngularJS
9 1 (2.08%) Entity Framework
9 1 (2.08%) jQuery
9 1 (2.08%) LINQ
9 1 (2.08%) NHibernate
9 1 (2.08%) WCF
9 1 (2.08%) WinForms
9 1 (2.08%) WPF
Miscellaneous
1 2 (4.17%) Analytical Skills
2 1 (2.08%) Computer Science
Operating Systems
1 4 (8.33%) Windows
2 2 (4.17%) Windows Server
Processes & Methodologies
1 28 (58.33%) MVC
2 21 (43.75%) Agile Software Development
3 14 (29.17%) Scrum
3 14 (29.17%) Unit Testing
4 12 (25.00%) SOLID
5 11 (22.92%) Business Intelligence
6 9 (18.75%) Front End Development
7 6 (12.50%) ETL
8 3 (6.25%) CRM
8 3 (6.25%) Mentoring
9 2 (4.17%) Analytics
9 2 (4.17%) Content Management
9 2 (4.17%) Dimensional Modelling
9 2 (4.17%) Disaster Recovery
9 2 (4.17%) Performance Monitoring
9 2 (4.17%) Process Improvement
9 2 (4.17%) Software Engineering
9 2 (4.17%) Web Development
10 1 (2.08%) Dependency Injection
10 1 (2.08%) TDD
Programming Languages
1 48 (100.00%) SQL
2 38 (79.17%) C#
3 20 (41.67%) JavaScript
4 6 (12.50%) VB.NET
5 1 (2.08%) XAML
Qualifications
1 1 (2.08%) Degree
Quality Assurance & Compliance
1 1 (2.08%) Data Quality
Systems Management
1 2 (4.17%) SQL Sentry
Vendors
1 13 (27.08%) Microsoft