The SQL Prompt Functionality Finder

You have SQL Prompt, but are you aware of all the things it can do and how to get it to do it? Phil Factor provides a handy table to make it obvious. Read more

Database provisioning from backups using SQL Clone

A step-by-step guide to creating an image from a database full backup, or from a full backup plus differential backup. Read more

Unearthing Bad Deployments with SQL Monitor and Redgate’s Database DevOps Tools

Sudden performance issues in SQL Server can have many causes, ranging all the way from malfunctioning hardware, through to simple misconfiguration, or perhaps just end users doing things they shouldn't. But one particularly common culprit is when deployments go wrong: I don't know a single DBA who hasn't been burned by a bad release. Read more

SQL Prompt Tip: how to control when the suggestion box pops up

By default, SQL Prompt shows code auto-completion suggestions automatically, and continuously. Phil Factor shows how to control this behavior, for the times when you need it to be a little less intrusive, such as when working through more intricate coding problems that require careful thought. Read more

Bringing DevOps to the database – Moody’s Analytics and SQL Clone

Moody's Analytics had a constant need to provision database copies, particularly for the Test Engineers who needed to run multiple daily database integration and acceptance tests. SQL Clone reduced the time taken to deploy a database copy to minutes, instead of hours. Read more

Protecting production data in non-production environments

Grant Fritchey discusses the need to ‘shift left’ the database and associated database testing, while keeping sensitive data secure when it is outside the production environment, and how SQL Provision can help you achieve this. Read more

General

Tackle common database problems more effectively

While the database is sometimes seen as the blocker in the development process, it doesn’t have to be. With the right knowledge and tools, you can stop problems before they occur, help to speed up development, and reduce errors at deployment time. That’s where the Redgate Hub enters the picture. It’s the one resource you Read more

General

Get a lot more value from your tools

From provisioning databases through to version control, automated deployments and monitoring, Redgate has a tool for every part of the database development process. You probably have a favored tool but if you’ve been using it for a while, you may not be making the most of the latest features. The development teams behind the products Read more

General

Keep your career on track

Whether you’re a DBA responsible for a whole server estate, or a developer who works with databases as part of your job, one of your biggest challenges is keeping on top of the information overload out there. What’s valuable to know? What’s essential for your job? How can you do your job better and smarter, Read more