Database Indexing: How It Works, Types, and When to Use It
How database indexes work, when to use B-tree vs hash indexes, clustered vs non-clustered indexes, and how to tell if your indexes are actually helping.
Operations | Monitoring | ITSM | DevOps | Cloud
The Place Where Modern Operations & Technology Come Together
The latest News and Information on Databases and related technologies.
Database Security Failures Don't Start in Security Teams
When a database security incident happens, everyone turns to the security team. We look for a simple root cause analysis, and then we add a control, tighten a policy, and maybe even buy a silver bullet tool. We feel progress! But the incident didn’t start there. It started years earlier, when the organization made a series of perfectly reasonable decisions that quietly expanded the surface area and weakened the consistency of control.
Redgate Flyway's Product Updates - February 2026
This month’s highlights include smarter dependency handling in Flyway Desktop, and a look at how we’re starting the year strong for Oracle users. Plus: last call to share your feedback in our Flyway user survey (the prize draw closes soon!).
Control your dependencies in Flyway Desktop for Oracle and SQL Server Databases
This is a guest post from Stephanie Herr. One of Flyway’s biggest strengths is its ability to track your database schema as individual SQL DDL scripts on disk. This gives you full version control over every object, along with a complete audit trail of what changed, who changed it, when it changed, and why. For teams working with Oracle and/or SQL Server, this level of transparency is essential and this latest release provides even more support for how you handle changes across dependent objects.
Redgate Test Data Manager Product Updates - January 2025
This is a guest post from James Hemson. The January release of Redgate Test Data Manager brings the launch of our free trial, a completely redesigned installation experience, and powerful new workflow capabilities. These updates make it faster to get started and easier to automate your data provisioning pipelines.
Compliant Test Data Used to Be Hard. It Isn't Anymore.
This is a guest post from Saskia Parks. If you're exploring test data management (TDM) solutions, you probably know your current practices aren't ideal, but you're skeptical investing in a solution is worth the budget and effort. We hear the same concerns. The perception is that proper TDM is expensive, complicated, and takes months of painful implementation.
Install and Activate dotConnect in Visual Studio & Any IDE
Learn how to install and activate dotConnect products step by step. In this video, we show all available installation options—including NuGet Package Manager, command-line installation in any IDE, and the Windows installer for full Visual Studio integration. You’ll also see how to activate dotConnect using a license key, including how to get a free 30-day trial key from the Devart Customer Portal. This guide helps you.
Redgate Flyway, Oracle, and the Case of the Lowercase Schema
If you’ve spent any time working with Oracle databases, you’ve probably internalized a few expectations so deeply that you don’t even think about them anymore. One of the biggest is this: Database users, tables, views, and metadata are in UPPERCASE. So, when you query the database directly, no matter if using SQL*Plus, SQLcl,SQL Developer, or any other tool, you’re going to format your query in a common way.
dotConnect for Dynamics 365 | Secure C# ADO.NET connection with ORM support
Integrate Microsoft Dynamics 365 into your C# .NET applications with dotConnect for Dynamics 365—a powerful, high-performance data provider built for secure enterprise connectivity. From workflow automation to CRM data synchronization, dotConnect enables reliable access with seamless Visual Studio integration and advanced ORM support for modern development workflows. Chapters: Try it free for 30 days and see why thousands of developers trust dotConnect for Dynamics 365 in mission-critical environments.
Rollback vs Roll Forward in Databases
Rollbacks act as an ‘undo’ for databases, but why are they important, what happens if you can’t roll back, and how do you prevent even needing to in the first place? Steve, Kellyn, Grant & Pat try to answer these questions – and more. Recorded on-site at Redgate HQ in Cambridge, UK.