Login or Sign Up to become a member!

EXPERTS, INFORMATION, IDEAS & KNOWLEDGE

Social bookmarker Add this

Your profile

Search

January 2009
Mon Tue Wed Thu Fri Sat Sun
 << <   > >>
      1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31  

XML Feeds

Authors

Tags: tools

The Data Management Journal

SSMS Tools PACK 1.1 - now with SQL Server Management Studio 2008 support

by SQLDenis


Permalink 07 Oct 2008 10:31 , Categories: Data Modelling & Design Tags: sql server 2008, sql server management studio, tools

Mladen Prajdić has updated his SSMS Tools PACK to work with SQL Server 2008.

Here are some of the cool new things



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

Download SSMS Tools PACK 1.1 here: http://www.ssmstoolspack.com/Download.aspx

3 comments »Send a trackback » 537 views

Get A Free SQL Server 2008 Ebook

by SQLDenis


Permalink 04 Sep 2008 08:32 , Categories: Data Modelling & Design Tags: book, products, red gate, tools

Download a trial version of Red Gate’s SQL Toolbelt 2008 and get Brad’s Sure Guide to SQL Server 2008 for free

Products included in the SQL Toolbelt 2008:

SQL Compare Pro
SQL Data Compare Pro
SQL Packager Pro
SQL Prompt Pro
SQL Doc Pro
SQL Backup Pro
SQL Data Generator
SQL Dependency Tracker
SQL Refactor
SQL Multi Script
SQL Comparison SDK

I have been using Red Gate’s products since 2002 and must say that they have saved me tons of work/time many times.

Here is the link to the site: Brad’s Sure Guide to SQL Server 2008

1 comment »Send a trackback » 560 views