/ciol/media/agency_attachments/c0E28gS06GM3VmrXNw5G.png)
Follow UsCAMBRIDGE, UK: The Red Gate development team has released SQL Prompt 3.5, an upgrade for SQL Prompt 3.0 that was introduced six months ago. The SQL Prompt 3.0 delivers support for cross platform database and distributed queries over linked servers, a five-fold increase in speed, 95 percent less memory use and a host of improvements to the behaviors of the candidate list, according to a release from the company.
SQL Prompt is a T-SQL code-completion add-in for Visual Studio, Management Studio, SSMS Express Edition and Query Analyzer. It intelligently anticipates the code candidates that SQL Server professionals need as they’re writing, enabling faster, error-free T-SQL queries.
“SQL Prompt 3.5 is a major upgrade in point-release clothing,” says Bart Read, the product’s lead developer. “The previous version had some difficulties with very large databases, which made it slower loading the meta data. But that’s all cleared away with this version.”
The most-requested new feature available in SQL Prompt 3.5 is support for cross-database and distributed queries over linked servers, which is especially beneficial for organizations with complex SQL queries that run across multiple servers.
A real-time demo on the Red Gate web site shows SQL Prompt 3.5 saving up to 60 percent on straight typing, claims the release.
A cleverer SQL brain:
The SQL Prompt 3.5 candidate list has been upgraded in at least half a dozen ways, making it “much cleverer” according to Read. Among the improvements are the foreign keys that are tracked so more aptly that code candidates can go to the head of the candidate queue.
SQL Prompt 3.5 also supports Visual Studio 2005, making it accessible to a wider user community.
“This is a fantastic time-savings tool for all those web application developers who get the default ‘SQL guy’ moniker applied in the office but who actually prefer to spend as little time as possible dealing with the database,” says Read. “SQL Prompt 3.5 is like having your very own prosthetic SQL brain,” he adds.