Last Wednesday SoftwareOne (West Indies) held a What’s New in SQL Server 2016 breakfast event at the Marriott (Port of Spain). Who can refuse free breakfast, right? Circumstances prevented me from getting there but I had already installed SQL Server Developer Edition and drafted how I wanted this blog post to flow so I made sure and asked for the presentation files and photos from the event so I could complete this blog post and share my takeaways.
Presenter Nigel Sammy has a wealth of experience and knowledge in this area and has presented at local events in the past put on by Microsoft and TTSSUG. My opinion on SQL Server is that it costs you but it gets you good support and updates, integration with other Microsoft products and ease of use. You can maintain an on-premise install or choose the cloud (Azure). One thing I would like to see is a local (or regional) SQL Server Users forum. A simple Google Groups or the likes could work, for example.
Some fun facts I came across on wikipedia. Version 1 was released on April 24, 1989; 27 years ago. It is written in (mostly) C and C++. There is a Linux version (beta) coming. What might the future look like for SQL Server? I did a quick Google search and came across a few things. The need for metadata on datatypes. A cloud first world. Embracing all platforms and the open source developer space. Better reporting and business intelligence tools.
SQL Server has a few editions to choose from for your situation and you can scale across editions easily. Understand the different scenarios like private cloud, public cloud, onpremise, virtual machines and infrastructure/software/platfrom as a service. Security and performance are two important things to want from a DBMS. One thing from the presentation that caught my eyes was temporal database support. Basically built-in support for querying the database at a particular point in time. Row level security is also useful. I bet users will like the modern look of reports with rich visualisations in Reporting Services. The reasons listed in the presentation for upgrading to 2016 are features, performance and uptime, newer is better, EOS and new infrastructure. Finally the presentation talked about why you might want to choose a company like SoftwareOne for advisory services, licensing and other related services. Thank you and share your thoughts and experiences with us in the comments below. Also like their page to know when there are future events.