Saturday, 30 December 2017

New Year: 2017 Year in Review

Welcome to 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 on both the SQL Server consulting and SQL Server training side of the business.

On the consulting front we have been involved in many projects, possibly too many to mention here, but these are the highlights. We started year involved in a large database migration from SQL Server 2008 to SQL Server 2014. Around 20 instances. This  included designing, architecting and deploying several SQL Server Availability Groups to ensure disaster recovery for our clients critical databases. As part of this  we have also migrated SSIS packages and some reports on SSRS too up to SQL Server 2014.

We have been involved in a large Microsoft Dynamics CRM implementation – we were brought in to look at performance issues that  certain customised components were experiencing and we have ended up not only fixing the performance issue but also helping with, building up and supporting a 4 node availability multi-subnet availability group, disaster recovery planning and general troubleshooting.

For another  client we’ve been involved in a large data centre implementation. Building SQL Server 2016 Availability groups to support infrastructure application like System Center Operations Manager (SCOM) and Virtual Machine Manager (VMM) for Hyper –V

At the tail end of the year we have been migrating  several small scale SQL Server instances to Azure SQL Databases. This has been very interesting project to be involved with and as more and more businesses see the benefit of the cloud offering available by the various cloud suppliers I suspect we’ll be getting involved in more of this  type work.

On the training side of things, we haven't delivered as many courses as years gone by but its still kept us pretty busy:

We have delivered
  • 2  SQL Server Databases Administration courses
  • Several Enterprise Architecture TOGAF certification courses
  • 2 SQL Server querying and programming courses

These have been on the public schedule or delivered onsite with the customer.

Thrown into all this SQL Server 2017 has been released and we have been busy making sure our skills are up to date to work with that going forward.

What does SQL Server 2018 have in store?

Well I can’t predict the future but the signs are good. We have a reasonable amount of work in the pipeline. We have a SQL Server Security hardening assignment with a key client to start the year off, a potential SQL Server 2016 migration for a Dynamics environment and also some general consultancy around performance and general setup of SQL Server for software house client of ours

Training wise we’ll be offering the full Microsoft official Curriculum of SQL Server courses including the newly released

  • Updating your skills to SQL Server 2017  (2 Days)
  • SQL Server on Linux (2 Day Courses)

All of our courses can be delivered on site at your business or on the public schedule. If you are interested. Get in Touch

We’ll also be offering the Microsoft official Curriculum of SQL Server courses on demand so you can take them at a date and time to suit yourself. We’ll also be providing you with some instructor time, giving you the ability to ask questions, get help with the labs, or get help with a specific problem you have back at work...Just as if you were in a real life classroom. You won't be left on your own, unless you want to be. Check out the training page in the new year for more details on this  or  Get in Touch if you want more details now.

If we can help you with a SQL Server issues, or if you would like to discuss SQL Server training. Contact Us for a free consultation.

2018 is likely to be a very exciting year for me both personally and professionally. I’m very excited for it to begin.  

So all that leaves me to do is wish you and you’re a very Happy and prosperous New Year!

No comments:

Post a Comment

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...