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
It would be wrong to portray SQL Change Automation (SCA) as being suitable only for epic project deployments, of the sort described in my previous article. It can do smaller tasks as well. To demonstr...
Also in SQL Source Control
Much has been written on the benefits of having a database under source control though many articles are clear on "why" but conspicuously vague on "how". Prior to our organization's decision to embrac...
Also in Product learning
The SQL query that is used to produce the result that is inserted into the permanent table has its order specified by an ORDER BY statement. Relational tables are not ordered, so the ORDER BY is meani...
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 ...