- All Topics
- All Topics
- SQL Code Analysis
- Compliant Database Provisioning
- GDPR
- Database Dependencies
- CLI basics
- SQL Formatting and Styles
- Development and Testing with Clones
- SOX
- Development Best Practice
- Team-based Development
- Desktop Development
- SQL Refactoring
- Masking Data for Development and Testing
- HIPAA
- Monitoring cloud and hybrid environments
- Database Deployments
- Source Control
- SQL Code Completion and IntelliSense
- Database Development in Visual Studio
- Cloud-Based Data Management
- Migrating to the cloud
- Database Versioning
- Code quality checks
- Applying hotfixes
- Database Lifecycle Management
- SQL Code Snippets
- SQL Server Monitoring
- Data Masking
- Database Testing and Quality
- Performance Testing
- SQL Toolbelt Essentials
- Database Continuous Integration
- SSMS Tab Management
- Database Documentation
- Data Privacy
- DevOps 101
- Generating migrations
- Unit and integration testing
- Automated Deployment
- Compliant Database DevOps
- Schema Comparison Options
- Data Privacy
- Data privacy and protection
- Automation and workflow
- Testing migration scripts
- Database DevOps
- Monitoring Cloud/Hybrid SQL Servers
- Data Deployments
- Demo
- Test Data Management
- Configuration, Authentication
- DevOps collaboration
- SQL Server development
- Database Testing
- Working with Containers
- Remote working
- Rollback strategies
- Undo migrations
- Database Performance Monitoring
- Query Performance
- Standardized database development
- Continuous delivery
- Datenbank-Monitoring
- Callbacks and placeholders
- Database Build tasks
- .NET application performance
- SQL Server Security
- Audit and Compliance
- Feedback loops
- PostgreSQL
- Deployment checks and safeguards
- Static data
- SQL Server DBA
- Database Builds and Deployments
- Data Classification
- Flyway
- What's new
- CI pipelines
- SysAdmin
- Database Source Control
- Generating Realistic Test Data
- Automation
- SQL Prompt
- Variants, Localization
- Professional Development
- Scheduled SQL Server Monitoring (Disks, Backups, Jobs)
- Database Development in SSMS
- Database monitoring
- AI
- PostgreSQL Monitoring
- Database migrations
- Monitoring Large Estates
- Microsoft Azure
- Database monitoring
- Database challenges
- Tracking development changes
- Integrating with Flyway
- Database Security Monitoring
- AWS
- Database Monitoring
- Database Branching and Merging
- Multidatabase management
- All Types
Super SQL Tips
Tip #19: Restore closed tabs with Tab History
In this tip Data Platform MVP Grant Fritchey explains how to use SQL Prompt to restore your tabs, even if you closed them by mistake!
Case study
Republic Bank – Streamlining database deployments with SQL Compare
Find out how Republic Bank freed up 70-80% of their DBA team's time by switching to SQL Compare for SQL Server database deployments.
Case study
Lumidata – Managing over 500 SQL Server databases
Lumidata uses SQL Compare Pro as part of the SQL Toolbelt. Find out how John Trumbul saved a half-year of a developer's salary in his f…
Video
SQL Change Automation Visual Studio Migrations demo
SQL Server MVP Steve Jones presents a walkthrough of SQL Change Automation, Redgate's tool for making SQL Server database changes in Vi…
Whitepaper
Redgate’s Database DevOps approaches – a comparison
A quick overview of the state-/model-based and migrations-based approaches to Database Lifecycle Management, and the advantages of both…
Video
How to split a column without data loss with migration scripts in SQL Server Management Studio
Technical author Owen Priestley explains how to deploy schema changes that involve data changes safely. He covers how to use migration …
Datasheet
SQL Prompt ROI Guide
See how SQL Prompt helps your development and DBA teams, and how that translates into ROI for your business.
Case study
“We no longer need to memorize column names, and joining tables is now just a click away”
Learn how one development team save time, cut errors, and respond to user requests fast, with SQL Prompt.
eBook
45 Database Performance Tips for Developers
See the SQL Server performance tips and tricks recommended by some of the smartest minds in the Simple Talk community, including SQL Se…
Video
How to pull database changes from a Git remote repository
SQL Server MVP Steve Jones shows you how to pull changes from a Git remote repository straight into SQL Server Management Studio using …
Video
How to push database changes to a Git remote repository
SQL Server MVP Steve Jones shows you how to push changes to a Git remote repository straight from SQL Server Management Studio using Re…
eBook
The Art of XSD
This book starts with the basics of XML schemas and then walks you through everything you need to know, with examples and labs, in orde…
eBook
Defensive Database Programming
The goal of this book is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and …
eBook
The Redgate Guide to SQL Server Team-based Development
This book shows how to use a mixture of home-grown scripts, native SQL Server tools, and Redgate tools to successfully develop database…
eBook
Inside the SQL Server Query Optimizer
This book will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you …
Article
Basic Defence Database Programming Techniques
How to go about producing resilient TSQL code that works, and carries on working under stress.