Posts Categorized in Software development

At Redgate, we develop software applications, tools, devices, LEGO, and more. Here, you’ll find posts on what we’re developing, how we go about developing it, and what we value and encourage in our software developers. You might even see a post about building LEGO soon.

20 September 2017

20 September 2017

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

22 August 2017

22 August 2017

SQL Census update: new server view

SQL Census is the latest prototype to come out of Foundry, Redgate’s research and development division. It helps you trace SQL Server user access permissions. You can use it to for free of charge by downloading it. We’re working closely with a select group of people who are helping us test and iterate this... Read more

26 July 2017

2 Comments

26 July 2017

2 Comments

Removing sensitive data from a database

Not too long ago I was assisting a client with an issue they were experiencing while running some compliance software to check for sensitive data. Sensitive data was picked up in the SQL Server data file but when the DBAs checked, the data was nowhere to be found in the database. It’s fairly widely... Read more

12 July 2017

12 July 2017

Are your automated tests slowing you down?

Slow, unreliable tests prevent teams doing great work, and make continuous delivery impossible. This was true for our SQL Source Control team when I started working with them. From pushing a commit to getting a complete set of tests took almost 12 hours. Then you had to rerun the raft of tests that sometimes... Read more

Who’d want to be a coach?

About a year ago, Redgate introduced a new role to support our development teams: Coaches. The idea’s simple. Our development teams are made up of software engineers and UX designers, who make great products. They can do that on their own, but many people are used to agile experts (like scrum masters or project... Read more

12 June 2017

12 June 2017

Data classification: understanding and protecting your data

A data discovery and classification research project from Foundry In Foundry, we’re responsible for developing new products and technology to support the changing needs of our customers. We’ve seen a huge shift in our customers’ needs: driven by new and constantly evolving regulations, there’s an ever-growing demand on their time for data governance tasks.... Read more

2 June 2017

2 June 2017

Simplifying the user access audit with SQL Census

SQL Census is the latest piece of technology to be developed within Redgate Foundry. Still early in its development, it’s a product that’s designed to help you explain to an auditor which of your colleagues are able to access business-critical SQL Server databases. As well as reporting on who can access these databases, it... Read more