Skip to main content

Posts

Showing posts from December, 2011

Happy New Year

Image: ponsuwan / FreeDigitalPhotos.netAs 2011 draws to a close and as people look forward to evening of partying and celebrating I’d just like to wish everyone a very happy, healthy and prosperous New Year.

Contracting is business not employment: Read the small print

This post is about a contracting in UK. Some of terms mentioned here will not mean a great deal to people who do not understand the mechanics of contracting or the UK tax systems.
I recently got sent an email by a friend and fellow contractor that contained a link to the following news article:
http://news.efinancialcareers.com/72048/the-outrageous-email-allegedly-sent-by-bank-of-america-merrill-lynch-to-its-contractors-in-london/
Feel free to go away and have a read of the article but the gist is this. A well known global financial institution has decided that its is possibly paying over the odds for its contractors and as such it is enforcing a 10% rate cut across the board in an effort to cut costs. It doesn’t want to lose the contractors but it does want to reduce the amount it pays for them and hence reduce the cost of the contractors.
The feeling of the comments left on the post seem to imply that people are outraged by such a move. The survey results seem to suggest opinion is spl…

Execute Permissions

Written by Ian TreasureGethyn posted on the use of execute permissions a while ago (db_executor at http://www.gethynellis.com/2010/04/dbexecutor-role.html). Briefly, this approach uses a role – db_Executor – to which users are given membership. The execute permission is granted to the role.

I am using this approach to control access to stored procedures. Some developers started to complain that they could not execute their stored procedures. The first thing that I did was to check if their user was a member of the db_Executor role. It was, which was a surprise. I then started to check that the role had executor permissions. This was not so easy to do.

After a little digging, I used sp_helpprotect as follows.

In SQL Server Management studio, I ran:

sp_helprotect 'execute'



This returns the following:

Msg 15330, Level 11, State 1, Procedure sp_helprotect, Line 291
There are no matching rows on which to report.

OK – now I know that the problem is because the database role does not have ex…

Contracting, SQL Server and gethynellis.com

A while back I started posting some contractor related articles.The articles were mainly for the those people that wanted to start their own business and work for themselves as a contractor. I work in the IT sector through my own company with several clients both based in the UK and across the pond in the US. I have been running my company and working for myself for almost five years now and I even through one of the most difficult economic times  in modern history I have thoroughly enjoyed it and I wouldn’t change  anything that has happened thus far.  A while back I started a new section of gethynellis.com that I intended to have a focus on contracting and also some career based themes. At the time I thought it would useful to split up the SQL Server content that usually gets published on gethynellis.com from the contractor/career type posts. This week for a number of reasons I have decided that was not such a good idea.My reasons for splitting at the time were simple, the two  peop…