Prepare for the Future of SQL

Posted on by Lorrie Hellickson

keyboardEarlier this year, the world saw the release of the new SQL Server 2014. As with all things with a year at the end of their names, this is the newest version of the SQL server, and one that’s going to cause few headaches as people get used to them. But, new things only make things better, and the sooner people learn about it, the easier everyone’s lives will become.

The first thing people need to pay attention to is the licensing data sheet. Most people know that they could access licensing information on the old system by using Server + Cal, or Per Core, depending on which edition and version they are using.

Many people were initially nervous about the 2014 edition, because this style of access is one that had some potential of alteration. Companies that specialise in SQL Server management, such as DBA Services would need to alter their operations if such changes became known. Fortunately for them, this function did not change at all.

If the server manager wants to license at the per virtual server level, then they’ll need to remember that each licensed VM with an SA can move within a server farm. Managers can do this without the having to purchase additional SQL server licenses.

Likewise, if people want to take a per host licensing approach, they’ll need to license all the cores on the host server. If managers have multiple servers, they will still need Software Assurance, if they want to use any kind of license mobility. But, if all the licensing methods are the same, why even bother talking about SQL Server 2014?

Well, if managers ever need a stand-by server they can get one passive server for every active server they have, but only if they have Software Assurance. It is still something server managers and the companies that hire need to be aware of moving forward.

About the Author

Lorrie Hellickson is an Operations Manager at an SEO firm in New York. He/She maintains a blog that focuses on trends and breakthroughs in social media.