-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Fun Time Friday: New Year! Drones, Autism and SQL Server 2008

Welcome to the first Fun Time Friday of 2019 and with that I'd like to wish a very Happy New Year to our friends, customers and clients.

SQL Server 2008 is Out of Support July 2019


We have taken down the Christmas tree here at gethynellis.com and started back to…

Read more

1 comments, 163 reads

Posted in The SQL DBA in the UK on 4 January 2019

SQL Server 2008 and SQL Server 2008 R2 - OUT of SUPPORT July 2019

Both SQL Server 2008 and SQL Server 2008 R2 go out of extended support with Microsoft in July 2019. That’s fast approaching and as we enter the new year maybe you are thinking of upgrading your legacy SQL Server to later and greater versions? In this post and video  I’ll…

Read more

0 comments, 125 reads

Posted in The SQL DBA in the UK on 2 January 2019

Fun Time Friday: Black Friday, Mad Friday, Frantic Friday or Black Eye Friday

Black Friday (No,not Shopping!), Mad Friday, Frantic Friday or Black Eye Friday is a nickname for the last Friday before Christmas (Today!) in the United Kingdom.

It is the most popular night for office  Christmas parties, which consequently makes it one of the busiest nights in the year for ambulances…

Read more

0 comments, 124 reads

Posted in The SQL DBA in the UK on 21 December 2018

Fun time Friday - A week is a long time in....

A week is a long time in...

SQL Server Land

A week is a long time in SQL Server land. This week I have been busy working on a version migration for one particular customer and looking at security, 'productionising' some servers and troubleshooting connectivity issues for another. As is…

Read more

1 comments, 126 reads

Posted in The SQL DBA in the UK on 14 December 2018

Fun-time Friday - Data outages, Security Breaches and Brexit

It’s been an interesting week here at gethynellis.com. We have been busy with a SQL Server version upgrade for a customer, the new solution combining Always On Availability Groups and merge replication. We have also been helping a customer with some on premises  SQL Server builds,  creating a new…

Read more

0 comments, 1,863 reads

Posted in The SQL DBA in the UK on 7 December 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…

Read more

2 comments, 1,741 reads

Posted in The SQL DBA in the UK on 12 November 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…

Read more

0 comments, 2,325 reads

Posted in The SQL DBA in the UK on 4 October 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…

Read more

0 comments, 240 reads

Posted in The SQL DBA in the UK on 10 August 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…

Read more

0 comments, 287 reads

Posted in The SQL DBA in the UK on 16 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…

Read more

0 comments, 257 reads

Posted in The SQL DBA in the UK on 9 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...




This is not a session on GDPR!


This is the session abstract



Want to do The Right Things? Want to do Things…

Read more

0 comments, 276 reads

Posted in The SQL DBA in the UK on 3 April 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...



This is not a session on GDPR!

PROJECT LIFE LESSONS - Come along to CPSGroup offices in central Cardiff, network with fellow…

Read more

0 comments, 271 reads

Posted in The SQL DBA in the UK on 26 March 2018

Recruitment Agents are not bad people...despite what you might read

Welcome to WIN at IT contracting: A FREE guide showing YOU How to get the most out of Recruitment Agent Relationships. My name is Gethyn Ellis I have been running a SQL Server consulting and training practice for the last ten years. You can check out my website and blog…

Read more

0 comments, 318 reads

Posted in The SQL DBA in the UK on 22 March 2018

An Introduction to Enterprise Architecture

An Introduction to Enterprise Architecture

In this series I’m going to be looking at enterprise architecture. Over the last few years many of the projects that I have been involved with have involved complex digital transformation for large organisations. Delivering change in a large organisation can be a complicated and…

Read more

0 comments, 332 reads

Posted in The SQL DBA in the UK on 20 March 2018

# Not the GDPR News

# Not the GDPR News

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



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…

Read more

2 comments, 315 reads

Posted in The SQL DBA in the UK on 19 March 2018

Why contractors need recruitment agents?


Welcome to WIN at IT contracting: A FREE guide showing YOU How to get the most out of Recruitment Agent Relationships. My name is Gethyn Ellis I have been running a SQL Server consulting and training practice for the last ten years. You can check out my website and blog…

Read more

0 comments, 241 reads

Posted in The SQL DBA in the UK on 15 March 2018

Allowing Azure Service to Connect to your Azure SQL server.

Allowing Azure Service to Connect to your Azure SQL server.

In this video David will look at the impact of allowing you Azure SQL databases to work with other Azure services and the knock of effect of setting the option "Allow Access to Other Azure Services".



In short, setting this…

Read more

1 comments, 1,660 reads

Posted in The SQL DBA in the UK on 13 March 2018

Win at IT Contracting: The recruitment Agent Business Model

WIN at IT contracting: A FREE guide showing YOU How to get the most out of Recruitment Agent Relationships

Welcome to WIN at IT contracting: A FREE guide showing YOU How to get the most out of Recruitment Agent Relationships. My name is Gethyn Ellis I have been running a…

Read more

0 comments, 477 reads

Posted in The SQL DBA in the UK on 8 March 2018

Identify the owner and then change the owner of a SQL Agent Job


In this post and video you will learn how to identify the owner and then change the owner of a SQL Agent Job.



Have you ever had issues where the owner of a SQL Agent job leaves and their windows active directory account gets deleted/removed/disabled and the job(s) they own…

Read more

2 comments, 2,378 reads

Posted in The SQL DBA in the UK on 6 March 2018

What do recruitment agents do for contractors?

WIN at IT contracting: A FREE guide showing YOU How to get the most out of Recruitment Agent Relationships

Are you a contractor or thinking about starting a contracting business? Are you an IT contractor running your own business already, but don’t quite understand the agent/contractor relationship and how it…

Read more

0 comments, 333 reads

Posted in The SQL DBA in the UK on 1 March 2018

Older posts