Operations | Monitoring | ITSM | DevOps | Cloud

Redgate

Managing database security, compliance, and performance | The Tony and Tonie Show

Managing database security, compliance, and performance across a complex estate is no easy task. In this video, Tony and Tonie discuss how Redgate Monitor Enterprise brings all the data you need into one place. They speak about how it helps DBAs track user permissions, ensure configuration compliance, create custom reports, and implement resilient high-availability monitoring, and more.

Inside Perspectives: The growing importance of security and compliance

This is a guest post from Mri Pandit. Information is the cornerstone of business operations, and data is now the most critical asset for any organization. But as reliance on data grows, so do the risks associated with breaches, fraud, and non-compliance. For most organizations, particularly in highly regulated sectors like finance, security and compliance are no longer optional – they’re essential for survival.

Smarter handling of Flyway validation issues | The Tony and Tonie Show

In this video Tony and Tonie discuss the quick way to verify whether a Flyway validation error is a real cause for concern, due to retrospective metadata changes, or just the result of a developer valiantly adding formatting and documentation to improve the code. If the latter, developers can safely run Flyway repair to resume normal migrations.

Inclusive Engineering at Redgate

In mid 2024, one of Redgate’s coaches, Clare, pulled together a team to focus on improving inclusivity within Redgate’s Engineering organisation. This group was designed to work alongside the wider company initiatives, under the guidance of Engineering leadership. Inclusivity is a very broad topic, and the group wanted to avoid becoming overwhelmed with all the possible options.

Tracking and Improving PostgreSQL's Cache Hit Ratio | The Tony and Tonie Show

In this latest episode, Tony and Toney discuss PostgreSQL's buffer cache hit ratio (BCHR), a metric tracked by Redgate Monitor to help you assess the health and performance of your databases. By correctly interpreting this ratio and using it with other relevant memory and IO metrics, you can identify potential bottlenecks in query execution before they impact users.

How Do the Templates in SQL Prompt Enable Team Collaboration - Frank Geisler

Frank Geisler, CEO of GDS Business Intelligence GmbH, explains how the templates in SQL prompt enable team collaboration. SQL Prompt enables users to write high quality SQL faster. As well as autocompleting your code, SQL Prompt takes care of formatting, object renaming, and other distractions, so you can concentrate on how the code actually works..

Introducing AI-Enhanced Data Generation to Redgate Test Data Manager

We’re excited to reveal our latest effort towards simplifying and accelerating the test data management process: AI Synthetic Data Generation, part of Redgate Test Data Manager. Officially introduced in a session at the recent PASS Data Community Summit, the capability uses machine learning to rapidly generate realistic yet entirely synthetic data – all while maintaining data integrity and with data privacy built-in as priority.

Coffee chat with Aaron Bertrand

On this episode of Simple Talks, Louis hangs out with Aaron Bertrand and talks hockey, curling, football, hybrid cars and even some technology. One of the big (non-sports) themes of the episode is that Aaron is a problem-solver and is interested in how issues can be overcome with technology - even if his focus now and in the conceivable future is being a top-level expert with some of the aspects of SQL Server.