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
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
Louis Davidson shows how to use SQL Prompt formatting styles to create and maintain multiple code styles, each for a dedicated purpose, and to switch between them and apply a new style to existing code, with ease. Read more
SQL Compare 12.4 adds the Summary view, a tab that sits alongside SQL view and provides a more concise breakdown of the differences between two objects. Read more
Louis Davidson sticks his neck out and offers his take on a sensible SQL code formatting style, based on twenty-plus years of writing SQL. Starting from SQL Prompt's Default style, he customizes it based on his own list of personal preferences for how SQL code should look. The result is the Louis Davidson custom SQL Prompt style that you can download, try out, and adapt as required. Read more
Jon Hayman reviews how the metrics available in SQL Monitor can help you diagnose problems that might come from SQL Server running in a virtual environment. Read more
Richard Macaskill describes a lightweight copy-and-generate approach for making a sanitized database build available to development teams, using SQL Clone, SQL Change Automation and SQL Data Generator. Read more