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

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, 142 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, 211 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, 180 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, 203 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, 206 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, 251 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, 264 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, 230 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, 171 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,586 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, 412 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,282 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, 257 reads

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

Azure SQL Elastic Pools

In this video  tutorial David talks you through the benefits of Azure SQL Elastic pools. Elastic pools allow you to share compute power between different Azure databases.  This can be particularly useful if you have databases with differing or varying performance requirements.

With Azure SQL Database you can allocate  DTUs…

Read more

0 comments, 297 reads

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

Renaming a local windows login after SQL Server Computer Name Change

I had an interesting issue last week. I had to rename non-domain (Workgroup) SQL Server Virtual Machine in Azure. The server was running the Database Engine, Reporting Services and Integration Services

I actually run through a blog post I wrote the best of 8 years ago titled Renaming a Standalone Instance…

Read more

0 comments, 1,638 reads

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

SCOM: SQL Instance and Databases exclusion

This  post is by Chris Gibson

I recently wanted to exclude some temporary SQL databases from being discovered by our SCOM environment.  These databases are created during a backup process and are always named “_Clone”.  I’d previously excluded SQL Express instances by their name (Maps, Live, MSEE) and…

Read more

1 comments, 537 reads

Posted in The SQL DBA in the UK on 10 January 2018

Patching your SQL Servers - Meltdown and Spectre

The latest security issue with the name "Meltdown and Spectre" affecting Intel processors  was made public last week. This security issue affects a lot of systems and Operating Systems it is not a Microsoft specific issue. I think I read somewhere that ALL Mac devices are affected. Whilst details…

Read more

0 comments, 464 reads

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

What is the oldest version of SQL Server you are running?

I have a  twitter poll running asking "What is the oldest version of SQL Server you are running?", to use as evidence in a talk I have planned for later in the year. 



I’d like to know what is the oldest version of SQL Server  you have running in a…

Read more

0 comments, 331 reads

Posted in The SQL DBA in the UK on 3 January 2018

New Year: 2017 Year in Review

Welcome to gethynellis.com and our final post of the year.



SQL Server 2017 - In Review


It’s the end of what has been interesting  and successful year here gethynellis.com on both the SQL Server consulting and SQL Server training side of the business.


-->
On the consulting front we…

Read more

0 comments, 400 reads

Posted in The SQL DBA in the UK on 30 December 2017

Server Roles and Azure Active Directory in an Azure SQL Database

This video explains the built in server roles in an Azure SQL Server and demonstrates how to give a login a server roles and how to give an Azure Active Directory user permissions to an Azure SQL database.




You can download the free ebook: Putting Your Head in the Cloud:…

Read more

0 comments, 425 reads

Posted in The SQL DBA in the UK on 29 November 2017

Older posts