SSMS Tools PACK 1.1 - now with SQL Server Management Studio 2008 support
With this new version you can use it for SQL Server Management Studio 2008 and SQL Server Management Studio 2008 Express.
I've added a new feature to Search through the Database data. There are times when you'd like to find some value but can't remember in which table it is.
Also the SQL Query History Log Viewer has been remodeled. I'm open to suggestions on how to improve it further.
You can also have the SSMS Tools Pack installed for both SSMS 2005 and SSMS 2008 on the same machine, however they don't share the same settings.
I would also like to turn to you dear reader to help me find a good logo for your favorite tool right here.
Since this is a completely free product I'm not in a position to pay anything but I would be more than glad to splash your name with praise all over the front page. :) Thank you for any and all input.
In SSMS Tools Pack 1.1 you can find these features
- Query Execution History (Soft Source Control) and Current Window History:
Save all executed queries to file or database and easily find them.
Current window history is a dockable window that show queries executed in a currently active window. There is also a search box at the top that filters results as you type
Search for a value in all non-binary columns in all tables in the database
- Uppercase/Lowercase keywords:
Set all keywords to uppercase or lowercase letters. Custom keywords can be added. Doesn't check comments, text and quoted text anymore.
- Run one script on multiple databases:
Run selected or full window text on selected databases on the currently connected server.
- Copy execution plan bitmaps to clipboard:
Copy selected or all execution plans to a bitmap that is saved on the clipboard.
- Search Results in Grid Mode and Execution Plans:
Find all occurrences of your search string in the execution plans or in the results in datagrid mode.
- Generate Insert statements for a single table, the whole database or current resultsets in grids:
Generate insert statement from your data.
- Text document Regions and Debug sections:
Add Regions and Debug section in your scripts to ease development experience.
- Running custom scripts from Object explorer's Context menu:
Speedy execution of custom scripts from Object Explorer's context menus.
- CRUD (Create, Read, Update, Delete) stored procedure generation:
Generate Customizable CRUD stored procedures for all tables in your database.
Create a template that is shown when creating a new query window.
Currently supported SQL Server Management Studio versions are:
SQL Server Management Studio 2008 and SQL Server Management Studio 2008 Express
SQL Server Management Studio 2005
SQL Server Management Studio 2005 Express
Hope you enjoy it!
And if you're feeling extra generous there's always PayPal. :)
Legacy Comments
|
SQLDenis
2008-10-07 |
re: SSMS Tools PACK 1.1 - now with SQL Server Management Studio 2008 support Mladen, that is cool, I am sure a lot of people will like the "Search for a value in all non-binary columns in all tables in the database" functionality Did you include that because of the recent SQL injection attacks which would put JavaScript in the tables? |
|
Mladen
2008-10-07 |
re: SSMS Tools PACK 1.1 - now with SQL Server Management Studio 2008 support thanx Dennis. no, acctually i needed it for one of our databases i wasn't familiar with. but it does come in handy for injection stuff too. |
|
Jim
2008-10-16 |
re: SSMS Tools PACK 1.1 - now with SQL Server Management Studio 2008 support Whenever I first open a new query in SSMS 2005, the search toolbar pops up and moves things down a row. It's a little annoying, and doesn't seem to remember its position if I move it and restart SSMS. Is there anyway to stop it showing altogether? |
|
Mladen
2008-10-16 |
re: SSMS Tools PACK 1.1 - now with SQL Server Management Studio 2008 support @Jim: no unfortunately this isn't possible in this version, but i'm working on it. the problem is that i use temporary commandbar objects instead of permanent ones because permanent one have some issues with uninstalling. |
|
Roy Gelerman
2008-10-27 |
re: SSMS Tools PACK 1.1 - now with SQL Server Management Studio 2008 support can you add a SQL Formatter. Give us a few options, such as CRLF before FROM, WHERE, ORDER BY CRLF between AND and OR clauses CRLF and INDENT for EXISTS or IN clauses optional placement of comma at end of line, or beginning of next line in the projection |
|
Mladen
2008-10-27 |
re: SSMS Tools PACK 1.1 - now with SQL Server Management Studio 2008 support so how much should i start charging for it? :))) well i'm kind of working on it but it will be a while before i release a new version. |
|
Robert Blomstrand
2009-06-19 |
re: SSMS Tools PACK 1.1 - now with SQL Server Management Studio 2008 support I would also REALLY love some sort of SQL formatter as per Roy. I cannot find anything like this for SQL server. PL/SQL Developer for Oracle has a great prettifier/formatter. With a single key-combination one can convert something like; select code, Descript, field1, field2 from mytable where batchtype = 'Invoices' order by code to something so much more legible; SELECT code, Descript, field1, field2 FROM mytable WHERE batchtype = 'Invoices' ORDER BY code I would see this functionality being part of the existing "Format Text". |
|
Mladen
2009-06-19 |
re: SSMS Tools PACK 1.1 - now with SQL Server Management Studio 2008 support i sure you can see it as part of the text format. i see it there too. but i just don't feel like creating an SQL text Parser engine for this just yet. if you have one send it over and i'll put it to good use :) in the meantime you can use a free sql formatter by ApexSQL which is also an ssms add-in. google for it. |