SQL Server 2017 went on general release a couple of weeks ago and the latest version of SQL Source Control offers full support, as well as support for Team Foundation Server (TFS) 2018.
This brings a whole host of benefits and opens up cross-platform workflows, encompassing both on-premises and cloud, through connections to SQL Server instances on Linux and Azure Active Directory authentication.
This is good news if you work for an organization in which departments and divisions host their databases on various servers and systems, owned by teams in different geographical locations. You can continue working in the development environment you’re familiar with, using the tools you always use, only now you’ll have direct connections across the ever-changing server landscape.
Take advantage of SQL Graph
Microsoft SQL Server 2017 features the much-anticipated SQL Graph, which provides new graph database capabilities for representing complex many-to-many relationships. Social media platforms like Facebook and LinkedIn use graph databases extensively, and in the era of big data, use cases are emerging across many industries.
Businesses can explore these relationships to reveal valuable information, as you’re probably aware from changes in the types of structures and query abilities being requested of you and your teams. Whether it’s identifying similarities in customers behind trends in purchasing behavior, or mapping patterns in credit card usage to determine credit limits or risk indicators of defaulting on repayments, the introduction of graph capabilities to SQL Server makes the processes more streamlined.
Today’s release of SQL Source Control v6 joins Redgate’s recently released SQL Compare v13 in fully supporting SQL Graph, so if you’re experimenting with SQL Graph databases, or getting more BI requests through, you can now use a single query across relational and graph database objects, and deploy updated databases with the tools you know and love.
That’s not the end of the story
SQL Source Control v6 also delivers lots of improvements to user experience and workflows, many of which came about as suggestions from you in our Redgate Community Hub. Importantly, it does so with a much smaller footprint, thanks to an overhaul of the entire codebase, resulting in better stability overall.
You can happily explore all the new features in SQL Server 2017, knowing the industry standard for version controlling your databases won’t let you down. To find out more about the improvements in SQL Source Control v6, take a look at our release notes.
And to learn why it’s important to version control the database, read our recent blog post, Six reasons to version control your database.
Also in Hub
When writing functions or procedures, a common chore is to devise and implement the tests that ensure that the routine always works as expected. The best way to do this is to define the tests in a bat...
Also in Product learning
Deploying schema changes to SQL Server databases can be tricky when you’d like to automate parts of your workflow. For instance, how do you go about version controlling your schema changes? In appli...
Also in SQL Source Control
The recent State of Database DevOps Report revealed that within two years, 80% of companies will adopt DevOps. That’s an interesting finding in itself, but the report also showed that 75% of compani...
Also about SQL Server 2017
SQL Server 2017 officially landed today and is now on general release. The latest version of the heavyweight platform is more than the sum of its parts, however, because it doesn’t just deliver new ...