Operations | Monitoring | ITSM | DevOps | Cloud

Database Design Best Practices for Optimal Schema & Table Structures

In a world where database management keeps evolving, following database design best practices is crucial to ensure that your database application keeps performing efficiently. A well-designed database creates a thoughtful relationship between tables and schemas. It enhances application performance, making it work faster, and scales effortlessly. On the other hand, if your database is poorly designed, the application is prone to slow performance and scalability issues.

How to Reset Identity Seed After Deleting Records in SQL Server

If you’ve ever deleted records in SQL Server and then noticed your next insert doesn’t start at 1 but maybe jumps to 57, you’ve seen firsthand why it’s important to know how to reseed identity in SQL Server. Identity columns are excellent for auto-generating unique row identifiers; however, they usually don’t reset automatically. This behavior can leave frustrating gaps and disrupt your queries.

Parameterized Queries: Complete Guide to SQL Query Parameterization

In today’s digital world, where data breaches and cyberattacks make headlines daily, protecting your database has never been more crucial. One of the most effective and often overlooked ways is using parameterized queries. This simple yet powerful technique shields your database against malicious attacks and enhances your query performance.

SSMS Tools Pack vs dbForge SQL Complete: A Clash of SSMS Add-ins

Undoubtedly, SSMS is a proven database management and administration tool that does its job well. Yet we all tend to expand our capabilities as much as we can, tailoring this tool to our specific needs. That’s how we get a wide range of SSMS plugins and extensions at our service—each designed to enhance specific aspects of development and administration.

10 reasons to choose Redgate Flyway

Thousands of organizations use DevOps practices every day to deliver application changes. But what about the database? Excluding the database from your software delivery lifecycle risks application performance, data security and integrity. With Redgate Flyway Enterprise, you can solve this challenge with one solution built on best-in-class database comparison technology.

Data Integration Challenges: How to Overcome Common Obstacles in 2025

Data integration challenges are rising as organizations rely on data flowing across cloud, on-premise, SaaS, and legacy systems. According to Salesforce, 80% of IT leaders cite data silos as a top concern. In addition, 72% say overly entangled systems are slowing progress—making it harder to scale, adopt AI, or modernize operations. These issues disrupt real-time workflows, add friction to cross-system processes, and limit an organization’s ability to adapt at speed.

CRM Migration: Key Steps and Best Practices for Success

CRM migration affects far more than just your tech stack—it influences customer relationships, operational agility, and long-term growth. That’s why understanding the strategic considerations behind the process is essential for technical teams and decision-makers. When done right, migration creates a well-integrated, data-driven foundation. When mishandled, it leads to disruption and costly setbacks—and the risk is measurable.

How to Link a SQL Server Database to GitHub Using dbForge Source Control

Looking to connect your SQL Server database to GitHub for version control? This step-by-step tutorial will guide you through the entire process using dbForge Source Control. We'll show you how to create a GitHub repository , create a local folder and clone it via Git — all directly from SQL Server Management Studio with the help of dbForge. Whether you're managing schema updates or collaborating across teams, this video will get you started in minutes.

How to Link a MySQL Database to GitHub with Source Control for MySQL

Did you know you could version-control your MySQL databases with Git — all without leaving your development environment? This tutorial will walk you through the process using the integrated Source Control in dbForge Studio for MySQL By the end of the video, your database will be under full Git-based version control — ready for collaboration ,change tracking , and conflict resolution .

dotConnect for MySQL: The Enterprise-Grade Connector You Can Trust

Supercharge your.NET development with dotConnect for MySQL — the high-performance ADO.NET provider that offers direct connectivity to MySQL and MariaDB.nIn this video, you’ll get a complete overview of how dotConnect for MySQL simplifies data access, enhances productivity, and powers robust applications across the.NET ecosystem. What you’ll see: Whether you're building enterprise apps or data-driven services, dotConnect for MySQL gives you the speed, flexibility, and security you need.

The Gold Standard, Evolved: What's New with PostgreSQL and Why It's Still Your Go-To Database

PostgreSQL, widely regarded as the world’s most advanced open-source relational database, continues to set the standard for performance, scalability, and flexibility in modern data infrastructure. While it has always been a top contender, each new release of PostgreSQL introduces powerful features and enhancements that make it an even more compelling choice for developers, database administrators, and IT leaders alike.

Automated State-based Deployments in Flyway | The Tony and Tonie Show

If your development team delivers the desired end state of a database, but you then struggle to deploy the required changes safely and consistently, Flyway’s new state-based deployments can help. Tony and Tonie discuss how it works and why it helps bring unreliable deployments under control.

Real-Time Data Integration Guide: Best Practices and Architecture

Real-time data integration today is not just about speed—it’s about resilience, consistency, and scalability under pressure. Businesses that master these architectures report up to 23% higher profitability because it moves reliably when it matters most. But building for that kind of reliability is where most systems fall short. Many pipelines labeled “real-time” are only fast until they hit traffic spikes, schema drift, or conflicting data models.

ADO.NET Tutorial: A Comprehensive Guide for Beginners and Professionals

Long before ORMs, LINQ, and high-level abstractions became common in the.NET ecosystem, there was ADO.NET—raw, fast, and unapologetically hands-on. It was the original data access layer for developers who wanted complete control. And two decades later, it’s still the tool of choice when performance, precision, and transparency matter most. But how does it deliver that control?

Celebrating 14K Stars on GitHub: Spring Update

Seeing that VictoriaMetrics products are this popular with engineers worldwide is fantastic: Just a little over a year ago, we hit 10K stars, and with the adoption of VictoriaLogs, the star count now went beyond 14K. We don’t take these GitHub Stars milestones for granted: It’s amazing to see these stats grow organically thanks to the community of users out there who use our products. Thank you so much!

PostgreSQL extensions you need to know in 2025

PostgreSQL is by design lightweight and un-opinionated but its killer feature has long been its extensions ecosystem. The extensions ecosystem adapts and customizes PostgreSQL data storage and manipulation use cases, making it suitable for AI, analytics, document data stores and more. This flexibility keeps PostgreSQL viable as an option for any business or startup, as it’s hard to ‘outgrow’ PostgreSQL.

Redgate Flyway's latest major release: more flexibility, more control

With advances in AI and heightened compliance requirements, the way we handle data is changing rapidly. This makes a robust database change management process crucial for organizations who still need to ship value to market, while getting the right data into the hands of decision-makers faster. It’s a tough set of demands for any organization to grapple with as they modernize their data for the future.

Future-Proof Your MariaDB-Based Services

We’re excited to announce the release of the NiCE MariaDB on Linux Management Pack, designed to deliver advanced monitoring and performance insights for organizations running MariaDB on Linux infrastructure. As MariaDB continues to power business-critical applications across industries, visibility into its performance, availability, and health becomes essential.

Database monitoring in Financial Services: why this high-stakes sector requires a scalable, more comprehensive solution

IT and data teams in Financial Services must meet the more exacting demands for data integrity, compliance, performance, high availability and security that are expected in the sector. These demands require a dedicated, comprehensive, and scalable monitoring solution to help teams succeed in this high stakes environment.

Simple Talks Podcast | S2 Episode 9 - Coffee chat with Carlos Chacon

Carlos Chacon of Marathon Consulting joins Louis for a lively chat about topics far and wide, from the community and podcasts to security and laundromats. Carlos has his own longstanding podcast and, as they came to the end of the interview, he turned the tables on Louis and made him answer some of his own questions too!

State of the Observability Databases with Dee Kitchen (Grafana Office Hours #30)

In this Grafana Office Hours, we talk about the state of observability databases (Grafana Loki, Mimir, Tempo, and Pyroscope) and where they're going. We talk about current and upcoming architectural changes in all four, how we're making them more performant, how compatible they are with OpenTelemetry, and what we're working on next for each database. In this conversation are Dee Kitchen (VP of Engineering for Databases) and Senior Developer Advocates Jay Clifford and Nicole van der Hoeven.

Sensitive Action Log in Redgate Monitor Enterprise

I’m excited to announce a new capability in Redgate Monitor Enterprise: the Sensitive Action Log. As infrastructure becomes more complex, it’s more critical than ever to maintain control over how your monitoring environment is configured and accessed. Whether you’re responding to internal compliance policies, preparing for audits, or simply tightening operational security, it’s key to understand who did what, when.

How to Use SQL Server Filtered Indexes for Better Queries

SQL Server’s filtered index is one of the most effective features for improving query performance and reducing index maintenance. Whether you’re working with big tables that don’t have much data or queries that constantly filter by the same conditions, filtered indexes offer a smart way to focus only on the rows that matter most.

VictoriaMetrics Components: Getting Started

This article introduces the key components of VictoriaMetrics and explains how they work together as part of a complete monitoring system. VictoriaMetrics is a top-tier monitoring solution known for its speed and low-resource consumption. It includes components for monitoring, alerting, data visualization, querying, scraping, incremental backups, and more.

Reducing Database Complexity and Size using Subsetting | The Tony and Tonie Show

Getting realistic test data from large production databases can be a challenge, especially when you're trying to keep dev environments lightweight and secure. Tony and Tonie discuss how subsetting CLI in Redgate Test Data Manager will help you quickly generate smaller, fully representative subsets automatically.

Track MongoDB Performance Metrics Without the Noise

When your MongoDB database slows down, it affects your entire application stack. Performance issues can range from minor inconveniences to major outages, making a solid understanding of MongoDB metrics essential for any DevOps engineer. This guide covers the key performance metrics you need to monitor in MongoDB, how to interpret what you're seeing, and practical steps to resolve common issues.

What Makes dotConnect Data Providers So Powerful?

Supercharge your.NET development with dotConnect data providers! Easily access data from multiple sources — including Oracle, MySQL, PostgreSQL, and more — all within your.NET applications. Whether using ORM or raw SQL, dotConnect gives you robust, secure, and efficient connectivity tools with zero hassle. Watch now to see how it works!y Subscribe to our channel and get dozens of tutorials about Devart tools.

SQL Server Observability: Monitoring, Troubleshooting, and Best Practices

For DevOps teams managing mission-critical databases, SQL Server observability is a fundamental capability that provides comprehensive insight into database performance and health. Effective observability practices enable teams to identify potential issues before they impact end users and provide the context necessary to resolve problems efficiently. SQL Server observability involves collecting and analyzing metrics, logs, and traces to build a complete picture of database behavior.

Best Database Diagram Tools- Free and Paid

Scalable systems thrive on schema clarity—without it, you pay in rework. That’s why 96% of engineers now use visual tools, particularly database diagram tools, to map and manage their databases. Diagramming tools bring structure to complexity. They surface design flaws early, improve collaboration across teams, and turn undocumented systems into shared infrastructure. These advantages are fueling widespread adoption.

Database Protection Guide: Best Practices for Ensuring Database Security

These days, information has enormous power. If you have access to sensitive data, you can do anything with it. It all depends on your imagination. As we know, all data is stored in databases. The reputation, efficiency, and profitability of many companies often depend on the private information they collect and store in databases. One of the most dangerous things that can happen to your database is a data breach.