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 thatcertain 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 Touchif 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!
I've grown up reading Tom Clancy and probably most of you have at least seen Red October, so this book caught my eye when browsing used books for a recent trip. It's a fairly human look at what's involved in sailing on a Trident missile submarine...
Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.
You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I'd like to talk about social networking. We'll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let...
Last week I posted Speaking at Community Events - Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I've got a few more thoughts on the topic this week, and I look forward to your comments.