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.

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

12 November 2020

12 November 2020

Why and how you should automate database migrations

The desire to release features faster and deliver value to customers sooner is prompting many IT teams to adopt DevOps and Agile practices. By automating parts of the development process where possible and working in shorter cycles to release small changes more often, those teams that do well experience fewer errors and produce higher quality... Read more

27 October 2020

27 October 2020

The real challenges of database monitoring

I’ve worked in IT for 30 years, a large part of which has involved managing data and databases. I’m now a SQL Server Enterprise Architect and I manage the direction and operation of a Microsoft Platform Team, as well as the design, build and implementation of a global SQL Server estate. I recently took... Read more

9 September 2020

9 September 2020

Why you should embed monitoring earlier in your Database DevOps cycle

As Gartner recommends in their report ‘Fail Fast in Production; Embed Monitoring Earlier in Your DevOps Cycle’1, it has been shown that it’s possible to provide superior customer experiences by building “instrumentation into the preproduction phase, tracking metrics on availability, performance and service health”. While this particular report focuses on application monitoring, the benefits... Read more