Licensing Microsoft® SQL Server

Learn everything you want to know and everything you need to know about licensing Microsoft SQL Server.  

Licensing Microsoft® SQL Server is a comprehensive, 1-day software licensing training course dedicated to the licensing of Microsoft SQL Server. The knowledge you gain from this course will empower you to make informed SQL Server licensing decisions that optimise spend, mitigate compliance risks and maximise your return on software investment.

About the course

Licensing Microsoft® SQL Server

Microsoft SQL Server usage is governed by some of Microsoft’s most complex licence terms. It is also one of the most common products for which licence deficiencies are identified during a licence audit.

Licensing Microsoft® SQL Server is an in-depth, 1-day software licensing training course dedicated to the licensing of Microsoft SQL Server.

This course will teach you everything you need to know to avoid compliance risks, make informed purchasing decisions and gain maximum value from your SQL Server software licence investments.

The course covers the licence terms relating to running SQL Server workloads in on-premises environments, and also covers the licence terms applicable to running SQL Server workloads in the cloud and how those terms can differ significantly between Azure, AWS and other 3rd-Party cloud environments. 

 

Course Details

Course Dates & Times:

We do not currently have a virtual classroom course scheduled for this course. 

If you would like us to run a private course exclusively for your organisation, please contact us on 1300 557 917 (from within Australia) or + 61 3 9811 7040 to discuss your requirements and the pricing structure for our private group courses.

Course Duration:
1-day (8:30am – 5:00pm)

Course Inclusions:

  • Digital Training Materials
  • Digital Certificate of Course Completion

What will I learn?

Topics & Content

Some of the key topics and content covered in this course include;

  • What are the differences in licence terms between the “Per Core” and “Server + CAL” licensing models?
  • How do licence terms differ between physical and virtual instances of SQL Server?
  • How do I licence SQL Server failover environments?
  • How do I licence SQL Server component services?
  • What do I need to know about instances, running instances, multiplexing and licence mobility?
  • How do I licence Production, Test & Development and Disaster Recovery environments?
  • Can I bring my own licence to a cloud environment?
  • Can I bring my own licence to IaaS and PaaS environments?
  • How do the licence terms differ between on-premises, private cloud and public cloud environments?
  • How do the licence terms differ between Azure and other Public Cloud environments?
  • What is the Azure Hybrid Benefit for SQL Server?
SQL Server Versions

This course primarily focuses on the licence terms for the current version of SQL Server (version 2019), however many of the terms are identical/similar to some of the more recent versions of SQL Server and we describe key differences in licence terms between current and prior versions throughout the course. The primary course content relates to SQL Server version 2019 (with and without Software Assurance), however licence terms are referred to for prior versions from version 2000 and above.

SQL Server Editions
This course primarily focuses on the licence terms for SQL Server Standard and Enterprise editions of the current version of SQL Server (version 2019) however other historic editions are referenced during the course including Business Intelligence, Workgroup and Datacenter editions.
SQL Server Licensing Models
This course primarily focuses on the licensing models available for the current version of SQL Server (version 2019) which include the “Per Core” and the “Server + CAL” licensing models. The “Per Processor” licensing model which is applicable to versions 2008 R2 and below is referenced during the course however we do not provide content relating to calculating Per Processor licensing requirements.
IT Environments

Learn the licence terms relating to specific environments;

  • On-Premise Environments
  • Public Cloud Environments
  • 3rd-Party Hosted Environments
  • Production Use & Test/Dev Use environments

The knowledge you gain will enable you to;

Z

Manage Compliance Risk

Identify and mitigate compliance risks and avoid the common mistakes that expose organisations to licence deficiencies.

Z

Make Better Decisions

Make informed decisions that are strategic and cost optimised.
Z

On Premises, Cloud & Hybrid Environments

Ensure you have an optimised set of SQL Server licences that cover your on-premises, cloud and hybrid IT environments.

Z

Assess SQL Server Licence Requirements

Assess licensing requirements for your SQL Server projects.

Z

Develop In-house Licensing Expertise

Build in-house licensing expertise and become your organisations in-house SQL Server licensing expert!

Some words from our course participants...

Our Microsoft licensing training courses have been attended by hundreds of people and the feedback and testimonials we receive is testament to the quality of the course and the value it provides to those who attend.

Masters of Microsoft® Licensing Training Course

"You know you are in good hands and learning from the best at the business when your trainer spells the word ‘Licence’ accurately every time! I enrolled into this course with much unease since my background is not technical but the course content was so easy to follow. The trainer explained each topic at a level where every student was comfortable with the understanding."

Shanaz Khan: BT Contracts and Procurement Administrator – CSL Limited
Masters of Microsoft® Licensing Training Course - Enterprise Agreement Renewal

"The course was very insightful and thought provoking; so much so that the team re-cut the numbers to model the different product licensing options discussed – in short it was exactly what we were looking for to get everyone aligned and focused on task at hand. This is the course that all organisations should be looking at if they want to take control of their Microsoft environment and get the most from their entitlements, while minimising their financial exposure"

Testimonial provider name withheld at customer request
Masters of Microsoft® Licensing Training Course

“Very comprehensive" & “Exceeded my expectations”

“The best course I have ever done”

"Thanks very much for the course, highly recommended!"

"The training was phenomenal"

"It really was the best course I have ever attended & I have learnt a lot."

Masters of Microsoft® Licensing Training Course

"I would recommend this course for anyone who has "Microsoft" in their daily vocabulary. Knowing how to (and not to) use your investment not only reduces compliance risk, but gives you commercial advantage too!"

Ashley Scott: Technology Asset Manager – ActewAGL
Masters of Microsoft® Licensing Training Course

"This was a really great course that I would recommend for anyone who is involved in Microsoft licensing or implementation. There was a good mixture of formal explanation and discussion of issues along with random quizzes to keep everyone entertained. The time flew by."

Sarah Bailey: Manager IT Management Services – Coffey International
Masters of Microsoft® Licensing Training Course

"What a fantastic course. Absolutely exceeded my expectations and recommend anyone wanting to update their knowledge to sign up for this course. Great bunch of people coming together to share their experiences was also a highlight!"

Cindy Radloff: IT Software & Asset Lead – SA Water

Frequently Asked Questions

Are there any course prerequisites?
No, there are no course prerequisites. We will guide you through everything you need to know, from the basics through to the advanced.
Is the course affiliated with or sponsored by Microsoft Corporation?
No, our courses are developed in-house and are not affiliated with or sponsored by Microsoft Corporation.

Discover SAM is an independent organisation. We do not sell software licences and as such we are uniquely positioned to provide you with truly impartial and independent licensing advice.

Is the number of participants limited?

Yes. To ensure all participants gain maximum value from the course, we restrict the course to a maximum of 20 participants.

Get in touch with us today...