Monday, 12 November 2018

A New Video - Create a DB Executor Role

A long long time ago, I wrote a blog post showing how to create db_executor role in SQL Server. There is a reader and a writer role but no execute role. So if you wanted a role that allowed you grant execute to all stored procedures and functions in a SQL Server database, you need to create a user-defined role

That blog post is the most read post on my blog even if it is nearly nine years old. So I decided to make a YouTube video from it

I won't re-post the original blog, I'll leave that back in 2010 but I have updated the old blog post to include the video and you can also watch the video here too.


Thursday, 4 October 2018

Sharding: Horizontal Scaling in Azure SQL Database

David has produced a talk all about Sharding. Or if you prefer  horizontally scaling your Azure SQL database.

You can view the talk below, its about 45 minutes long and looks at all the aspects of what you need to do to "shard" Azure SQL Database


If you want to follow along with David's demo you can download his example scripts and files here.

Friday, 10 August 2018

Money Ball: Fantasy Football Kicks Off Tonight - Jeff's Degenerates

You might think that this blog post is out of place here but I'm hoping use some of the data that is  freely available on the internet to demonstrate some of the features of  R and data analysis so please hold in there and its a little break from the norm too

Fantasy Football

I have been persuaded for the first time since I was a young lad to enter a fantasy football team and in doing so I have ended up  entering several private leagues with different groups of friends. There is very little money involved and this is very much just for fun. The last time I entered one of these was before the internet was widespread back in the 1990s. To enter the game you had a buy a national newspaper enter your details on a coupon and mail it in - I don't think transfers and substitutions were even possible back then. How  times have changed since then... Actually the competition is quite fierce and with the internet you now have full control of you team and your squad and can make changes pretty frequently within the rules to you entered team.

I'm playing on the https://fantasy.premierleague.com/ website my team name is Jeff's Degenerates and  there seems to be lots of people who  seem to be having a go at being the next, Pep, Klopp or Jose.

I'll keep you posted of the progress as the season progresses - This is my starting 11 for this week's games with some manual data analysis used during the team selection based of last season's players points total

Jeff's Degenerates Starting 11 

Super 6

In slight variant on the fantasy football I've also entered a super 6 league. The gist of this is where you predict the scores of 6 games playing on a Saturday afternoon. You get awarded points for the correct result and more points  if you get the correct score.

I think had a little bit of beginners luck last week there was no data analysis used at all, it was the first games of the season and there was no recent form to go on - I got 4/6 results 3 with the correct score, giving me a total 17 points. I'm not sure how many people play the competition I'm told its at least 10,000 maybe even 100,000. It could be more than that. Anyway my 17 points left me 638 spot across every player -  5 x 3 for the correct score and 2 points  for the correct result

Super 6 - Week 1 scores 


These are the scores I have gone with for this week


I'll try and remember to update you how I get on.

Monday, 16 April 2018

Free Session, Free Beer, Free Food - # Not the GDPR News

This is a final call for attendees. We are have the last few seats available in out #Not the GDPR news - Why projects fail seminar that is taking place in Cardiff on Thursday evening



Wonder why projects fail? Want to spot the signs of failure? Want to know how to turn failure into success? CPS Group are hosting an Interactive Seminar with Wyeden’s Mark Williams & Gethyn from gethynellis.com (40+ years project experience between them). Wyenot come along, enjoy some drinks & food, chat with peer’s, listen & join in as you wish…& have fun? 

If you fancy some free beer, free food and a free seminar why not join Mark Williams and myself this Thursday evening. It is free for you to register...click  the link which will take you to the EventBrite website. Your name and email address is all you need to register. 

Oh and you'll get to see what this face was all about


Monday, 9 April 2018

# Not the GDPR News -t minus 10 days

# Not the GDPR News -t minus 10 days

There is ten days to go and there are still some seats left for our #Not the GDPR news - a session on turning around failing projects.

Mark Williams and myself will delivering the session in Cardiff on the 19th April... in 10 days time! 


#Not the GDPR News

Please note that this is not a session on GDPR!

This is the session abstract

Wonder why projects fail? Want to spot the signs of failure? Want to know how to turn failure into success? CPS Group are hosting an Interactive Seminar with Wyeden’s Mark Williams & Gethyn from gethynellis.com (40+ years project experience between them). Wyenot come along, enjoy some drinks & food, chat with peer’s, listen & join in as you wish…& have fun? 

It is free for you to register...click  the link which will take you to the EventBrite website. Your name and email address is all you need to register. If you register and come along to the session on 19th you'll not only get a great session but there will be some free drinks (beers and soft drinks) and nibbles too. 

If you know someone, a friend of colleague who would also enjoy this session feel free to forward it on to them.

Tuesday, 3 April 2018

Why Projects Fail...Free Session, Free Beer and Free Food

Why Projects Fail...Free Session, Free Beer and Free Food 

Mark Williams and myself will delivering a seminar called #Not the GDPR news in Cardiff on the 19th April...



#Not the GDPR News

This is not a session on GDPR!


This is the session abstract



Want to do The Right Things? Want to do Things Right? Want to make something happen successfully? Well…why don’t you come along to CPSGroup, Cardiff, Thursday 19th April and hear & join in with Wyeden’s Mark Williams and Gethyn Ellis from gethynellis.com, get 40+ years of project experience distilled into one evening, as they discuss and facilitate comment with you and your peers? Book here Interested but can’t make it? Register here, webinar to follow later in year.

It is free for you to register...click  the link which will take you to the EventBrite website. Your name and email address is all you need to register. If you register and come along to the session on 19th you'll not only get a great session but there will be some free drinks (beers and soft drinks) and nibbles too.

If you know someone, a friend of colleague who would also enjoy this session feel free to forward it on to them.

Monday, 26 March 2018

PROJECT LIFE LESSONS - # Not The GDPR News

PROJECT LIFE LESSONS - # Not The GDPR News

Mark Williams and myself will delivering a seminar called #Not the GDPR news in Cardiff on the 19th April...


#Not the GDPR News

This is not a session on GDPR!

PROJECT LIFE LESSONS - Come along to CPSGroup offices in central Cardiff, network with fellow professionals, listen and participate with Mark Williams and Gethyn Ellis as they discuss 40+ years of project life lessons experience, remind yourself of what should be done and/or take the best practice back into your business. Applies to Business Directors, Managers, Project Managers & Analysts, Developers, Testers and anyone with an interest in IT or Business Change projects. 19/04/18 @ CPSGroup Cardiff

It is free for you to register...click  the link which will take you to the EventBrite website. Your name and email address is all you need to register. If you register and come along to the session on 19th you'll not only get a great session but there will be some free drinks (beers and soft drinks) and nibbles too.

If you know someone, a friend of colleague who would also enjoy this session feel free to forward it on to them.

Featured post

Creating a Linked Server to an Azure SQL Database

Why would you create a Linked Server to an Azure SQL Database? If you work in a hybrid environment with some databases stored on your on ...