An Introduction to Assessing Normal Distribution with Python

This tip illustrates graphical and statistical tec...

How do your DevOps plans really measure up?

Digital transformation seems to be on the to-do list of every organization at the moment. Alongside it, DevOps is one of those buzzwords that gets lumped in, with some vague intention of having things automated. If you’re championing a DevOps implementation in your organization, or wish to see where your current processes measure up against your peers, read on.

Join Redgate at SQL Bits, March 15-18

SQL Bits is coming to Wales, home of dragons and D&D, and we’re happy to announce we’re supporting them as platinum sponsors again this year. Meet us at our Red Keep and catch sessions by noble Fighter Grant Fritchey, Sorcerer Steve Jones, and more beloved Redgate Paladins and Druids. For a magical 10% discount on your ticket, use 10REDGATE from our spell book.

Steps to add a new disk to SQL Server failover cluster instance and move a user database to it

In this article, we look at the steps to add another disk to an existing Windows Failover Cluster used for SQL Server and also how to move an existing database to this new disk.

A Version Control Strategy for Branch-based Database Development

The migration to a different VCS should not be underestimated, as there is a lot more involved than just switching tools, and that’s what Tonie Huizer covers in this article.
First, the team needed to migrate the monolithic repos over to Git, second the team needed to make sure we had a branching strategy and workflow in place.
It involved a big process change for the team as well, but this switch is mandatory to make full use of branch-based database development.

A Simple Example of Flyway Development using GitHub Branching

This article demonstrates one way to do branch-based database development with Flyway, using GitHub to manage the branches and Flyway configuration files to allow Flyway to switch smoothly between databases, when we move between branches in GitHub.

Index Types in PostgreSQL: Learning PostgreSQL with Grant

In this article I’m going to go over the different types of indexes and some index behaviors. We’ll get into what the indexes are, how they work, and how best you can apply them within your databases. I’m hoping you’ll develop an understanding of which indexes are likely to work better in each situation.

Privileges and Roles in SQL Server, Oracle and PostgreSQL - Part 1

This tip will review the different ways of granting privileges in SQL Server, Oracle, and PostgreSQL, the differences in the concepts of roles, schemas, and owners, and the way to grant permissions on the whole schema.

Schedule Jobs on a Clustered SQL Server

In this article, you will learn how you can schedule jobs in a clustered environment that will only execute on the primary node.

The Database DevOps Transformation

Digital transformation is a buzzword that is often thrown about. But what isn’t discussed in depth, is how DevOps fits into the initiative and what the pitfalls are.

This on-demand session answers these questions and provides actionable takeaways from real-life database deployment automation projects.

You’ll also hear how the key trends in Database DevOps have influenced Flyway product development.