Microsoft SQL Server is a fully-featured relational database system whose primary function is to store and retrieve data requested by other system applications. There are several different Microsoft SQL Server version and editions, each engineered to meet different demands and workloads. There are also different licensing options structured for different business needs. In this guide, our certified Microsoft suppliers here at Trusted Tech Team cover some of the most common types of licensing for today’s top SQL Server versions. We also cover what’s new in SQL Server 2017. Learn more below, and shop SQL Server versions new and old here.
One of the biggest updates to the SQL database software is the ability to install on a variety of platforms. New environments include Linux and Linux-based Docker containers. Supported Linux operating systems at this time are Red Hat Enterprise, SUSE Linux Enterprise Server, and Ubuntu. Some features available on the Linux environment include:
SQL Server R Services has been changed to SQL Server Machine Learning Services. This addition now allows users to utilize Python alongside the R language. This change will eliminate the need to move data from the database to the Python application or model by directly integrating the language into the database. Python integration is available for all editions of SQL Server 2017, including SQL Express.
Graph database capabilities is a new feature for SQL 2017. This allows storage of nodes and edges. Nodes are considered entities, such as employees or a department. Edges are the relationship between the node and category. Graph data allows querying of complex relationships more efficiently.
This feature allows users to resume rebuilding their indexes, which will come in handy if you have large indexes or have a limited maintenance window. In previous versions, cancelling the index rebuild would require restarting the entire operation. With this new feature, you will not need to dread the cancellation as you are given the option to pause, suspend, resume, or abort the task.
Having a failure or unexpected restart of SQL Server in previous versions would clear the identity cache. With this new update will allow disabling identity caching by database to avoid having gaps in identity values.
SQL 2017 introduces a new optimization tool to help plan and execute queries more efficiently based on its adaptive estimations. Adaptive Query Process will consider:
If you need assistance, feel free to give us a call! A representative will be more than happy to assist you.
Sales and Support M-F 6:00am - 4:00pm PST
Need a PDF copy of this page? Click here to send us a request!