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.
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.
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.
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.
VictoriaMetrics at FOSDEM, Cloud Native Days France, and CfgMgmtCamp Ghent
Last week, members of the VictoriaMetrics team, including myself, spoke at three very different but equally important community events: FOSDEM in Brussels, Cloud Native Days France in Paris, and CfgMgmtCamp in Ghent. Each event drew a different crowd with its own expectations, making them a good way to see where open source observability stands today and how VictoriaMetrics is adapting to real-world needs. The talks we gave were snapshots of the problems we are actively working on.
AI Query Assist for SolarWinds Database Performance Analyzer
Is your database slow? Let AI do the heavy lifting. Watch how SolarWinds DPA’s AI Query Assist transforms query tuning from a manual headache into a streamlined process. This demo shows you how to get instant, AI-powered recommendations for your worst-performing queries while maintaining the control to review and verify every fix. It’s not just about finding the problem—it’s about fixing it faster.