A quick demonstration of using Flyway with Oracle, for those of a nervous disposition. We'll use Flyway to run some migrations on an Oracle Autonomous Database, building the initial version of the database then filling it with development data.
2023-02-15
Once data is in a table it needs to be maintained....
2023-02-15
An interesting conversation with the ChatGPT artif...
2023-02-13
13,287 reads
This tip illustrates graphical and statistical tec...
2023-02-13
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.
2023-02-13
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.
2023-02-10
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.
2023-02-10
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.
2023-02-08
7,097 reads
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.
2023-02-08
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.
2023-02-08
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Comments posted to this topic are about the item The Power of Data and...
Comments posted to this topic are about the item What's the Date?
Comments posted to this topic are about the item Two New Shortcuts for Fabric...
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers