THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Rick Heiges

News about SQL Server and the SQL Server Community

My World Tour

I just finished my last stop on my “World Tour”.  The cities included Toronto, Johannesburg, Hong Kong, Sydney, Milan, and Singapore. I missed South America and Antarctica on this “tour”, but I hit the other continents.  I was part of a global team assembled from Microsoft and DB Best to train partners on how to migrate customers from Oracle to SQL Server.  Each event was four days.  The first day of the Oracle Migration Bootcamp was focused on customer discussions about licensing and, the latest version of SQL Server 2016, and some of the challenges with a migration.  The final 3 days were more technical in nature and included Hands-On Labs which went through some of the typical steps that you may encounter during a migration from Oracle to SQL Server.  Many of the concepts and tools that we covered could be used for other data platforms as well.  BTW, Microsoft currently has an offer for FREE SQL Licenses if you migrate from a competitive data platform – see your local MSFT rep for details as some restrictions apply.  J

One common theme that I found in our discussions with partners around the world is that Oracle is expensive everywhere in the world.  Several partners had customer stories about how expensive Oracle is and some of the software audits that took place with their customers that resulted in additional licensing costs.  One partner told me about a customer who had inadvertently queried one of the DBA_HIST_ system views that is part of the Performance and Tuning pack.  Just querying the wrong one can trigger the purchase of the additional pack without any warning.  In the story, the customer had an additional $300k of licensing because of this which was totally unexpected.

I always knew that SQL Server Licensing was simpler and cheaper, but this view was re-enforced many times over. Also, everything related to Oracle just seems a little more difficult. This is from just connecting to the database to setting up an environment to licensing.  For example, if a RAC configuration is going to be stood up, this is normally a multi-day (perhaps multi-week) activity with getting all the specific patches and combination of configuration options correct while an AlwaysOn Availability Group environment can be put together in a matter of hours (perhaps less).

On a personal note, it was great to see the far corners of the world, but I also lost a lot of weekends travelling to these faraway places and recovering after the trip home. I did not circumnavigate the globe as the scheduling of these events was not conducive to that which meant a series of back and forth trips.  On the bright side, I have a huge head start on my air mileage accumulation for the year. J

Overall, I enjoyed the experience. I saw some #SQLFamily along the way and made some new friends. I would like to do this type of thing again, but just not right now.  J

Published Thursday, March 16, 2017 8:23 PM by RickHeiges

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Kevin Kline said:

Very cool, Rick!

What's the URL for those who might want to migrate licenses to SQL Serve?

Best regards,

-Kev

March 20, 2017 11:52 AM
 

RickHeiges said:

March 22, 2017 11:22 AM
 

Ipl 2017 said:

March 31, 2017 12:07 PM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Privacy Statement