Posts Categorized in Database development

2 October 2017

2 October 2017

Why it’s time to think seriously 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 functionality. Alongside the list of extra features, it also changes two important ways we think about the platform itself. Time... Read more

20 September 2017

1 Comment

20 September 2017

1 Comment

The importance of bringing Python to SQL Server

When SQL Server 2017 launched, Microsoft proudly announced that it was the first relational database engine to ship with built-in artificial intelligence (AI) capabilities. In the future, database servers running its software won’t just be able to store, query, and analyse data. Instead, they’ll also be able to perform machine learning, natural language, and neural... Read more

23 August 2017

1 Comment

23 August 2017

1 Comment

Why don’t you unit test SQL Server code?

The download count of the tSQLt unit testing framework is surprisingly low, yet this outstanding open source software can revolutionize your SQL Server development process. Hopefully, this post will show the benefits of test-driven development and including automated SQL Server unit testing within your release pipeline. This simple technique can have a profound effect... Read more

19 June 2017

19 June 2017

Provisioning just got BIGGER with SQL Clone v2

Today, we launched SQL Clone v2, which removes the previous 2TB size limit and now supports cloning databases up to 64TB. In this article, I’ll explain why I think this is big news for many organizations, and describe briefly the changes to SQL Clone v2 that made it possible. In larger organizations, such as... Read more

15 March 2017

15 March 2017

Time travelling with SQL Compare

In SQL Server 2016, Microsoft introduced support for system-versioned temporal tables. Temporal tables are a database feature that provides information about data stored at any point in time, rather than only the data that is correct at that specific moment. Why are temporal tables needed? Simply put, they make it much easier to analyze... Read more

Announcing Redgate Data Tools in Visual Studio 2017

Visual Studio 2017 is released today, and its new features like Live Unit Testing and configurable code style rules have already been grabbing the headlines. But inside the Visual Studio 2017 installer, another big surprise awaits: Redgate Data Tools. We’ve partnered with Microsoft so Visual Studio Enterprise subscribers can install ReadyRoll Core, SQL Prompt... Read more