Security and compliance
Ensure data security and compliance with data masking, monitoring, and change traceability
Database monitoring and observability
Monitor and understand your databases with full visibility into performance and change
Database change management
Build, test, and deploy database changes with confidence
Productivity and workflow automation
Simplify and speed up database development workflows
AI data readiness
Prepare reliable data foundations for AI initiatives
Database modernization
Simplify and secure database modernization across platforms
Efficiency and cost optimization
Control costs and boost efficiency in database operations
Cloud migration and workload optimization
Simplify and speed up cloud database transformation
Product articles
Exploring the SQL Compare Options
You need to compare database schema objects in two SQL Server databases, and then automatically generate a SQL deployment script that when executed will remove these differences, either making the schema of the target database match the source, or vice-versa. It sounds easy, but the problems lie in the details of the schema comparison options. Read more
Using SQL Data Compare to Sync Reference Data
Let's say your QA team maintain two similar test databases. They run tests to verify that different versions of the same application still produce the same, correct results. Therefore, any differences in the test data, between the two databases, needs to be corrected before the tests start. This is the sort of task for which SQL Data Compare is ideally suited, and Bob Sheldon explains how it all works. Read more
SQL Prompt Snippets to Drop Columns and Tables and Handle Associated Dependencies
Louis Davidson provides a pair of SQL Prompt snippets that will help you deal with dependencies, whenever you need to drop columns or tables. Read moreHandling System-named Constraints in SQL Compare
If some of your database constraints have system-generated names, they can cause 'false positives' when comparing schemas and generating build scripts using SQL Compare or SQL Change Automation. Phil Factor explains the difficulties, and the Compare option you need to enable to avoid them. Read more
Database Source Control in Azure Data Studio
How developers who were previously writing and managing database source code in SSMS can make a smooth transition to Azure Data Studio. Read more
SQL Server Licensing and SQL Monitor
How well do the SQL Server licenses you own match up with what you need for your current use? William Durkin explains how to use SQL Monitor to find out. Read moreWhen SQL Server Performance goes Bad: the Fill Factor and Excessive Fragmentation
Phil Factor on the fill factor, pages splits and index fragmentation, and how SQL Monitor can help you decide if a custom fill factor for certain indexes might help alleviate performance issues. Read moreTesting SQL Server Stored Procedures and Functions with SQL Data Compare
Phil Factor demonstrates a cunning way to test stored procedures or functions, such as after refactoring, by storing the 'before' and 'after' results in views and then using SQL Data Compare to spot any discrepancies. Read moreHow to cope with Database Drift during Deployment using SQL Compare
Phil Factor on how to cope with any database drift that results from various checks and tests and fixes made during deployment. Read moreThe Database Development Stage
Phil Factor distills the basic tasks of the database development stage and explains how SQL Compare can help tackle them. Read moreRedgate Hub
-
Product Articles
Tips and how-to guides for Redgate products
-
University
Easy to follow video courses
-
Events
Join us online, or get sponsored
-
Forums
Ask, discuss, and solve questions about Redgate's tools
-
Community
Develop your skills and meet Redgate Advocates and Friends
-
Simple Talk
In-depth articles and opinion from Redgate's technical journal