The following table provides summary statistics for permanent job vacancies advertised in Edinburgh with a requirement for SQL Server 2005 skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited SQL Server 2005 over the 3 months to 26 June 2017 with a comparison to the same period in the previous 2 years.

Microsoft SQL Server 2005
Scotland / Edinburgh
3 months to
26 Jun 2017
Same period 2016 Same period 2015
Rank 98 94 103
Rank change year-on-year -4 +9  
Permanent jobs citing SQL Server 2005 2 1 4
As % of all permanent IT jobs advertised in Edinburgh 0.16% 0.084% 0.28%
As % of the Database & Business Intelligence category 0.50% 0.31% 0.98%
Number of salaries quoted 2 1 4
Median salary £72,500 £47,500 £62,500
Median salary % change year-on-year +52.63% -24.00%  
UK excluding London median salary £45,000 £41,000 £40,000
% change year-on-year +9.75% +2.50%  

SQL Server 2005 is in the database and business intelligence skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Edinburgh with a requirement for database and business intelligence skills.

Database & Business Intelligence Skills
Edinburgh
Permanent job vacancies with a requirement for database and business intelligence skills 403 325 409
As % of all permanent IT job vacancies advertised in Edinburgh 32.42% 27.40% 29.05%
Number of salaries quoted 265 166 255
Median salary £40,500 £45,000 £44,000
Median salary % change year-on-year -10.00% +2.27%  
90% offered a salary of more than £32,500 £30,000 £29,000
10% offered a salary of more than £65,000 £62,500 £67,500
UK excluding London median salary £42,500 £42,500 £41,500
% change year-on-year - +2.40%  

SQL Server 2005
Job Vacancy Trend in Edinburgh

The job posting trend of jobs advertised in Edinburgh citing SQL Server 2005 as a proportion of all permanent or contract IT jobs with a match in the Database & Business Intelligence category.

Job vacancy trend for SQL Server 2005 in Edinburgh

SQL Server 2005
Salary Trend in Edinburgh

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing SQL Server 2005 in Edinburgh.

Salary trend for SQL Server 2005 in Edinburgh

For the 6 months to 26 June 2017, IT jobs citing SQL Server 2005 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 Edinburgh region with a requirement for SQL Server 2005.

1 12 (100.00%) SQL Server
2 9 (75.00%) SQL Server 2014
3 8 (66.67%) SQL
3 8 (66.67%) Microsoft
4 7 (58.33%) Active Directory
4 7 (58.33%) Citrix
4 7 (58.33%) CA
4 7 (58.33%) Symantec
4 7 (58.33%) Blackberry
4 7 (58.33%) Blackberry Enterprise Server
4 7 (58.33%) VMware
4 7 (58.33%) Windows
4 7 (58.33%) Linux
4 7 (58.33%) MS Exchange
4 7 (58.33%) LAN
4 7 (58.33%) WAN
4 7 (58.33%) DHCP
4 7 (58.33%) DNS
4 7 (58.33%) Cisco
4 7 (58.33%) Microsoft App-V
4 7 (58.33%) Ubuntu
4 7 (58.33%) SCCM
4 7 (58.33%) SCOM
4 7 (58.33%) Microsoft Azure
4 7 (58.33%) Amazon AWS
4 7 (58.33%) Puppet
4 7 (58.33%) VMware ESXi
4 7 (58.33%) Skype for Business
4 7 (58.33%) Exchange Server 2010
4 7 (58.33%) Hyper-V

SQL Server 2005
Co-occurring IT Skills in Edinburgh 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 7 (58.33%) Blackberry Enterprise Server
1 7 (58.33%) Exchange Server 2010
1 7 (58.33%) MS Exchange
1 7 (58.33%) Skype for Business
2 1 (8.33%) SAS
Applications
1 1 (8.33%) Microsoft Office
Cloud Services
1 7 (58.33%) Amazon AWS
1 7 (58.33%) Microsoft Azure
1 7 (58.33%) Office 365
Communications & Networking
1 7 (58.33%) DHCP
1 7 (58.33%) DNS
1 7 (58.33%) LAN
1 7 (58.33%) WAN
Database & Business Intelligence
1 12 (100.00%) SQL Server
2 9 (75.00%) SQL Server 2014
3 4 (33.33%) SQL Server 2008
4 1 (8.33%) Big Data
4 1 (8.33%) Hadoop
4 1 (8.33%) SQL Server 2000
4 1 (8.33%) SQL Server 2012
General
1 6 (50.00%) Finance
2 3 (25.00%) Local Government
Job Titles
1 4 (33.33%) Developer
2 3 (25.00%) .NET Developer
2 3 (25.00%) .NET Software Developer
2 3 (25.00%) Software Developer
3 1 (8.33%) Data Engineer
3 1 (8.33%) DBA
3 1 (8.33%) Infrastructure Engineer
3 1 (8.33%) SAS Developer
Libraries, Frameworks & Software Standards
1 4 (33.33%) .NET
2 3 (25.00%) .NET Framework
2 3 (25.00%) ASP.NET
2 3 (25.00%) WCF
3 1 (8.33%) REST
Miscellaneous
1 7 (58.33%) Blackberry
1 7 (58.33%) Data Centre
2 1 (8.33%) Analytical Skills
2 1 (8.33%) Mainframe
Operating Systems
1 7 (58.33%) Linux
1 7 (58.33%) Ubuntu
1 7 (58.33%) Windows
2 1 (8.33%) MVS
Processes & Methodologies
1 7 (58.33%) Root Cause Analysis
2 6 (50.00%) Asset Management
2 6 (50.00%) Investment Management
2 6 (50.00%) IT Strategy
2 6 (50.00%) Translating Business Requirements
3 3 (25.00%) Agile Software Development
3 3 (25.00%) MVC
3 3 (25.00%) Software Engineering
4 1 (8.33%) ETL
Programming Languages
1 8 (66.67%) SQL
2 7 (58.33%) PowerShell
3 4 (33.33%) C#
4 1 (8.33%) C
4 1 (8.33%) C++
4 1 (8.33%) Java
4 1 (8.33%) MATLAB
4 1 (8.33%) R
4 1 (8.33%) T-SQL
4 1 (8.33%) VB
System Software
1 7 (58.33%) Active Directory
1 7 (58.33%) Hyper-V
1 7 (58.33%) Microsoft App-V
1 7 (58.33%) VMware ESXi
1 7 (58.33%) VMware Infrastructure
1 7 (58.33%) XenApp
1 7 (58.33%) XenDesktop
Systems Management
1 7 (58.33%) Ansible
1 7 (58.33%) Opscode Chef
1 7 (58.33%) Puppet
1 7 (58.33%) SCCM
1 7 (58.33%) SCOM
1 7 (58.33%) Symantec Endpoint Protection
1 7 (58.33%) Symantec Enterprise Vault
Vendors
1 8 (66.67%) Microsoft
2 7 (58.33%) CA
2 7 (58.33%) Cisco
2 7 (58.33%) Citrix
2 7 (58.33%) Symantec
2 7 (58.33%) Varonis
2 7 (58.33%) VMware