Ssms Tools Pack Feedhttp://www.ssmstoolspack.com/SSMS Tools Pack Add-In for SQL Server Management Studio(c) 2018, Mladen Prajdić. All Rights Reserved.http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 4.5 is out with full support for SSMS 17 and various feature improvements.<p><strong><a class="DownloadLink" href="https://msdn.microsoft.com/library/mt238290.aspx">Full support for SSMS 17</a></strong><br />
All reported issues during the beta support have been resolved.
</p><p><strong><a class="DownloadLink" href="http://ssmstoolspack.com/Features?f=2">Connection Coloring</a></strong><br />
Connection Coloring is now improved by coloring the server/database in Object Explorer as well.<br />
This way you can always see if you're working on the correct server/database.
</p><p><strong><a class="DownloadLink" href="http://ssmstoolspack.com/Features?f=14">SQL Editor Plus</a></strong><br />
Auto-rename window tab text has been extended with option to rename the tab to<br />
either the first line in the executed T-SQL script or the next non-empty line after<br />
the user-set line in the executed T-SQL script if the user-set line is empty.
</p><p><strong><a class="DownloadLink" href="http://ssmstoolspack.com/Features?f=17">Export to Excel</a></strong><br />
Full support for correctly exporting Unicode characters not in extended ASCII set into an Excel file.
</p><p><strong><a class="DownloadLink" href="http://ssmstoolspack.com/Features?f=12">CRUD Generator</a></strong><br />
Update stored procedure is NOT generated if there are no updateable columns in the table.
</p>Mon, 09 Oct 2017 00:00:00 +0200http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 4.2 is out with beta support for SSMS 17 RC1, new features and minor bug fixes.<p><strong><a class="DownloadLink" href="https://msdn.microsoft.com/library/mt238290.aspx">Beta support for SSMS 2017 RC1</a></strong><br />
Beta support for <a class="DownloadLink" href="https://msdn.microsoft.com/library/mt238290.aspx">SSMS 17 RC1</a>. Due to beta status this might have various bugs.
Since SSMS 17 RC1 has just been released and is not recommended for production use the SSMS Tools Pack<br />
for it might run into various issues as well. They will be worked out as the SSMS 17 gets more stable.
</p><p><strong><a class="DownloadLink" href="http://ssmstoolspack.com/Features?f=14">SQL Editor Plus</a></strong><br />
New Run At element in query window status bar with starting time of the executed query.<br />
Auto-rename window tab text to the Nth (user-defined) line in the executed SQL script.<br />
Automatically connect to the database with the same name when switching servers.
</p><p><strong><a class="DownloadLink" href="http://ssmstoolspack.com/Features?f=3">SQL History</a></strong><br />
Tab Sessions UI improvements when scrolling through items.
</p><p><strong><a class="DownloadLink" href="http://ssmstoolspack.com/Features?f=17">Export to Excel</a></strong><br />
Export folder defaults to %AppData%\SSMSToolsPack.
</p><p><strong><a class="DownloadLink" href="http://ssmstoolspack.com/Features?f=16">Other Minor Features</a></strong><br />
On first run the settings are imported from the last automated backup if it exists.
</p>Mon, 28 Nov 2016 00:00:00 +0100http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 4.0 is out. Full support for SSMS 2016 RTM.<p><strong>Full Support for SSMS 2016 RTM</strong><br />
Full support for SSMS 2016 RTM which came out June 1st 2016.
</p><p><strong><a class="DownloadLink" href="http://ssmstoolspack.com/Features?f=14">SQL Editor Plus</a></strong><br />
Renamed tabs get the custom name stored and properly restored in the <a class="DownloadLink" href="/Features?f=3">SQL History's Tab Session</a>.
</p><p><strong><a class="DownloadLink" href="http://ssmstoolspack.com/Features?f=15">Global Replacement Texts</a></strong><br />
Now you can have nested replacement texts that are properly evaluated up to 10 levels deep.
</p><p><strong><a class="DownloadLink" href="http://ssmstoolspack.com/Features?f=9">Insert Statements Generator</a></strong><br />
It can now also script views. Added an option to add column names to each scripted SELECT statement.
</p><p><strong><a class="DownloadLink" href="http://ssmstoolspack.com/Features?f=17">Export to Excel</a></strong><br />
It can now also export views to Excel.
</p>Wed, 15 Jun 2016 00:00:00 +0200http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 3.8.7.0 is out. Excel export improvements and bug fixes, and Run Custom Scripts from Object Explorer improvement.<p><strong><a href="http://ssmstoolspack.com/Features?f=17">Export to Excel:</a></strong><br />
Fixes for dates not showing properly in Excel 2007, exporting XML from the results grid,
and an error when doing multiple exports in parallel.
</p><p><strong><a href="http://ssmstoolspack.com/Features?f=11">Run custom scripts from Object Explorer:</a></strong><br />
You can now order the scripts shown in the context menu in the feature's Options.
Simply change the index and it will be sorted in the ascending irder of that index.
Custom text can now be set inside the colored bar for each server/database.
</p>Sat, 30 Apr 2016 00:00:00 +0200http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 3.8 is out. New Excel Export feature, support for SSMS 2016 RC1 and various feature improvements.<p><strong><a href="http://ssmstoolspack.com/Features?f=17">Export to Excel:</a></strong><br />
Properly export result sets, one or multiple tables or the whole database to Excel files.
This feature doesn't need Excel installed to work. It correctly converts SQL Server data types
to Excel data types, supports exporting unlimited table rows and creates a valid XLSX file.
</p><p><strong><a href="http://ssmstoolspack.com/Features?f=2">Window Connection Coloring:</a></strong><br />
Custom text can now be set inside the colored bar for each server/database.
</p><p><strong><a href="http://ssmstoolspack.com/Features?f=1">SQL Snippets:</a></strong><br />
Exporting and importing SQL snippets has been improved with snippet selection.
You can now choose which snippets to export/import. This gives extra customizable flexibility.
</p><p><strong><a href="http://ssmstoolspack.com/Features?f=14">SQL Editor Plus:</a></strong><br />
The Accidental Data Destruction Protector can now ignore temporary tables.
</p><p><strong><a href="http://ssmstoolspack.com/Features?f=16">Default Settings Deploy:</a></strong><br />
Default Settings Deploy now auto-detects and auto-deploys new centrally created settings file.
</p><p><strong>Support for SSMS 2016 RC1:</strong><br />
With each new SSMS 2016 version the compatibility might break.
The next update will be for the fully released SSMS 2016.
</p>Mon, 28 Mar 2016 23:00:00 +0200http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 3.6 update is out with support for SSMS 2016 CTP's and new database data search.<p><strong>Support for SSMS 2016 CTP 2.3 and up:</strong><br />
With each new SSMS 2016 CTP the compatibility might break. Future updates will come as soon as possible.
</p><p><strong><a href="http://ssmstoolspack.com/Features?f=5">Search Database/Table Data:</a></strong><br />
Completely new Search dialog with the ability to filter on table names, column names and column data type groups.
</p>Wed, 07 Oct 2015 23:00:00 +0200http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 3.5.1.0 update is out with fixes for two small non-critical bugs.<p>
Version 3.5.1.0 fixes two non-critical bugs:<br />
- An exception is shown when opening a Licensing Options window when NO valid license exists.<br />
- Run Script On Multiple Targets now also correctly shows auto-closed databases.
</p>Tue, 05 May 2015 08:00:00 +0200http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 3.5.0.0 is out with a NEW feature, a few improved features and various bug fixes.<p>
New feature is called <a href="http://ssmstoolspack.com/Features?f=15">Global Replacement Texts</a>. It gives you the ability to add custom replacement texts to your scripts in four different features.<br /><br /><a href="http://ssmstoolspack.com/Licensing">Licensing</a> now gives you the ability to upgrade your existing license from the previous major version. This upgrade path is around 30% cheaper than buying a completely new license.<br /><br /><a href="http://ssmstoolspack.com/Features?f=14">SQL Editor Plus</a> has been extended with 2 new functionalities:<br />
- Rename Window Tab by right clicking on your window's tab.<br />
- Data Destruction Protector now protects against accidental DROP TABLE.<br /><br /><a href="http://ssmstoolspack.com/Features?f=3">SQL History</a> has a bug fixed that it didn't save on every interval when using Save to Database functionality.<br /><br /><a href="http://ssmstoolspack.com/Features?f=5">Search Database Data</a> now has column type choice like search through all textual or numeric columns, etc.<br /><br /><a href="http://ssmstoolspack.com/Features?f=16">Other Minor Features</a> have been improved like:<br />
- Easier distribution of pre-configured add-in settings to new users with Default Settings Deploy.<br />
- Full compatibility with built-in accessibility color schemes for visually impaired.<br />
- Increased stability.
<br /><br />
Download version 3.5 on the <a href="http://www.ssmstoolspack.com/Download">Download page</a>.
</p>Sun, 03 May 2015 16:00:00 +0200http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack website EU VAT rules update.<p>
The site is now updated to reflect new EU VAT rules for online software sales.<br />
For customers that are NOT VAT exempt, the VAT from their country has to now be added to the price.<br /><br />
Second change is the Demo license has been now extended to 60 days. This way you can take<br />
the SSMS Tools Pack for a test drive without rush.
</p>Thu, 01 Jan 2015 20:00:00 +0100http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 3.2.2.0 update released.<p>
SSMS Tools Pack 3.2.2.0 fixes a bug with an error being thrown for non-english localized SSMS's.<br />
Also included are a few speed and accuracy optimizations of the whole <a href="http://www.ssmstoolspack.com/Features?f=14">SQL Editor Plus</a> feature.<br /><br /><br />
Download version 3.2.2.0 on the <a href="http://www.ssmstoolspack.com/Download"><strong>Download page</strong></a>.
</p>Fri, 12 Sep 2014 12:00:00 +0200http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 3.2.1.0 update released.<p>
SSMS Tools Pack 3.2.1.0 fixes a bug with executing a statement at cursor location and<br />
adds closing all dialog windows when pressing ESC.
<br /><br />
Download version 3.2.1.0 on the <a href="http://www.ssmstoolspack.com/Download"><strong>Download page</strong></a>.
</p>Thu, 04 Sep 2014 00:00:00 +0200http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 3.2.0.0 is out with a NEW feature, a few improved features and various bug fixes.<p>
SSMS Tools Pack 3.2 introduces a new feature, the <a href="http://www.ssmstoolspack.com/Features?f=14">SQL Editor Plus</a>. For now it has 2 very helpful options.<br />
The first one is <strong>running a statement at your cursor position</strong> by pressing SHIFT+F5.<br />
The second one can be a real life saver. It's called the <strong>Accidental Data Destruction Protector</strong>.<br />
It pops an "Are you sure?" window if it detects you've executed a DELETE or UPDATE statements without a WHERE clause or a TRUNCATE statement.
<br /><br />
In <a href="http://www.ssmstoolspack.com/Features?f=12">CRUD Generator</a> you can now use the <strong>|insertColumnList|, |values| and |updateColumnList|</strong> variables in both Insert and Update templates. This gives you the ability to create an UpSert template (Update if exist, Insert if not).
<br /><br /><a href="http://www.ssmstoolspack.com/Features?f=9">Generating Insert Statements</a> for data in result grids can now be also scripted as a simple union all result set without a temp table.
<br /><br />
Other changes include various bug fixes in the core engines for error reporting, SQL History, etc.
<br /><br />
Download version 3.2.0.0 on the <a href="http://www.ssmstoolspack.com/Download"><strong>Download page</strong></a>.
</p>Wed, 03 Sep 2014 10:00:00 +0200http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack Licensing page has been updated for VAT.<p>
Customers in the European Union (EU) are subject to Value Added Tax (VAT)<br />
according to EU law. The <a href="http://www.ssmstoolspack.com/Licensing">Licensing page</a> has been updated to handle VAT.<br /><br />
It now consists of 3 steps:<br /><ol><li><strong>Choose license option</strong> best suited for your needs like before.<br /></li><li>
If you are not a customer in the EU, you make a <strong>purchase like before</strong>.<br />
If you are a customer in the EU, you are taken to step 3.<br /></li><li><strong>Applies only to customers in the EU</strong>.<br /><ul><li>
Here you can deduct VAT if you are a company registered for VAT.
</li><li>
Buy with the VAT added if you are a company not registered for VAT <br />
or an end customer.
</li></ul></li></ol></p>Fri, 15 Aug 2014 08:00:00 +0200http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 3.0.3.0 is out with few important bug fixes.<p>
SSMS Tools Pack 3.0.3.0 fixes a bug some people experienced in SSMS 2008 R2 with SSMS Tools menu item not appearing in Object Explorer context menu and Object Explorer Details window not being able to connect to a server.<br />
Also fixed is a bug with Send Feedback functionality which caused empty feedback to be sent.
<br /><br />
Xen hypervisor has been added to the list of VM's where you can use the unlimited VM's feature.
<br /><br />
Download version 3.0.3.0 on the <a href="http://www.ssmstoolspack.com/Download"><strong>Download page</strong></a>.
</p>Mon, 26 May 2014 08:00:00 +0200http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 3.0 is out. Full SSMS 2014 support and improved features.<p>
With version 3.0 the SSMS 2014 is fully supported.<br />
Since this is a new major version you'll eventually need a new license. Please check the <a href="/Licensing/EULA">EULA</a> to see when.
</p><p>
As a thank you for your patience with this release, <strong>
everyone that bought<br />
the SSMS Tools Pack after April 1st, the release date of SQL Server 2014, will receive a free upgrade
</strong>.<br />
You won't have to do anything for this to take effect.<br /></p><p>
First thing you'll notice is that the UI has been completely changed.<br />
It's more in line with SSMS and looks less web-like.<br />
Also the core has been update and rewritten in some places to be better suited fo future features.
</p><p><strong>Major improvements for this release are:</strong></p><p><a href="/Features?f=2">Window Connection Coloring</a><br />
Something a lot of people have asked me over the last 2 years is if there's a way <br />
to color the tab of the window itself. I'm very glad to say that now it is.<br />
In SSMS 2012 and higher the actual query window tab is also colored at the top border <br />
with the same color as the already existing strip making it much easier to see to which <br />
server your query window is connected to even when a window is not focused.<br />
To make it even better, you can not also specify the desired color based on the database name <br />
and not just the server name. This makes is useful for production environments where you <br />
need to be careful in which database you run your queries in.<br /><br /><a href="/Features?f=4">Format SQL</a><br />
The format SQL core was rewritten so it'll be easier to improve it in future versions. <br />
New improvement is the ability to terminate SQL statements with semicolons. <br />
This is available only in SSMS 2012 and up.<br /><br /><a href="/Features?f=0">Execution Plan Analyzer</a><br />
A big request was to implement the Problems and Solutions tooltip as a window <br />
that you can copy the text from. This is now available. You can move the window around <br />
and copy text from it. It's a small improvement but better stuff will come.<br /><br /><a href="/Features?f=3">SQL History</a><br />
Current Window History has been improved with faster search and now also shows <br />
the color of the server/database it was ran against. This is very helpful if you change <br />
your connection in the same query window making it clear which server/database you ran query on.<br />
The option to Force Save the history has been added. This is a menu item that flushes <br />
the execution and tab content history save buffers to disk.<br /><br /><a href="/Features?f=1">SQL Snippets</a><br />
Added an option to generate snippet from selected SQL text on right click menu.<br /><br /><a href="/Features?f=6">Run script on multiple databases</a><br />
Configurable database groups that you can save and reuse were added. <br />
You can create groups of preselected databases to choose from for each server.<br />
This makes repetitive tasks much easier<br /><br /><a href="/Licensing">New small team licensing option</a><br />
A lot of requests came in for 1 computer, Unlimited VMs option so now it's here. <br />
Hope it serves you well.
</p>Tue, 20 May 2014 08:00:00 +0200http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 2.7.2.0 is released with a bug fix for the SSMS 2008 version.<p>
A few people on SSMS 2008 reported a bug with SQL History Window Content saving so this is a version with that bug fixed.
</p>Fri, 02 Aug 2013 12:00:00 +0200http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 2.7 is released. New website, improved licensing and features.<p><a href="http://www.ssmstoolspack.com">New website</a><br />
Nice, isn't it? Cleaner, simpler, better looking and more modern.<br />
If you have any suggestions for further improvements I'd be glad to hear them.<br /></p><p><a href="http://www.ssmstoolspack.com/Licensing">Simpler licensing</a><br />
With SSMS tools Pack 2.7 the licensing is finally where it should be.<br />
It is now based on the activate/deactivate model.<br />
This way you can move a license from machine to machine with simple deactivation on one and<br />
reactivation on another machine. Much better, no?<br />
Because of very good feedback I have added an option for 6 machines and lowered the 4 machines option to 3 machines.<br />
This should make it much simpler for you to choose the right option for yourself.<br /></p><div><a href="http://www.ssmstoolspack.com/Features">Improved features</a><br />
Version 2.5.3 was already extremely stable and 2.7 continues with that tradition.<br />
Because of that I could fully focus on features and why 3.0 will rock even more that 2.7! ;)<br />
In version 2.7 I have addressed quite a few improvements you were requesting for a while now.<br /><br /><div><strong>SQL History</strong><br />
This is probably the biggest time saver out there, therefore it's only fair it gets a few important updates.
<ul><li>
If you have an existing .sql file opened, the Window Content History now saves your code<br />
to that existing file and also makes a backup in the SQL History log default location.<br />
Search is still done through the SQL History log but the Tab Sessions Restore opens your existing .sql file.<br />
This way you don't have to remember to save your existing files by yourself anymore.<br /></li><li>
A bug when you couldn't search properly if you copied the log files to a new location was fixed.<br />
Unfortunately this removed the option to filter a search with the time component.<br />
The smallest search interval is now one day.<br /></li><li>
The SSMS Tools Pack now remembers the visibility of the Current Window History window when you exit SSMS.
</li></ul><br /></div><div><strong>SQL Snippets</strong><br />
You can now set the position of the cursor in your snippets by placing {C} somewhere in your snippet.<br />
It's a small improvement but can be a huge time saver since you don't have to move through<br />
the snippet to the desired location anymore.<br /><br /></div><div><strong>Run script on multiple databases</strong><br />
Database choices can now be saved with a name and then loaded again next time.<br />
You can also choose to run the script in a new window for each chosen database.<br /><br /></div><div><strong>Search through grid results</strong><br />
You can now go previous/next search result with the Prev/Next control inside the search window.
<br />
This is extremely useful if you have a large resultset. IT saves you the scrolling.<br /><br /></div><div><strong>CRUD generator</strong><br />
Four new variables have been added:<br /><ul><li>|CurrentDate| writes current date in format yyyy-MM-dd to your script</li><li>|CurrentTime| writes current time in 24h format HH:mm:ss to your script</li><li>|CurrentWinUser| writes current Windows logged on user to your script</li><li>|CurrentSqlUser| writes current SQL logged on login to your script</li></ul>
This was actually quite a requested feature so if you have any other ideas for extra variables, do let me know.
<br /><br /></div></div><div>
That's about it. I hope you're going to enjoy this version as much as the previous ones.<br />
Have fun!
</div>Tue, 02 Jul 2013 20:00:00 +0200http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 2.5.3 is out with bug fixes and improved licensing.<p>
Licensing for SSMS Tools Pack 2.5 has been quite a hit and I received some awesome feedback.<br />
The vesion 2.5.3 contains a few bug fixes and desired licensing improvements.<br />
Changes include more licensing options, prices in Euros because of book keeping reasons (don't you just love those :))<br />
and generally easier purchase and licensing process for users.
</p><p><a href="http://www.ssmstoolspack.com/Licensing"><strong>Licensing</strong></a> now offers four options:
</p><p><strong>Per machine license. (€25)</strong><br />
Perfect if you do all your work from a single machine.<br />
Plus one OS reinstall activation.
</p><p><strong>Personal license (€75)</strong><br />
Up to 4 machine activations.<br />
Plus 2 OS reinstall activations and<br />
any number of virtual machine activations.
</p><p><strong>Team license (€240)</strong><br />
Up to 10 machine activations.<br />
Plus 4 OS reinstall activations and<br />
any number of virtual machine activations.
</p><p><strong>Enterprise license (€350+)</strong><br />
For more than 10 machine activations<br />
any number of virtual machine activations.
</p><p><strong>30 days license.</strong><br />Time based demo license bound to a machine.
</p><p>
You can view all the details on the <a href="http://www.ssmstoolspack.com/Licensing"><strong>Licensing page</strong></a>.
</p><p>
If you want to receive email notifications when new version of SSMS Tools Pack is out you can do that on the <a href="http://www.ssmstoolspack.com/"><strong>Main page</strong></a> or on the <a href="http://www.ssmstoolspack.com/Download"><strong>Download page</strong></a>.
</p><p>Version 2.7 is expected in the first half of january and won't support SSMS 2005 and 2005 Express anymore.</p><p>Enjoy it!</p>Fri, 14 Dec 2012 12:00:00 +0100http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 2.5 is out. Added support for SQL Server 2012.<p>Because I wanted to make SSMS Tools Pack as solid as possible for SSMS 2012 there are no new features only bug fixes and speed improvements. </p><p>I am planning new awesome features for the next version so be on the lookout.</p><p>
The biggest change is that <a href="http://www.ssmstoolspack.com/"><strong>SSMS Tools Pack</strong></a> for SSMS 2012 is no longer free. For previous SSMS versions it is still free.
</p><p><a href="http://www.ssmstoolspack.com/Licensing"><strong>Licensing</strong></a> now offers following options:
</p><p><strong>Per machine license. ($29.99)</strong><br />Perfect if you do all your work from a single machine.
<br />This license is valid per major release of SSMS Tools Pack
<br />(e.g. v2.x, v3.x, v4.x).
</p><p><strong>Fully transferable license valid for 3 months. </strong><strong>($99.99)</strong><br />Perfect for work across many machines.
<br />It's not bound to a machine or an SSMS Tools Pack version.
</p><p><strong>30 days license.</strong><br />Time based demo license bound to a machine.
</p><p>
You can view all the details on the <a href="http://www.ssmstoolspack.com/Licensing"><strong>Licensing page</strong></a>.
</p><p>
If you want to receive email notifications when new version of SSMS Tools Pack is out you can do that on the <a href="http://www.ssmstoolspack.com/"><strong>Main page</strong></a> or on the <a href="http://www.ssmstoolspack.com/Download"><strong>Download page</strong></a>.
</p><p>This is also the last version to support SSMS 2005 and 2005 Express.</p><p>Enjoy it!</p>Tue, 18 Sep 2012 00:00:00 +0200http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 2.1.0 is out. Added support for SQL Server 2012 RC0.<p>This version adds support for SQL Server 2012 RC0 and fixes a few bugs with SQL History.</p><p>Because of the support for regions in SSMS 2012 the regions and debug sections feature has been removed from SSMS Tools Pack for SQL Server 2012.</p><p>The feature is still available for previous SSMS versions.</p>Thu, 01 Dec 2011 21:00:00 +0100http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack won the SQL Magazine bronze award for best free tool of 2011<p>
SSMS Tools Pack has won the SQL Magazine bronze award for best free tool of 2011.
You can view all the details at the <a href="http://www.sqlmag.com/content1/topic/2011-sql-server-magazine-editors-community-choice-awards-140830/catpath/awards/showprivate/1/page/9">SQL Server Magazine Award page</a>.<br /><br />
Thanx to all the people who voted for it. I'm glad you all like it and use it with great success.
<br /><br /></p>Thu, 01 Dec 2011 21:00:00 +0100http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 2.0.4 is out. Fix for crashing SQL Prompt 4.<p>This version fixes a problem with SQL Prompt 4 had with SSMS Tools Pack that made SQL Prompt 4 crash. I've worked around the SQL Prompt bug and now they play along nicely.</p>Tue, 04 Oct 2011 15:00:00 +0200http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 2.0.3 is out. Varios bug fixes people reported.<p>This version various bug people have reported and makes some UI changes. The Search grid results button is now in the grid results context menu. The text for the Show/Hide Execution Plan Analyzer has changed.</p><p>Tab Sessions are now saved and restored per logged in user. However the Tab Session History still shows sessions from all users.</p>Mon, 03 Oct 2011 00:00:00 +0200http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 2.0.2 is out. Bug fixes for SSMS 2005 and 2005 Express version.<p>SSMS Tools Pack update that fixes a corrupt memory bug in SSMS 2005 and 2005 Express versions.</p>Sun, 25 Sep 2011 21:00:00 +0200http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 2.0.1 is out. This version fixes the SSMS crashing bug.<p>SSMS Tools Pack update that fixes the SSMS crashing bug if SSMS is idle for more than 10 minutes.</p><p>Also a "Show/Hide Execution Plan Analyzer" button has been added to the toolbar.</p>Sun, 25 Sep 2011 17:00:00 +0200http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 2.0 stability update<p>A few people reported frequent SSMS crashing after installing SSMS Tools Pack 2.0. I'm working on fixing this bug but for now the workaround is to disable Tab Session saving in SQL History Options under Window Content and Tab Session Saving tab</p>Fri, 23 Sep 2011 00:00:00 +0200http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 2.0 is out! With huge productivity booster features that will blow your mind and ease your job even more.<p>What better way to end the summer and start those productive autumn days ahead than with a fresh new version of the SSMS Tools Pack.</p><p>This is a big release with two new features that are huge productivity boosters.</p><p>
First new feature are <strong><font color="#c0504d">Tab Sessions</font></strong>. Every SQL tab you open is saved every N (default 2) minutes and is stored in a session. This works similar to internet browser sessions. Once you reopen SSMS you can restores your last session with a click of a button. You even get every window connected to the server it was previously connected to. The Tab History Window looks like this:
</p><p>
The second feature is <strong><font color="#c0504d">Execution Plan Analyzer</font></strong>. It is designed to quickly help you <strong>find costliest operators</strong> by a number of properties. If that's not enough you can easily <strong><font color="#000000">search through the whole execution plan</font></strong>for whatever you like.
<br />And to top it off you can <strong>auto analyze the execution plan</strong>. The analysis reports various problems the execution plan has and suggests a most common solution. The ultimate purpose of the Execution Plan Analyzer is to make your troubleshooting quicker and easier. It uses a simple user interface that is easy to navigate and is built directly into the execution plan itself.
</p><p>Smaller fixes include a completely redesigned SQL History Search window and various other bug fixes.</p><p><strong>
You can download the new version 2.0 at the <a href="http://www.ssmstoolspack.com/Download"><u>Download page</u></a>.
</strong></p><p>
Also available with the download is a free trial of SQL Source Control from Red Gate Software. This SSMS plug-in connects your existing source control system to SQL Server in less than 5 minutes.
</p><p><strong>
For more detailed feature descriptions go to the main <a href="http://www.ssmstoolspack.com/Features"><u>Features Page</u></a>.
</strong></p><p>Enjoy it!</p>Wed, 21 Sep 2011 12:00:00 +0200http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 1.9.4 is out! Now with SQL Server Denali CTP1 support.<p>To end the year on a good note this release adds support for SQL Server Denali CTP1 and fixes a few bugs.</p><p>Because of the new shell the SSMS Tools Pack for SQL Denali CTP1 version doesn't have regions and debug sections functionality for now.</p><p>The fixed bugs are: </p><ul><li>A bug that prevented to create insert statements for a database </li><li>A bug that didn't script commas as decimal points correctly for non US settings. </li><li>A bug with searching through grid results. </li><li>A threading bug that sometimes happened when saving Window Content History. </li><li>A bug with Window Connection Coloring throwing an error on startup if a server color was undefined. </li><li>A bug with changing shortcuts in SSMS for various features. </li></ul><p><strong>
You can download the new version 1.9.4 <a href="http://www.ssmstoolspack.com/Download">here</a>.
</strong></p><p>Enjoy it!</p>Tue, 28 Dec 2010 12:00:00 +0100http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack won the SQL Magazine silver award for best free tool of 2010<p>
SSMS Tools Pack has won the SQL Magazine silver award for best free tool of 2010.
You can view all the details at the <a href="http://www.sqlmag.com/article/sql-server/2010-SQL-Server-Magazine-Editors-Best-and-Community-Choice-Awards/4.aspx">SQL Server Magazine Award page</a>.<br /><br />
Thanx to all the people who voted for it. I'm glad you all like it and use it with great success.
<br /><br /></p>Wed, 24 Nov 2010 12:00:00 +0100http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 1.9.3 is out!<p>This release adds a great new feature and fixes a few bugs</p><p>
The new feature called <a href="http://www.ssmstoolspack.com/Features?f=2"><strong>Window Content History</strong></a> saves the whole text in all all opened SQL windows every N minutes with the default being 30 minutes.
This feature fixes the shortcoming of the Query Execution History which is saved only when the query is run.
If you're working on a large script and never execute it, the existing Query Execution History wouldn't save it.
By contrast the Window Content History saves everything in a .sql file so you can even open it in your SSMS.
The Query Execution History and Window Content History files are correlated by the same directory and file name so when you search through the Query Execution History
you get to see the whole saved Window Content History for that query. Because Window Content History saves data in simple searchable .sql files there isn't a special
search editor built in. It is turned <strong>ON by default</strong> but despite the built in optimizations for space minimization, be careful to not let it fill your
disk. You can see how it looks in the pictures in the <a href="http://www.ssmstoolspack.com/Features?f=2">feature list</a>.
</p><p>
The fixed bugs are:
<ul id="features"><li>
SSMS 2008 R2 slowness reported by few people.
</li><li>
An object explorer context menu bug where it showed multiple SSMS Tools entries and showed wrong entries for a node.
</li><li>
A datagrid bug in SQL snippets.
</li><li>
Ability to read illegal XML characters from log files.
</li><li>
Fixed the upper limit bug of a saved history text to 5 MB.
</li><li>
A bug when searching through result sets prevents search.
</li><li>
A bug with Text formatting erroring out for certain scripts.
</li><li>
A bug with finding servers where it would return null even though servers existed.
</li><li>
Run custom scripts objects had a bug where |SchemaName| didn't display the correct table schema for columns. This is fixed. Also |NodeName| and |ObjectName| values now show the same thing.
</li></ul></p><p> </p><p><strong>
You can download the new version 1.9.3 <a href="http://www.ssmstoolspack.com/Download">here</a>.
</strong></p><p>Enjoy it!</p>Tue, 09 Nov 2010 12:00:00 +0100http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 1.9 is out!<p>This is a release that fixes all known bugs. If you encounter any new ones don’t hesitate to report them. :)</p><p>
The main <a href="http://www.ssmstoolspack.com/Features"><strong>feature list</strong></a> hasn’t changed.
</p><p>A few improvements have been made though:</p><p>
Save SQL Snippets to <a href="http://www.ssmstoolspack.com/Features?f=0"><strong>HTML and/or print them</strong></a> directly from SSMS.
</p><p>
In Window Connection Coloring the <a href="http://www.ssmstoolspack.com/Features?f=1"><strong>server names can now be regular expressions</strong></a> giving you the ability to color multiple servers with the same color.
</p><p>
Here’s a blog from David Levy (<a href="http://adventuresinsql.com/"><strong>Blog</strong></a>|<a href="http://twitter.com/Dave_Levy/"><strong>Twitter</strong></a>) about the new window connection coloring using regular expression and <a href="http://adventuresinsql.com/2010/08/great-news-ssms-tools-pack-1-9-is-coming-out/"><strong>why is it really useful to him</strong></a>. Thanx for kind words Dave.
</p><p> </p><p><strong>
You can download the new version 1.9 <a href="http://www.ssmstoolspack.com/Download">here</a>.
</strong></p><p>Enjoy it!</p>Tue, 24 Aug 2010 12:00:00 +0200http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 1.8 is out!<p>This is a release that fixes all known major bugs and most of the minor ones.</p><p>
The main <a href="http://www.ssmstoolspack.com/Features"><strong>
feature list
</strong></a> hasn’t changed.
</p><p>
The only addition is the ability to <a href="http://www.ssmstoolspack.com/Features?f=0"><strong>
export and import only SQL snippets
</strong></a>.
</p><p>
Before you could only export/import all settings which included the snippets.
</p><p><strong>
You can download the new version <a href="http://www.ssmstoolspack.com/Download">
here
</a>.
</strong></p><p>Enjoy it!</p>Mon, 03 May 2010 12:00:00 +0200http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 1.7.5.1 is out. Bug fixes for my international users.<p>Due to a bug i haven’t anticipated, a whole load of users with non English SSMS couldn’t install the latest SSMS Tools Pack 1.7.</p><p>The SSMS Tools Pack 1.7.5.1 fixes this as well as 1 other major bug that was reported and 3 smaller ones.</p><p>
The <a href="http://www.ssmstoolspack.com/Features" target="_blank"><strong>
feature list
</strong></a> hasn’t changed.
</p><p><strong>You can simply reinstall 1.7.5.1 over the 1.7.0.0.</strong></p><p>If you’re still on 1.5 or less then you’ll have to manually uninstall it and install 1.7.5.1.</p><p><strong>You can download the new version </strong><a href="http://www.ssmstoolspack.com/Download" target="_blank"><strong>here</strong></a><strong>.</strong></p><p>Hopefully this will bring back joy to everyone :)</p>Tue, 03 Nov 2009 12:00:00 +0100http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/s99nwuhpoNg/SSMS Tools Pack 1.7 is out<p>Ladies and gentlemen, boys and girls, the STP is back to rock your world! </p>
The new feature is <a href="http://www.ssmstoolspack.com/Features?f=0"><strong>
SQL Snippets
</strong></a> to speed up your development.
<p><br />This new version brings one completely new option, full GUI redesign, completely rewritten installer, improved error handling and reporting, bug fixes and old features improvements.
<br />Type in the assigned shortcut, press enter or tab and get the snippet you need.
<br />It's quick, clean and saves time!
<br /><br />Some of more visible improved features include:
</p><ul id="features"><li>
Completely new installer using the powerful <a href="http://wix.sourceforge.net/" target="_blank"><strong>
Windows Installer XML (WiX) toolset
</strong></a>. Now there’s only one MSI installer file for all versions with automatic detection of which versions should be installed.
<br /></li><li>
Improved search in <a href="http://www.ssmstoolspack.com/Features?f=2"><strong>
Current Window History
</strong></a>.
<br /></li><li>
Added search through views in <a href="http://www.ssmstoolspack.com/Features?f=4"><strong>
Search Table/View or Database Data
</strong></a>.
<br /></li><li>
Added option to <a href="http://www.ssmstoolspack.com/Features?f=6"><strong>
Copy execution plan bitmaps to file
</strong></a>.
<br /></li><li>
New features like <a href="http://www.ssmstoolspack.com/Features?f=13"><strong>
Automatic web proxy detection and “Log everything” options
</strong></a> in General Options.
<br /></li><li>
Improved logging and direct error reporting features using the awesome <a href="http://www.postsharp.org/" target="_blank"><strong>
PostSharp
</strong></a> AOP framework.
<br /></li></ul><p>SSMS 2008 R2 is supported but expect quirks in it due to the CTP status.</p><p><strong>Due to a folder naming installer bug in version 1.5 please uninstall any and all previous versions before installing the 1.7 version.</strong></p>Mon, 26 Oct 2009 12:00:00 +0100http://www.ssmstoolspack.com/http://feedproxy.google.com/~r/SsmsToolsPack/~3/fcqFVaOk4Rg/Download.aspxSSMS Tools Pack 1.5 is out<p>
The new SSMS Tools Pack 1.5 is here!
<br /><br />
This new version brings one completely new option and a few improved old ones.
<br />
The new feature is <a href="http://www.ssmstoolspack.com/Features.aspx#WCC">Window Connection Coloring.</a><br />
It includes a colored strip indicator that can be docked to any side of the window.
<br /><br />
Improved features include:
<ul id="features"><li><a href="Features.aspx#SDD">Search Table or Database Data.</a><br /></li><li><a href="Features.aspx#FKW">Uppercase/Lowercase keywords and Proper Case Database Object Names.</a><br /></li><li>
Sending feedback directly from SSMS.
<br /></li><li>
Import and Export options.
<br /></li><li>
Delete Query history log files older than user settable age.
<br /></li></ul><br /><br /></p>Mon, 09 Feb 2009 12:00:00 +0100http://www.ssmstoolspack.com/Download.aspxhttp://feedproxy.google.com/~r/SsmsToolsPack/~3/f8a8eYNKNwY/download.aspxSSMS Tools Pack 1.1 is out<p>
The new SSMS Tools Pack 1.1 is here!
<br /><br />
With this new version you can use it for Sql Server Management Studio 2008 and Sql Server Management Studio 2008 Express.
<br /><br />
There are 2 new features.<br />
1. 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. Also the main Query History Log Viewer has been remodeled. I'm open to suggestions for further improvements.
<br /><br />
2. 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. Now you can easily do that.
<br /><br /><strong>The SSMS Tools Pack does NOT work for SSMS 2005 versions before SP2 anymore.</strong><br /><br /></p>Mon, 06 Oct 2008 12:00:00 +0200http://www.ssmstoolspack.com/download.aspxhttp://feedproxy.google.com/~r/SsmsToolsPack/~3/f8a8eYNKNwY/download.aspxSearch for the SSMS Tools Pack logo!<p>
Since i'm a bit graphicaly challenged :) I would 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.
<br />
Thanx for any and all input.
</p>Mon, 06 Oct 2008 12:00:00 +0200http://www.ssmstoolspack.com/download.aspxhttp://feedproxy.google.com/~r/SsmsToolsPack/~3/f8a8eYNKNwY/download.aspxSSMS Tools Pack 1.0 is out.<p>
SSMS Tools Pack 1.0 is here!<br />It's out of beta and we have tons of features and improved functionality.
<br />List of all features in version 1.0:
<ul id="features"><li>
Uppercase/Lowercase keywords.
</li><li>
Run one script on multiple databases.
</li><li>
Copy execution plan bitmaps to clipboard.
</li><li>
Search Results in Grid Mode and Execution Plans.
</li><li>
Generate Insert statements for a single table, the whole database or current resultsets in grids.
</li><li>
Query Execution History (Soft Source Control).
</li><li>
Text document Regions and Debug sections.
</li><li>
Running custom scripts from Object explorer's Context menu.
</li><li>
CRUD (Create, Read, Update, Delete) stored procedure generation.
</li><li>
New query template.
</li></ul></p>Thu, 01 May 2008 12:00:00 +0200http://www.ssmstoolspack.com/download.aspxhttp://feedproxy.google.com/~r/SsmsToolsPack/~3/NvIN3MvR5FM/SsmsToolsPackSSMS Tools Pack RSS Feed has changed to feedburner.<p>
SSMS Tools Pack RSS Feed has changed from<br /><a href="http://www.SSMSToolsPack.com/Rss.aspx">http://www.SSMSToolsPack.com/Rss.aspx</a><br />
to<br /><a href="http://feeds.feedburner.com/SsmsToolsPack">http://feeds.feedburner.com/SsmsToolsPack</a>.<br />
Please switch to the new feed.
</p>Thu, 01 May 2008 12:00:00 +0200http://feeds.feedburner.com/SsmsToolsPackhttp://feedproxy.google.com/~r/SsmsToolsPack/~3/f8a8eYNKNwY/download.aspxSSMS Tools Pack: 0.9.5 beta is out<p>New version of SSMS Tools Pack: 0.9.5 beta</p>Wed, 31 Oct 2007 12:00:00 +0100http://www.ssmstoolspack.com/download.aspxhttp://feedproxy.google.com/~r/SsmsToolsPack/~3/f8a8eYNKNwY/download.aspxSSMS Tools Pack: 0.9.0 beta is out<p>New version of SSMS Tools Pack: 0.9.0 beta</p>Thu, 20 Sep 2007 12:00:00 +0200http://www.ssmstoolspack.com/download.aspx