The ROI of SQL Prompt
Find your personal ROI in under 1 minute. And see how many working days you and your team could save in coding time with SQL Prompt!
2024-12-20
Redgate Software
Why customers love SQL Prompt
SQL Prompt has long been a customer favorite thanks to its ability to boost productivity. Discover how fellow database professionals are leveraging SQL Prompt to accelerate their coding speed and improve code quality.
2024-10-04
The full agenda for the Redgate Summit New York is live!
The full agenda for the Redgate Summit New York is live! Join us to stay ahead of the curve and gain valuable insights from industry experts like Bob Ward (Microsoft), Mri Pandit (Navy Federal Credit Union), Erik Darling (Darling Data), Steve Jones (Redgate Software), and many more.
2024-08-07
Redgate Summit: The Database Landscape - New York
Join Redgate at the last Redgate Summit event of the year! This series of events is hosted across the globe for data professionals who want to improve their skills and knowledge about Database DevOps, learn about topics surrounding the Cloud, AI, and working across multiple databases.
2024-08-02
Four steps towards tackling the complexity of managing multiple database platforms
79% of us are now using two of more database platforms - fantastic for leveraging a range of benefits, but not so great when it comes to levels of complexity. Looking for ways to overcome this? Here are four steps to take towards multi-database simplicity.
2024-07-17
Prompt+ EAP: your AI-powered database development partner in the making
Last year, we introduced AI capabilities to SQL Prompt via the Prompt+ Early Access Program (EAP). Using generative AI-powered insights and context-based awareness, Prompt+ takes natural language queries and turns them into SQL coding suggestions. Check out this blog to learn more about Prompt+ and how to join the EAP waitlist.
2024-07-15
Redgate recommended in Bloor Test Data Management market update
Last year, Redgate announced the launch of their latest in test data management (TDM) technology – Redgate Test Data Manager. This year, they’re proud to have been recommended in Bloor’s 2024 Test Data Management Market Update! This paper highlights the increasing adoption of TDM technology among enterprise organizations and offers insight into the trends and approaches to look out for when looking for a TDM solution.
2024-07-10
Is your organization using MongoDB? Help the Redgate Flyway team understand your pain points.
Is MongoDB in use within your organization? The Flyway development team is adding MongoDB support into Flyway and would like to better understand the current pain points. If you are able help, or are interested in finding out more, please participate in our 5-minute survey.
2023-11-17
Is your organization using MongoDB? Help the Redgate Flyway team understand your pain points
Is MongoDB in use within your organization? The Flyway development team is adding MongoDB support into Flyway and would like to better understand the current pain points. If you are able help, or are interested in finding out more, please participate in our 5-minute survey.
2023-11-10
How We Ate Our Own Dog Food To Level-Up Internal Testing with Redgate Clone
Most applications have large and complex databases at the back end, making it hard for developers to adequately test their work before it goes out. Having a fast, repeatable process to deliver data on demand is an essential part of an effective software development lifecycle, ultimately leading to improved customer satisfaction. In this article, we’ll explore the journey our own engineering team went on to leverage our own tool, Redgate Clone, to spin up short-lived database instances in containers for automated testing.
2023-10-25
Blogs
Copying an Azure SQL database between two Azure SQL Instances in two different subscriptions.
I recently had to copy an Azure SQL database (SQL db) from one subscription...
A field note: AI Ambition vs. Operational Reality in 2025
Ivan Jelić, Group CEO at Joyful Craftsmen, reflects on what separates AI success from...
Redefining Tech Leadership in the Age of Microsoft AI
By Chris Yates
AI is no longer a niche capability – it is a leadership catalyst. As...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
SQL Server Columnstore Index Fragmentation
Comments posted to this topic are about the item SQL Server Columnstore Index Fragmentation
do i lose "what this object depends on" etc when moving sprocs to etl server
Hi i was surprised to see the approach my coworkers used to sunset talend...
Question of the Day
SQL Server Columnstore Index Fragmentation
The columnstore index is absolutely different than the traditional rowstore b-tree index. Because of this, it doesn't suffer from the same kind of fragmentation across pages as the b-tree index. Yet, it does suffer from a type of fragmentation brought about by an excess of deleted rows in a rowgroup and a lack of compression of storage because more things are in the delta store. While b-tree indexes use dm_db_index_physical_stats to show fragmentation, which system tables or DMVs can be used in SQL Server (prior to SQL Server 2025) to determine columnstore fragmentation?
See possible answers