• Redgate Sql Tools
• Redgate Search Tools
• Redgate Free Tool

Redgate Software is a software company based in Cambridge, England. It develops tools for developers and data professionals and maintains community websites such as SQL Server Central and Simple Talk. It conducts events such as SQL in the city.^[1]

Redgate produces specialized database management tools for Microsoft SQL Server, Oracle, MySQL and Microsoft Azure. It also produces advanced developer tools for .NET Framework, such as SmartAssembly and .NET Reflector.^[2][3]

Product page: SQL Search Supported versions: 2012 – 17 Author: RedGate Description: SQL Search is a free add-in for SQL Server Management Studio and Visual Studio 2017, that lets you quickly search for SQL across your databases. Get SQL Search, a free tool from Redgate, which finds SQL in your SQL Server databases, finds all references to an object, and helps you quickly select objects.

From 2007 to 2013 it was featured in the Sunday Times 100 best companies to work for in the United Kingdom.^[4][5][6] It has won numerous industry awards for its SQL Server management software.^{[7][8][9][10]}

History[edit]

The company was founded by Neil Davidson and Simon Galbraith in October 1999.^[11] It is named after Via Porta Rossa (Red Gate Street) in Florence, Italy, close to where Davidson used to live.^[12]

In 2005, Redgate launched Simple Talk, an online technical journal and community hub for working Microsoft SQL Server and .NET developers, as well as systems and database administrators. The journal is sponsored by Redgate,^[13] but retains editorial independence.^[14] In addition to publishing articles, Simple Talk publishes books,^[15] most of which are available in a digital format.^[16]

On 20 August 2008, Redgate announced it was taking responsibility for future development of the free tool .NET Reflector.^[17]

On 22 March 2010, HyperBac Technologies (formerly known as Xceleon Technologies) was acquired by Redgate.^[18] HyperBac developed SQL software tools and products.

In August 2009, Redgate launched Springboard,^[19] a startup incubator based in Cambridge, UK. For a period of three months Redgate provided living expenses and mentoring for teams to work from Redgate's offices. It was similar to Y Combinator and Techstars in that it provided a small amount of capital up front but no equity was taken.

In 2010, Redgate re-launched Springboard with a different model where teams would again receive investment and mentoring, but this time in exchange for an equity stake. One such recipient of investment-for-equity in 2016 was Berlin-based 3T Software Labs,^[20] makers of Studio 3T,^[21] the IDE for MongoDB, a popular NoSQL database.

On March 7, 2017, at the launch of Microsoft Visual Studio 2017, Microsoft announced the inclusion of Redgate Data Tools in that product. Three components were included: ReadyRoll Core and SQL Prompt Core, both in the Enterprise edition of Visual Studio 2017, and SQL Search in all editions.^[22]

Awards[edit]

References[edit]

1. ^'Red Gate Software announce launch of new website'. Telecomworldwire. 29 April 2005. Retrieved 2008-10-01.
2. ^Kanjilal, Joydip (2015-09-29). 'Protect your assemblies using obfuscation'. InfoWorld.
3. ^Kunk, Joe (2010-06-23). 'Experiencing C# from a VB Developer's Perspective'. Visual Studio Magazine.
4. ^'8th: Red Gate Software'. Sunday Times. 4 February 2007. Retrieved 2009-08-22.
5. ^'39th: Red Gate Software'. Sunday Times. 2 March 2008. Retrieved 2009-08-22.
6. ^'81st: Red Gate Software'. Sunday Times. 1 March 2009. Archived from the original on 2011-10-06. Retrieved 2011-02-28.
7. ^ ^abcdefghi'2011 SQL Server Magazine Editors' Best and Community Choice Awards'. SQL Server Pro. 18 November 2011. Retrieved 2 February 2016.
8. ^ ^abcdefghi'2012 SQL Server Pro Editors' Best and Community Choice Awards'. SQL Server Pro. 19 November 2012. Retrieved 2 February 2016.
9. ^ ^abcd'2013 SQL Server Pro Community Choice Awards'. SQL Server Pro. 22 November 2013. Retrieved 2 February 2016.
10. ^ ^abcJacobs, Emily (11 November 2015). 'Visual Studio Magazine Announces 2015 Reader's Choice Award Winners'. PRWeb. Retrieved 2 February 2016.
11. ^'Red Gate roadmap'. Red Gate. Retrieved 2008-10-01.
12. ^'About Red Gate Software'. Red Gate. Retrieved 2011-01-10.
13. ^'Communities, Learning, and Events'. Red Gate Software. Retrieved 26 April 2013.
14. ^'About Us'. Simple-Talk. Simple-Talk. Retrieved 26 April 2013.
15. ^'Books Home'. Simple-Talk. Simple-Talk. Retrieved 26 April 2013.
16. ^'Books'. Red Gate Software. Retrieved 26 April 2013.
17. ^Cramblitt, Bob (2008-08-20). 'The Future of .NET Reflector'. Archived from the original on 2008-08-22. Retrieved 2008-08-20.
18. ^'Red Gate acquires HyperBac'. Archived from the original on 7 January 2011. Retrieved 2 February 2011.
19. ^Davidson, Neil. 'The accidental incubator'. Archived from the original on 25 July 2011. Retrieved 17 January 2011.
20. ^'Leading SQL Server tools company'. Cambridge Network. Retrieved 6 June 2016.
21. ^Fearby, Simon. 'Mongochef renamed as Studio 3T'. Fearby.com. Retrieved 10 February 2017.
22. ^'Redgate Data Tools in Visual Studio 2017'. Retrieved 7 June 2017.
23. ^'DBTA 100: The Companies That Matter Most in Data'. Database Trends and Applications. 2013-06-26. Retrieved 2017-12-31.
24. ^'DBTA 100 2014 - The Companies That Matter Most in Data'. Database Trends and Applications. 2014-06-25. Retrieved 2017-12-31.
25. ^'DBTA 100 2015 - The Companies That Matter Most in Data'. Database Trends and Applications. 2015-06-01. Retrieved 2017-12-31.
26. ^'DBTA 100 2016 - The Companies That Matter Most in Data'. Database Trends and Applications. 2016-06-06. Retrieved 2017-12-31.
27. ^ ^abc'Visual Studio Magazine Announces 2016 Reader's Choice Award Winners'. PRWeb. Retrieved 2017-12-31.
28. ^'DBTA 100 2017 - The Companies That Matter Most in Data'. Database Trends and Applications. 2017-06-15. Retrieved 2017-12-31.
29. ^'Database and Database Management 2017 - SD Times'. SD Times. Retrieved 2017-12-31.
30. ^ ^abcdInc, 1105 Media. 'Visual Studio Magazine Announces 2017 Reader's Choice Award Winners'. GlobeNewswire News Room. Retrieved 2017-12-31.
31. ^'DevOps Industry Awards Finalists, 2017'. DevOps Industry Awards. Retrieved 2017-12-31.

External links[edit]

• Official website
• Simple Talk (technical journal and community hub)
• SQL Server Central (SQL Server education and community website)
• All Things Oracle (technical journal)

Published 10 October 2017

This page explains how to search for objects using SQL Search, how to narrow the scope of a search, and what search syntax is supported.

Opening SQL Search

SQL Server Management Studio

To open SQL Search in Management Studio, click SQL Search in the Redgate toolbar:

If you can't see the Redgate toolbar, enable it by right-clicking in the toolbar area and clicking Redgate.

Alternatively, open SQL Search with Ctrl+Alt+D.

Visual Studio

In Visual Studio, SQL Search can be found in the Tools menu.

How to search

To search, type in the search bar:

Contents:

Search results appear when you've typed two or more characters. The results update as you type.

The first 500 results are shown for each database. If there are more than 500 results, a banner is shown at the bottom of the search results panel:

To see the rest of the results, click Show all.

Searching for an exact word or phrase

Redgate Sql Tools

By default, SQL Search returns objects that contain the search terms you typed anywhere in the object. To search for an exact word or phrase, select Match whole words only.

When using match whole words only, it won't match parts of words or phrases. For example, searching for 'user' won’t return 'username', and searching for 'myTable' won't return '[myTable]'.

Changing the search scope

You can search specific servers, databases, or object types. Select these on the drop-down menus to the right of the search bar:

Wildcards

You can use the following wildcards in a search:

Asterisk (*) wildcard

You can use * as a wildcard to match 0 or more characters, similar to a SQL LIKE clause.

For example, search for 'b*' to find all objects containing words beginning with b.

Question mark (?) wildcard

The ? wildcard to matches exactly one character.

For example, search for 'b?' to find all objects containing words of two characters beginning with b.

List ([]) wildcard

This [] wildcard matches one character from a list of characters.

For example, search for '[xyz] ' to find all objects containing any single x, y, or z character.

This wildcard also allows a range of characters. For example, search for '[a-z]' to match any single character from a to z.

Caret (^) wildcard

You can use ^ as a wildcard at the beginning of a list to match any character except any character in the list.

For example, search for '[^0-9]' to match any single character except a numeric character.

Escaping wildcards

If you want to search for a wildcard as a literal character, you can escape the wildcard character by wrapping it in square brackets.

For example, searching for '[*]' will search for anything containing an asterisk.

Please note that this does not work with square brackets themselves.

Search limitations

Object Type Limitations

When searching in 'Other' object types, SQL Search doesn't find some object types, including roles, certificates, and full-text catalogs.

This is because it only indexes objects in the following Object Catalog Views:

• sys.objects
• sys.sql_modules
• sys.check_constraints
• sys.default_constraints
• sys.computed_columns

Any object types that aren't in these views won't be found by SQL Search.

Square Brackets

Redgate Search Tools

Square brackets around identifiers are filtered out of the index we create to provide fast searches, so you can't match on them even if you are using wildcard matching and escape them.

Redgate Free Tool

Didn't find what you were looking for?