Posts Categorized in Database development

As more and more software development moves towards devops processes, it’s important to bring the database along too. At Redgate, we’re making it possible with a suite of database development tools that plug into and integrate with the software used in application development. The result? DevOps for the database has become a reality.

12 April 2021

12 April 2021

The challenges of monitoring a highly complex database estate at the University of the Sunshine Coast

As the manager for enterprise applications and data at the University of the Sunshine Coast in Queensland, Australia, I face a lot of unique challenges. The university itself has around 25,000 students, 1,000 permanent staff and another 1,000 seasonal staff who assist with key academic sessions. They’re spread out across the flagship campus at... Read more

1 March 2021

1 March 2021

Why to Use Git Instead of “TFS” (TFVC)

One question we frequently hear from customers using the Microsoft stack is, “should I use Git or TFS?” The question requires a little decoding due to the way that Microsoft has shifted their brands over time. Here’s some background: Microsoft’s “Team Foundation Server” (TFS) was renamed “Azure DevOps Server” in 2019 Many people still... Read more

12 February 2021

12 February 2021

A quick guide to reputational risk

When it comes to reputational risk, a reactive approach is generally taken by organizations, with efforts focused on handling threats to their business they are already aware of. As much as this enables short term damage limitation, it may not be enough to manage and protect your risk in the long term. Instead, a... Read more

10 February 2021

10 February 2021

Customer tips for improving productivity with Redgate products

We recently invited our customers to share their top tips for improving productivity in the first Redgate Tool Tips Swap. This post outlines their hints for using Redgate products to boost productivity and includes relevant training resources to further your learning. SQL Prompt Share formatting settings across your team to consistently format code before... Read more

1 February 2021

1 February 2021

Securing SQL Server with DoD STIGs

Making sure your SQL Servers are secured against malicious users is difficult. How can you know that you’ve done enough? How do you know you’re protected from the things that actually worry you? The United States Defense Information Systems Agency (DISA) publishes a set of guidelines for organizations securing different pieces of software that... Read more

29 December 2020

29 December 2020

Challenges to Database DevOps: Dealing With Drift

Sometimes, people start their DevOps journey by getting their database into source control, but then, they don’t deploy from source control. Instead, they continue their manual deployments to production. Quickly they find that the database code in their production instances and the database code in their source control system don’t match. Alternatively, you may... Read more