SQL Prompt includes a number of snippets by default that can help you quickly write T-SQL code. These are templates of code that users use regularly. One of the more popular snippets is the “ii” snippet that helps with inserting data into a table. If I type “ii” and hit tab, I quickly get... read more
A while ago, maintaining a reliable database change history was an ongoing problem within our development team. It seemed we were forever asking questions such as “Who made this change?”, “When was the stored procedure last edited?”, “When was this view created?”, and so on. Our initial approach was simply to store a list... read more
A few months ago, we told you about some upcoming changes to our licensing system to make using and managing our products a lot easier. Since then we’ve incorporated user account licensing into the latest versions of several Redgate products (SQL Compare, SQL Data Compare, SQL Source Control, SQL Data Generator, SQL Dependency Tracker, SQL Doc,... read more
Any database developer or DBA who spends much of their working week staring at SQL code quickly becomes set in their ways. They like to see the code laid out in a very particular way. They will struggle to look at, let alone digest and understand, code formatted in a ‘foreign’ style. It’s also... read more
I’m delighted to announce the stable release of SQL Compare and SQL Data Compare 12. We’ve spent hours, days, and months on development, including a beta program and Frequent Updates release to gather and incorporate user feedback along the way. Both releases are packed with a brand new user interface, support for SQL Server 2016... read more
SQL Saturday Cambridge was the first SQL Saturday to be hosted in the UK and, four years on, it’s still a pretty special event for Redgate, as it takes place in our hometown. This year we wanted to give all the attendees and speakers some treats from Redgate. So to make this a reality... read more
In this simple ‘how to’ article, I’ll explain why it’s often useful to be able to create a directory of object-level scripts from an existing database, and then how to create that directory of scripts using SQL Compare. For each object in the database there will be one object build file (*.sql). The scripts... read more
One of the great things about SQL Prompt is that it quickly removes the need to use so many keystrokes. That’s helpful and handy, but to become a really efficient T-SQL coder, you’ll want to practice incorporating a few tricks into your routine. Here’s a good one. Often I run into tables and can’t... read more
Most people involved in database development would agree Database Lifecycle Management (DLM) is a good idea. When implemented correctly, you get a reliable, repeatable and predictable way of delivering database changes and minimize much of the deployment pain associated with manual processes. So why isn’t everyone doing it already? Well, because putting it into... read more
For a time in the late 1800s in America, the offer of a FREE LUNCH! was a way to entice people into a bar. Get some free food, you only have to buy one drink. In short, the food wasn’t free, and it led to the famous saying, There Ain’t No Such Thing As A Free Lunch... read more
