I want some Moore

Blog about stuff and things and stuff. Mostly about SQL server and .Net
posts - 219, comments - 2287, trackbacks - 33

My Links

Advertisement

News

Hi! My name is 
Mladen Prajdić  I'm from Slovenia and I'm currently working as a .Net (C#) and SQL Server developer.

I also speak at local user group meetings and conferences like SQLBits and NT Conference
Welcome to my blog.
SQL Server MVP

My Books

SQL Server MVP Deep Dives 2
The Red Gate Guide to SQL Server Team based Development Free e-book

My Blog Feed via Email
Follow MladenPrajdic on Twitter


Users Online: who's online

Article Categories

Archives

Post Categories

Cool software

Other Blogs

Other stuff

SQL stuff

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 Database Data:

          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.

- New query template:

           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. :)

 

kick it on DotNetKicks.com

Print | posted on Monday, October 06, 2008 10:59 AM | Filed Under [ .Net SQL Server SSMS Tools Pack ]

Feedback

Gravatar

# 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?
10/7/2008 4:46 PM | SQLDenis
Gravatar

# 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.
10/7/2008 4:58 PM | Mladen
Gravatar

# 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?
10/16/2008 5:25 AM | Jim
Gravatar

# 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.
10/16/2008 10:35 AM | Mladen
Gravatar

# 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



10/27/2008 2:13 AM | Roy Gelerman
Gravatar

# 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.
10/27/2008 10:28 AM | Mladen
Gravatar

# 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".
6/19/2009 10:58 AM | Robert Blomstrand
Gravatar

# 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.
6/19/2009 11:27 AM | Mladen
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET