Here’s a list of notable trends involving SQL Server that IT teams has to be ready for about the next A year. Among them: increased application of the cloud, AI, Linux and containers.
The pace of improvement in IT seems to accelerate every year, and that’s certainly true for SQL Server. The new year…
saw the release of SQL Server 2017, which followed over the heels belonging to the 2016 version with added support for Linux, Python even more.
But there’s not enough available time to relax: SQL Server database administrators has to be ready to obtain a host of extra changes and technology in 2018. Let us take a look at five major SQL Server database trends that database administrators (DBAs), developers and then it managers need to be on top of since we head into your next 12 months.
Security threats and adoption of SQL Server 2016/2017. If this wasn’t already squarely an increased priority for doing it organizations, data security will probably have been pushed there via recent rash of ransomware attacks, like Petya, and high-profile data breaches at companies particularly Equifax, which exposed there’s data of up to 143 million U.S. residents, and Uber, which allowed hackers to access 57 million user accounts.
SQL Server 2016 introduced several new safety features, including Always Encrypted, row-level security and dynamic data masking, and SQL Server 2017 further boosted the database engine’s security capabilities with expanded administrative credentials and new configuration sources of .NET common language runtime assemblies.
Adoption of the latest SQL Server releases is frequently slow because users are wary of changing systems which have been working smoothly, but these continued threats and hacks give businesses great increase their security measures throughout every one of the levels of the application stack, for instance database stack.
Continued cloud growth. If you happen to went to the PASS Summit 2017 user group conference from the fall, or you heard from anyone that did, you will understand that Microsoft is all about the cloud. The Azure platform is Microsoft’s future, as well as its clear that cloud usage is increasing fast, and it may continue to do so in 2018.
SQL Server database trends also point toward the cloud: Azure SQL Database now has reached programming parity with on-premises version of SQL Server. At PASS Summit, Rohan Kumar, gm of Microsoft’s database systems group, told the crowd about Microsoft’s cloud-first release cadence, of which new features and innovations are tested and implemented within the cloud database think twice before it in to the on-premises product.
While DBAs usually aren’t first in line to embrace the cloud, the use of doing so keep growing, and the barriers to adoption continually shrink. Keeping up with Azure SQL Database also, the related cloud data management services is growing more important prior to now.
AI-infused databases. There’s no doubt that AI is now the hottest buzzword in IT. It seems like just about each IT method now suddenly AI-enabled, and SQL Server isn’t a exception. Inside April 2017 post, Joseph Sirosh, now corporate vice president in charge of Microsoft’s cloud AI platform group, touted SQL Server as “the first RDBMS [relational database management system] with built-in AI.”
Facing built-in AI to get an RDBMS really mean? Preferably, Microsoft is talking about the fact that AI functionality sold at the Machine Learning Services element of SQL Server 2017 enables users function machine learning and AI libraries developed in R or Python into routines that are able to run on SQL Server systems; this gives analytics applications to be executed when the data is hosted and not needing to first surface it to an alternative application layer. SQL Server DBAs and developers must understand how these AI design patterns can with the database platform.
SQL Server on Linux also in containers. Clearly, two of the biggest changes with SQL Server 2017 are its support for Linux and Docker containers, which could have a big influence future database trends. The SQL Server 2017 release on Linux has shown to be a high-performing platform, already having set some TPC benchmark records.
But the addition of Linux support unwraps SQL Server for free implementations, it also indicates that SQL Server DBAs who once only had to deal with Windows may now have to aquire some basic Linux skills under their belts.
Likewise, while still included in the infancy, container support helps SQL Server move toward never-ending integration and continuous deployment cycle that matches better into your growing DevOps development paradigm. Although it may still regarded as a bit early to obtain SQL Server containers into production, they’re beneficial to developers and testers.
Containers can turn SQL Server into a component that is easy and quick to deploy, devoid of the lengthy installation needed. You also need the option of combining a SQL Server instance as well as data in a single package, making your SQL Server development environment very easy to recreate and tell you different teams.
The latest SQL Server software update cycle. The biggest pain points with them today is keeping up with security patches and software updates — and someone of the biggest new database trends that DBAs will have to cope with in 2018 is going to be changing update cycle for SQL Server.
Frist by SQL Server 2017, Microsoft is no longer working with old model under which cumulative updates (CUs) were released every sixty days and service packs (SPs) containing lots of the fixes using the preceding CUs were released each year.
The company won’t deliver SPs anymore — there may only be CUs, that are delivered occasionally at first, and then suddenly less frequently. By now, Microsoft plans to issue a CU for the first One year after a major version of SQL Server is released, after which you’ll once per quarter through out the five-year product lifecycle. For older releases, the SP establishes something new baseline; CUs then will be provided every One full year or so.