Skip to main content

UK Budget 2017 – The Death Knell for Small Business?

Well I suspect not however I suspect it will likely have a major impact. What has this got to do with SQL and Data I hear you ask? I’m going to provide a little background first. Over the last week or so it has been an interesting political week here in the UK. We had the annual government budget statement. This is where the government gives us an update on the overall financial health of the economy/country and introduces policy changes, around things like taxation and how the tax monies will be spent.  Throw that into the mix, Brexit and the triggering of article 50 looks imminent at the time of writing.

If you work as an IT Contractor or consultant running a business in the IT field, you are likely to be affected by some of the changes announced to the tax system in the recent budget. For example,if you run a limited company another huge cut in dividend relief, following on from the cut that came into effect in April 2016. All in all, if you are self-employed or run a company you will be likely to pay more tax.

 If you run a business through a limited company, the amount of money you can take in dividends without paying tax has been reduced by more than a half from £5000 to £2000. So limited company directors will pay more tax on what they take from their company. This is the second time in the space of a year this figure has changed.

What I wanted to do though was look at how these economic decisions can impact on the business community.

This got me thinking about what data would be available in this area. The UK government makes many of its data sets available, for free online. In this post we’ll look at using the Companies House data set that you can download from https://data.gov.uk/.

More Self-employed people

One of the arguments for the changes, is that these days there are most self-employed people. Is this true? I suspect so. Most IT contractors and consultants operate through a limited company. There are many reasons that IT contractors make this decision in running their business that are outside the scope of this post. But has there been an increase in the number of IT contractor’s operating through a limited company?

Companies house is the government department/organization  that is responsible for registering companies in the UK, makes part of its data set available free, that you can download. You can get it from the data.gov.uk website. It comes in a set of CSV file. I downloaded these and imported them into may favorite database SQL Server using SSIS. See the link?

I wanted to look at whether the number of registered companies that work in the IT area had increased over time. I ran a query that pulled out all the companies with a Standard Industry Classification (SIC) code that contained Information technology in the description. 

It turns out there are two codes in use:

62020 - Information technology consultancy activities
62090 - Other information technology service activities

I also wanted only the companies that had been created since 1990 – so we can see how the figures have changed over the last 30 years. Just note, I am just looking at companies that have been created in the time frame – this doesn’t mean that the company is still active or ever was active it could have always been dormant, but someone took the time to register a company with that SIC during this time

I imported the companies house data into a SQL Server database table called CompanyData.

This is my query for extracting number of IT companies created each year

-->
SELECT YEAR(IncorporationDate) as Yr
,COUNT (*) AS NoOfCompsCreated
 FROM CompanyData
WHERE YEAR (IncorporationDate) > 1990
AND ( [SICCode SicText_1] = '62020 - Information technology consultancy activities'
OR [SICCode SicText_1] = '62090 - Other information technology service activities')
Group by YEAR (IncorporationDate)
ORDER BY Yr


-->
I grouped by year of incorporation to break the count down by year. I also wanted to play with Power BI to do some visualization. 




The results are very interesting since 1990, and since around about 2010 in particular there has been a huge increase in the number of IT related companies registered with companies house. Maybe more people are slef-employed.

-->
How does the budget policy and other poltical decisions impact on  you can see, 2016 saw a dramatic drop in the number of IT companies created.  You can see a snippet of the queries results below:



2016 saw just over 15000 IT companies registered at Companies house, compared with over 25000 in 2015 and over 21000 in 2014. Quite a drop in the number of new companies created. Approximately 10000 less companies created in 2016 compared to the year previous. You can see on the graph how the financial crisis of 2007/2008 and 2009 had an impact on IT company creation too, perhaps not as dramatic. As what happened in 2016…A major change in dividend tax and of course everyone’s favorite Brexit!

-->
In the next post we’ll drill into these figures a little more to see if you can decide if it was Brexit, the dividend tax change or something else that caused the decline in company creation.

If you want to learn how to write SQL queries like the ones used in this post, check out our IT Training page 


Comments

Popular posts from this blog

SQL Server 2012 and Virtual Service Accounts

This post is written by David Postlethwaite
If you are using SQL Server 2012 you will probably have noticed that the default account for the SQL services has changed from that used in previous versions. With SQL 2005 and 2008 the default account for SQL service and SQL Agent service was “NT Authority\System”. This is one the built in accounts on a Windows machine, managed by the machine and selectable from a dedicated dropdown list

The Network Service account was introduced in Windows 2003 as an alternative to using the LocalSystem account, which has full local system privileges on the local machine, a major security concern.
The Network Service has limited local privileges easing these security concerns but when many services on a machine use the Network Service account it becomes harder to track which service is actually accessing resources and performing actions, because all the services are using the one Network Service account.
Also, this account, by default, has sysadmin per…

Always Encrypted

By David Postlethwaite

Always Encrypted is new features in SQL Server 2016 and it is also available in Azure SQL Database. Here you can encrypt columns in a table with a master key and a certificate so that they will appear as encrypted strings to those who don’t have the required certificate installed on their pc.
Once the certificate is installed on the computer then the unencrypted data can then be seen as normal.

The data passes from database to your application as the encrypted value, only the application with the correct certificate can unencrypt the data so it is secure across the wire. This will go some way to resolving the concern of people worried about putting their sensitive data on a shared server in the cloud such as Microsoft Azure and accessing the data across the Internet.

At the time of writing Always Encrypted is only supported with ADO.NET 4.6, JDBC 6.0 and ODBC 13.1 but expect other driver to become available.

The calling application (including SSMS) must also hav…

New in SQL Server 2017: Graph Databases

David has recorded and published a video of his presentation on SQL Server Graph Database. In his video which you can watch below, David provides an excellent introduction into SQL Server 2017 Graph Databases. In his presentation he looks at Tennis results at tournaments for  his favourite player "The Fed"  Rodger Federer.

David  shows how to set up graph database and work with them in SQL Server 2017.

Graph Database is not new. Other vendors have had graph database capabilities for some time so Microsoft are quite late to the market. In David presentation it appears that Microsoft have done a reasonable job of implementing some of the graph database features but he does point some of the limitations of the Microsoft product too and suggests that it is not ready for production yet but Microsoft seem serious about this feature.

Please watch the video and feel free to leave a comment or feedback - David is delivering a version of this talk on Graph databases in SQL Saturday Ka…