Product articles
Team-based database development with SQL Clone
For most development teams, the database provisioning process involves some element of compromise. Either the process is slow, but the database is realistic or the process is fast but the database unrealistic. Chris Hurley explains why SQL Clone can allow the team to develop and test with a real database, without the compromises. Read more
How to build multiple database versions from the same source: pre-deploy migration scripts
The final part of Alex Yates's three-part series tackles the complicated issue of automating deployments when the same table might have a different structure, in different production versions of the database. Read more
Getting started with SQL Doc and PowerShell
Phil Factor uses PowerShell and SQL Doc to automatically generate database documentation, and update it on every successful build. Read moreSQL Clone and backups protected with TDE – part 2
Steve Jones proves that SQL Clone can create a clone from a TDE-protected SQL Server database backup. Read moreSQL Clone and databases protected with TDE – part 1
Steve Jones proves that SQL Clone can create a clone from a SQL Server database that is protected by Transparent Data Encryption (TDE). Read moreAutomating DacPac deployments using the SQL Compare command line and PowerShell
How to extract a database migration script, or a database build script, from a DacPac and then use it in a PowerShell-automated database deployment. Read moreEliminating ‘noise’ from database deployment scripts
How to eliminate false positives, and avoid making unintended changes to a database, when comparing the schema of two SQL Server databases. Read more
Quick SQL Prompt tip – restore your tabs, even if you closed them by mistake
It’s sometimes too easy to close SQL Server Management Studio (SSMS) without saving your work. It’s also easy to get rid of tabs and scripts that you later wish you had back. SQL Prompt can help with both these problems. Take a look at the Options for SQL Prompt and you’ll find a set of Read moreQuick SQL Prompt tip – picking the columns you need for speedy results
One of the poor practices that I see so many people doing in code is using SELECT *. This is poor practice because it takes more time to complete for clients, it’s an unnecessary use of resources on the client, server and network, and it can fill the buffer cache with rarely-used data. For example, 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