Monday, 28 October 2019

Do you need to know about Microsoft Azure

The problem

You don’t know anything about Microsoft’s Azure Cloud.
Do any of the following describe you

  • You are running your business, and you’ve heard all about “the cloud” and how it helps your business. But you don’t know where to start. You know Microsoft products, but you don’t know about Microsoft’s cloud offering.
  • You work in IT, and your company has decided that cloud is the way forward and the new strategy is a “cloud-first approach”, and the cloud provider in question is Microsoft’s Azure.
  • Your company has started its cloud journey, but you feel a little left behind, you haven’t done any cloud work yet as you’ve been sorting out a big project with an on-premises solution. You want to get yourself up to speed so you can start working on Cloud-based projects delivering value to your business.


The Solution



On the 12th of December, we are running an Azure fundamentals training course. By attending this course, we will provide you with a general understanding of cloud computing concepts. We will discuss the core services available in Microsoft Azure. We will look at how you can quickly use these cloud resources to benefit your business. One of the significant concerns with cloud computing is security, and we will talk about how we can achieve security, compliance and trust with Microsoft Azure. We will have to show you how much this could cost and look at you can best set up your pricing model to get the most out of your investment.

At only £350 + booking fee / VAT (£295 +...early bird for the first five bookings) we believe this is excellent value. The full list of course objectives and to book, click here.

If you want to chat about the course first, or you want to book for a group of people or if you need to pay via invoice. Contact Us

Wednesday, 23 October 2019

Azure Fundamental Training this December

Here at gethynellis.com. We're very excited to be launching our web-based Microsoft Certified Azure Fundamentals Course AZ-900T01 as the next stage of delivering our aim of making Expert Skill available at Affordable prices.


 

If you're seeking Azure Certification or just want to gain Azure skills, then this course is for you. At only £350 + VAT per delegate (£295 + VAT early bird discount for the first 5 bookings), we believe this is excellent value for money. This course covers everything you need to know should you wish to become Microsoft Certified at this level, and the full list of the course objectives is available here. 
 

Here are some comments from previous training course customers:
"The Instructor was knowledgeable and friendly. The mixture of slides, demonstrations and exercises keeps the material interesting".
"Really informative, I received everything I expected and extra!"
"Gethyn answered all questions very well clearly and concisely and went through the material in good speed and explained certain areas in more depth where necessary."
"Excellent clear tuition and knowledge from Geth Ellis. Thank you!"
 

If you would like to book, please take this link, to make your booking and payment. Note prices above exclude the small Eventbrite booking fee.
 

So whether you're an individual, or you work for a Not for Profit, Membership body, Financial provider, Law Firm or any Public or Private sector organisation and you want to get to know Microsoft Azure, our web-based course can help you maximise your investment at an affordable price. We look forward to seeing you on the 12th. To be assured of a place, please book as soon as you are able as places are limited.

Contact us via the Contact us page if you need to book with an invoice or booking for more than one attendee. 

Friday, 11 October 2019

Azure Fundamentals 12th December

Certified Microsoft Azure Fundamentals  - AZ-900 

 1 day Web based Course - 12th December 2019



Its been a big few of weeks here at gethynellis.com. We've been accepted onto the UK Governments Digital Outcomes & Specialists 4 framework, our recent webinars have led to inquiries for our SQL Health check and Migration solutions and we're very excited to be launching our web based Microsoft Certified Azure Fundamentals Course AZ-900T as the next stage of delivering our aim of making Expert Skill available at Affordable prices.

If you're seeking Azure Certification or just want to gain Azure skills then this course is for you. At only £350 + VAT per delegate (£295 + VAT early bird discount for the first 5 bookings) we believe this is great value for money. This course covers everything you need to know should you wish to become Microsoft Certified at this level, and the full list of the course objectives is available here.

Here's some comments from previous training course customers:
"The Instructor was knowledgeable, and friendly. The mixture of slides, demonstrations and exercises keeps the material interesting".
"Really informative, I received everything I expected and extra!"
"Gethyn answered all questions very well in a clear and concise way and went through the material in a good speed and explained certain areas in more depth where necessary"
"Excellent clear tuition and knowledge from Geth Ellis. Thank you!"

If you would like to book please take this link, to make your booking and payment. Note prices above exclude the small Eventbrite booking fee.

So whether you're an individual, or you work for a Not for Profit, Membership body, Financial provider, Law Firm or any Public or Private sector organisation and you want to get to know Microsoft Azure, our web based course can help you maximise your investment at an affordable price. We look forward to seeing you on the 12th. To be assured of a place, please book as soon as you are able as places are limited.

Friday, 23 August 2019

Cloud Computing: Myths, Mysteries, Vampires & Vultures - a free seminar to help you learn more about "the cloud".

To be honest you probably think that migrating to the cloud sounds great, and it can be, but… it’s not without risks and many people do not sufficiently understand what the consequences of their actions really are.



In this session we'll discuss:

  • What cloud options are there and what this might mean to your business?
  • What risks you are and aren't mitigating in migrating to the cloud?
  • What responsibilities remain yours as a result?
  • If it is a panacea for all your IT worries or if you will still need IT?
  • How to get the best out of the cloud for you?

Does any of this intrigue you? Or do you think someone you know might get unwittingly bitten and should be forewarned?

If so then please register here for our free webinar. If you register and find you can’t make the seminar, don’t worry we’ll make a recording of the webinar and make this available after the event.

Monday, 5 August 2019

David's book: Putting Your Head in the Clouds


I have had a few people contact me over the last few weeks asking if David’s ebook “Putting Your Head in the Clouds” is still available. The short answer is yes it it!



If you would like a free  copy all you need to do is click the Free Training and Webinars Page at the top of the page and signup for our free training Newsletter and you will get sent an email with our back catalog of  webinars and a link to download David’s book.

If you have any issues accessing the book  do let me know.

Thursday, 1 August 2019

Fantasy Football - A League of Our Own - Want to Play?


It feels daft me saying the football season is only 9 days away, when in fact The Ashes cricket series is only starting today at Edgbaston. The Ashes are starting later than perhaps they usually would and the football season if creeping forward in August. The Premier League  starts on Friday 9th August  when the mighty Liverpool take on Norwich.

Lords Cricket - England v Ireland July 2019



Last year I had a lot of fun play fantasy football, you can take it as seriously as you like, it is after all just a bit of bit of fun, but I had a lot of fun analysing the data, the statistics and picking what I thought would be a great team. Data is a big deal in football and sport in general,  as year on year  the game and moves more and more towards data driven decisions – Money Ball!

Wolves v Crusaders July 2019 (Europa League)


There is no doubt a lot of football fans in the SQL Server community and no doubt some of these play fantasy football too so I thought I’d put together a private league that we can join to see who manages the best team through the course of the season. 

With fantasy football there is a lot of data available that you can use to analyse and slice and dice  to allow you to make decisions on the best players to pick  in your team. Allowing you to get the most of your £100 Million, the fictional amount you have to build your team – your constraint. The value of the player can fluctuate over the course of a season and you can make transfers each week too so can grow or even lose some of that £100 Million  – you are limited to 1 free transfer a week but you can buy more transfers by sacrificing points. Details of how the scoring works and a full set of rule are available on the  fantasy.premierleague.com

I have decided to run  a bit of competition on the blog just for fun to see if anyone else is interested. 

I thought we could have a league of our own…. If you would like to join in and play, its open to everyone so feel free to sign up. Click this link and use the registration form at the bottom of the page. This will add you my mailing list for the league, all you need is  your  name and email addresses. I’ll send you an email that will contain a link to the fantasy football site (You can find that link below too) and also include the league code and some instructions on how to join.  You will need the league code to join the league I have created. Enter that code into the "Join a League" section of fantasy.premierleague.com to enter your team into the league and   we can have a bit of fun with a League of our own. The site we will use is fantasy.premierleague.com  the official premier league fantasy football and we follow all the rules and T&Cs for that site for playing the game. I'll keep you updated from time to time with league updates... There is no prize for  winning the league (I am not the organised) yet, but I'll see what I can put together, I'm sure I have a cup and some pens lying around, they will only be very small prizes, its just for fun but I'll confirm if I have managed to secure any and what they are at a later date. 

However you pick your side and however make your transfers, whether its gut instinct or you use extensive data analysis or even using machine learning algorithms to help you make those critical decisions it will help keep the football season fun and also maybe learn some things too especially if you use ML to make picks and selections…

Follow this link and signup using the form at the bottom of the landing page to get involved.

Tuesday, 9 July 2019

OUT OF SUPPORT: SQL Server 2008 and SQL Server 2008 R2

Welcome to this post, on SQL Server 2008 and 2008 R2, both of these versions of SQL server will go out of  extended support with Microsoft today! 9th July 2019!


Maybe you were thinking of upgrading your legacy SQL servers to the latest and greatest versions?



Who is Affected

In the consultancy practice at gethynellis.com we have both large and small clients. Its usually  always the way, the small clients with less of a SQL Server infrastructure footprint find it easier to keep up within two versions of the latest version of SQL Server.  Its very often the larger clients, with a large estate that struggle to keep all of their estate on supported versions and are usually the ones facing the end of support cliff edge.

I have seen SQL Server estates at many  companies and businesses and, at an estimate I'd say that between 20 and 30% of the estate is on SQL Server 2008 R2 and below. There can be a number of reasons for this, including but not limited too,  the applications the databases support require an older version of SQL Server, maybe the applications are  also coming to the end of life, but the end dates do not  not match up with the data platform end of support dates. In this situation  you have period of time where your data platform is out of support completely.

Sometimes these applications are critical to the business and everything works just fine. The business doesn’t want to disrupt the application or introduce any risk by performing a migration to a new version. It works fine as it is, why would I want to change it? In which case the end of support  cliff edge could be a problem for you too.

Extended Support End 9th July  2019

Extend support ends on 9th July 2019 – today!

If you haven't done so yet you might be making plans to migrate your legacy SQL Servers off the unsupported versions. If you do find yourself in a situation with SQL Server 2008 R2 or below still running you have four  options….

You can:
  • Run on the out of support software
  • You can modernise and migrate to the latest and greatest SQL Server platform or somewhere in-between
  • You pay for a customer support contract with Microsoft so you continue to get security updates
  • Or you can migrate the work load to Azure and you will continue to get the security updates for FREE!
There are pros and cons of each.

Run on out of support software

If you decide to run on out support software and take the risk associated with running on out of support software.  The main advantage of this approach is there is no further work for you to do. There are some disadvantages though that you should consider, the longer you run on the platform the greater the chances of you encountering a security vulnerability or failing a compliance test. Also if anything does go wrong you’ll have no support from Microsoft. When would I take this approach? If the database and its application are running on the old data platform and the application is also coming to the end of life but the dates don’t quite  match up… Then I might consider running on this for a short while, I'm talking a few months tops. It might be your happy to run on out of support software  for a month or two, maybe 6 months, maybe that’s pushing it. Any longer than that and I personally would be looking at some of the other options available.

Modernise! Upgrade or migrate to the latest and greatest SQL Server platform (or somewhere in-between)

Modernise and upgrade is one of the options that you have available.

You can upgrade your on premises SQL Server estate to use say SQL Server 2017 – which at this time is the latest version of SQL Server that has been released to market. SQL Server 2019 is no doubt not far away. Or  you could use this opportunity to jump in to the cloud! You could if you wanted  look to migrate the databases to Azure  either as IaaS solution where you run the VM in Azure or even the PaaS Azure SQL database offering

There are number of advantages to upgrading your data platform. You’ll be running your database workloads on an in support data platform, with a long support window. There will likely by new features in the latest and greatest version of SQL Server that you can use to add business value to your application – Availability Groups for example. Also you will likely find people with skills in the later technology, those skills will be more readily available in the jobs market.

The disadvantages of modernising and upgrading could include:
There will likely be a different licensing model – the licensing model changed between SQL Server 2008 R2 and SQL Server 2012 – it possible you might have to pay more for you SQL Server licences
If your workload and application is also near end of life the planning and work involved in an upgrade might not be worth it

When would I use? I’d use this approach if the applications and workloads living on the data platform are still in use with a reasonable shelf life and likely to be in use beyond the very short term.

Pay for a customer support contract with Microsoft


The third option is similar to the first option but instead of doing nothing you pay for a custom support agreement. The main advantage here is you can continue to get security updates and therefore potentially remaining compliant. The main disadvantage of this approach is the cost involved, which I understand to be 75% of the full license costs of the latest version of SQL Server and Windows Server.

When would I use this approach?

In all my time working and upgrading with SQL Server I have never executed this option. I think I would need to be in a situation where an upgrade was not possible for whatever reason that may be, and I had strict needs to remain complaint, or the gap between out of support and the application retiring was too long for my risk threshold.

Migrate workload to Azure

Microsoft have decided to allow SQL Server 2008 and SQL Server R2 VMs running in Azure to have the security updates for free for a further 3 years. So you can migrate your database server to azure and continue to gets security updates for free until 2022.

The main advantage of this is you get to keep running the same version of the OS and Data platform, the security updates are free so the cost is minimal and also once you're in Azure its then only a small jump to the full PaaS Azure SQL database or managed instance offering.

The disadvantages as far as I can see is you would need to move off premises, if this is not an option for you then you can’t exercise this option and there will still be work in involved in ‘lifting and shifting’ the VM to the cloud.

Whatever you do when support ends for SQL Server 2008 and SQL Server 2008 R2  have a plan

We are running a free webinar on 31st July to discuss some of these options and look at some useful techniques and tools that you can use to migrate and upgrade your SQL Server platform... Please do sign up if this sounds interesting to you.



Featured post

OUT OF SUPPORT: SQL Server 2008 and SQL Server 2008 R2

Welcome to this post, on SQL Server 2008 and 2008 R2, both of these versions of SQL server will go out of  extended support with Microsoft t...