Product articles
SQL 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 more
Automating 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 moreHow to build multiple database versions from the same source: post-deploy scripts
In Part 2 of his series, Alex Yates shows how to use a combination of post-deployment scripts to handle cases where a code object exists in multiple production instances, but in different states. Read moreQuick SQL Prompt tip – script objects as ALTER in two clicks
Working in a large database can be difficult at times. While many of us might learn the meanings and definitions of most objects, it’s easy to forget the exact ways in which some objects work, or what the behavior is in certain calls. This is one place where having tools that assist you like SQL Read moreFaster SQL Server troubleshooting using SQL Prompt snippets
A good DBA will automate repetitive tasks, but sometimes you need to troubleshoot a problem ‘live’, with people standing over you, and the pressure on. This is something that can’t be automated. SQL Prompt snippets have helped me out in this sort of situation numerous times. Built-in SSMS query shortcuts SSMS provides a few shortcuts 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