SSMS Tools Pack 2.1 + Crack Keygen/Serial Date added: Jan 2018 ScreenShot Review this Software Name. Email. Website Comment You may use these HTML tags and attributes:. ODOWNLOADX News.
June 18 We have fixed our email. We can now recieve email flawlessly. Email us at [email protected].
Jan 28 OdownloadX changed it's design and layout. Hope you guys liked it. Featured Softwares for this Week.
For those not in the know, there is an incredibly useful set of utilities known as SSMS Tools Pack ( /). The best part about SSMSTP is that it's FREE. Or it has been to date. It's recently been announced that for SSMS 2012 won't be free any longer, and for those of us routinely working on say 3 different machines, it won't be cheap. I'm working for an organisation that has basically run out of money, so if I want to keep using it I'll be ponying up upwards of €75 myself.
Which I will probably end up doing because the product is so useful and the developer deserves reward for effort. Before I do that though, I want to see what the alternatives are.
Ssms Tools Pack Download
I use the 'SQL Snippets' most. It takes user-configurable keyboard shortcuts and turns them in SQL formatted to your personal taste. Are there any other utilities out there that do a similar job?
What are other people planning to do? I develop SSMSBoost1 add-in, which has: - snippets - 'go to definition' - preferred connections - executed statements history - formatting - recent tabs - editor history - search in results grid - results grid scripting ( for example as excel document) - and some more good tools. Check it out and let me know if you miss anything. Add-in is free (after 30 days of trial you only have to get free activation key). There is also 'Pro' version available for 50 EUR, which is identical to Free one. It is just a possibility to say 'Thanks' to developer;) 1.
Thanks for the post Andrei. Out of curiosity, where you say '.available for 50 EUR.'
, what guides your decision to arrive at 50 EUR? I often wonder whether developers would get better revenue and better market penetration by settling on a much lower figure thereby generating more sign-ups. If you got ten times the number of sign-ups by setting the number at 5 EUR surely the extra market share would be a huge collateral gain. (I realise in this case it's like a donation, just curious as to how the number 50 came about).
The problem is that potential market for SSMS add-ins can not be compared with market for AngryBirds. If add-in is targeted for commercial success it must cost at least some 70-150$ to cover development costs. Setting the price of 5$ will not help the developer and will be contraproductive for tool popularity because, I think, some 20-40% of users will not even want to pay that much. That is why my decision: free + possibility to thay 'thanks' buying the 'Pro' version. 'Pro' means not that the addin will get more functions, it means that user who paid that much is 'Pro' himself, because he values his time and understands the development effort, needed to produce the tool. It is also a great message for me as developer: if someone is paying money for a tool, that can be used for free, that means that the SSMSBoost is on the right way.
With version 3.0 the SSMS 2014 is fully supported. Since this is a new major version you'll eventually need a new license. Please check the to see when.
As a thank you for your patience with this release, everyone that bought the SSMS Tools Pack after April 1st, the release date of SQL Server 2014, will receive a free upgrade. You won't have to do anything for this to take effect. First thing you'll notice is that the UI has been completely changed. It's more in line with SSMS and looks less web-like. Also the core has been updated and rewritten in some places to be better suited for future features.
Major improvements for this release are: Something a lot of people have asked me over the last 2 years is if there's a way to color the tab of the window itself. I'm very glad to say that now it is. In SSMS 2012 and higher the actual query window tab is also colored at the top border with the same color as the already existing strip making it much easier to see to which server your query window is connected to even when a window is not focused.
To make it even better, you can not also specify the desired color based on the database name and not just the server name. This makes is useful for production environments where you need to be careful in which database you run your queries in. The format SQL core was rewritten so it'll be easier to improve it in future versions. New improvement is the ability to terminate SQL statements with semicolons. This is available only in SSMS 2012 and up. A big request was to implement the Problems and Solutions tooltip as a window that you can copy the text from.
This is now available. You can move the window around and copy text from it.
It's a small improvement but better stuff will come. Current Window History has been improved with faster search and now also shows the color of the server/database it was ran against. This is very helpful if you change your connection in the same query window making it clear which server/database you ran query on. The option to Force Save the history has been added. This is a menu item that flushes the execution and tab content history save buffers to disk. Added an option to generate snippet from selected SQL text on right click menu.
Configurable database groups that you can save and reuse were added. You can create groups of preselected databases to choose from for each server. This makes repetitive tasks much easier A lot of requests came in for 1 computer, Unlimited VMs option so now it's here.
Hope it serves you well.
You know all those little things that make you crazy when you’re developing in SQL Server Management Studio? Those pieces of functionality that you just can’t understand why Microsoft didn’t just include it? Stuff like generating a set of CRUD statements (Create, Read, Update Delete), or running custom scripts right from the SSMS GUI, or even a way to analyze execution plans rather than read through them? Yeah, Mladen Prajdic felt exactly the same way. Except unlike the rest of us, instead of sitting around moaning about how the software doesn’t do this or that for me, Mladen just started building it for himself. Then he went one step farther, he let the rest of us have it too.
That’s right, SSMS Tools Pack is a free piece of software that patches over a lot of the little cracks in SSMS (although I’m certain that Mladen wouldn’t mind contributions if you really love his work). It works with SQL Server versions from 2000 to Denali and it does everything that it does working directly within SSMS so you can stay well and truly inside your comfort zone, developing with the toolset that you’re used to. In fact, SSMS Tools Pack will quickly become one of those pieces of software that you won’t want to live without. Download and Install When I heard that a whole new version was becoming available, I couldn’t wait to try it out. I downloaded it the first day it was available.
Here is the exhaustive list of actions and requirements to download the software:. Go to.
Click on the download button That’s right. No registration, no email address, no home phone, none of the standard stuff that you have to supply in order to get a piece of software. Did I mention that this is free software and that Mladen doesn’t really want to know who you are in order to supply you with it?
After you launch the installer, it will recognize what version of SQL Server you have installed on your desktop. I tried the install on a 2008R2 instance and on a Denali instance and didn’t have any troubles with it whatsoever. On the Denali instance, I had SQL Server Management Studio open when I did the install. I didn’t get any error messages, but when I went to SSMS I also didn’t see any of the new tools available. Upon restarting SSMS, the tools loaded right up.
Functionality There’s a shocking amount of functionality built into this piece of software. Because it covers so much different functionality trying to find a handle for how to approach the evaluation isn’t entirely simple. So, with the full set of functionality in front of me, I’m going to cover the stuff that I find cool or intriguing.
If I leave out your favorite function, there’s your chance to post a comment or write up an article of your own. Mind you, I’m not going right to the coolest stuff. We’ll start slow and build. Generate CRUD There’s a small market on code generators for SQL Server. Because most of the queries, the CUD part of CRUD, can be built completely through generation.
There just is no reason why SSMS can’t do this on its own. But, instead of having to go to an outside tool or work with code bases other than TSQL, you can just right click on the table you’re interested in and one of the new context menu choices is “SSMS Tools” and right under that, “Create CRUD” Clicking on it opens a new query window with a set of stored procedures all set up to add, update, remove or read the data from the table selected.
It’s that easy. The statements are well formatted too with DROP statements before the create statements so that you can run this as needed when you change your structures. It gets better though. You’re not dependent on the structures that Mladen has provided. If you go to the SSMS Tools menu, there’s a list of options to modify different functionality. CRUD Generation is right there with some of what you can control as shown in Figure 1: Figure 1 As you can see you can turn the functionality on or off. More importantly, you can control column order, set stored procedure prefixes and others.
But the important stuff is on the next four tabs. You’re not dependent on Mladen’s choices for how to format and layout your procedures (although I don’t have any problems with his choices). If you wanted to put a standard TRY/CATCH error handler in your Insert statements, all you have to do is click on the tab and modify the query you find there, just like you see in Figure 2: Figure 2 All you have to do is follow the instructions and you can modify these procedures so that they work exactly the way you’d want them to.
One change I’d like to see, make it so that I don’t have to generate the Read procedure because those are mostly not simple, select from one table, affairs on systems I’ve worked with. Connection Coloring I’ve never in my life done something like what I’m about to describe, but I’ve heard that others have done so.
You hit execute on that RESTORE DATABASE script and you set it to restricted user and put ROLLBACK IMMEDIATE in there because the developers on the development server where you’re restoring the database are never logged out even though they say they are and then your eye drifts down to the bottom of the screen wait, that’s not DEV02 BoringOldDevServer. It’s PROD42 YouBetterGetYourResumeCleanedUpServer. Oh. Not that I’ve ever done that, or at least, there are no living witnesses that I’ve ever done that. Same thing really.
That’s where Windows Connection Coloring comes in handy. If you go back to the SSMS Tools menu you can find the appropriate menu and open the options window.
Once the window is open, you can supply a server name, or, you can use regular expressions to define a pattern, so that you can set a group of servers up to behave a certain way. Figure 3 shows how I configured it locally: Figure 3 If you do type in a regular expression, make sure you also select the “IsRegex” checkbox. Once you have things set up appropriately, you’ll see a colored bar at the top of your query window so you can be very aware of which server or set of servers you’re currently connected to. Figure 4 shows the bar on display: Figure 4 I realize this is a pretty simplistic little thing, but if a simple little thing can prevent a production outage, it’s pretty cool. In keeping with my irritate Mladen with more suggestions though, since you can format the bottom color on connections individually, it would be good if this also updated that color so that you could see the color chosen for a particular connection on the top and the bottom of the query window. Tab Sessions New with Version 2 of SSMS Tools Pack is the Tab Sessions. This little bit of functionality keeps track of the tabs that you have open in SSMS and the TSQL inside those tabs.
On a periodic basis (set within the options screen) it will save the tabs and the code. Then, say after a exiting and reentering SSMS you can hit the Restore Session button on the toolbar and it will reopen your tabs. Which is really cool, but it gets better.
If you go to the SSMS Tools menu and to the “SQL History” menu there, you can see the “Tabs History Management” menu choice. Clicking on that will open up a collection of different sets of tabs going back in time. You can see an example in Figure 5: Figure 5 It’s cool that you can scroll through these and pick one to restore, but what’s really cool is that you can then click on the tabs, like I have on the center one, and scroll through the code on that tab to ensure it’s the one you want. I’m digging this in a major way.
One major issue that I do have with it though, and this isn’t just another irritate Mladen request, is that while it knows which TSQL I have in a tab, it’s ignorant of the fact that that TSQL is from a file, so it will restore the TSQL to the appropriate tab on your window, but it won’t link it back up with the file that you had it open from. If you continue editing that TSQL, it won’t be saving to the file until you choose save and overwrite what you saved originally.
Execution Plan Analyzer I’ve saved the coolest new feature for last. SSMS Tools integrates with your execution plans. There’s a button on the SSMS toolbar, “Show/Hide Execution Plan Analyzer.” Click on that button when you have an execution plan open in SSMS, any plan, even from a file, and your execution plan screen will suddenly change to look like Figure 6: Figure 6 What you’ve got are different sets of functionality. Across the top are three buttons, offering you the ability identify the highest cost operation, search operators, and get suggestions on plan improvements.
Yeah, you heard me, it’ll help you turn your queries. The first piece of functionality, identify the highest cost operation, that’s hardly worth talking about on a plan that looks like the one above. But how a plan that looks like Figure 7? Figure 7: Yeah, that’s one of the hairiest plans I’ve ever seen and I sure would have used this to browse through that plan (I used XQuery to find the costliest operators, worked, but it wasn’t pretty like this). You can adjust it too so that it shows more or less operations based on their cost by using the little slider bar right above it. The tool tip will show the name of the operator and the cost and clicking on it will take you to that operator within the plan. That’s extremely handy.
Ssms Tools Pack Crack
But, you can adjust the default values, and you can pick other properties from the Options window and have them bubble to the top. More interested in high numbers of Estimated Rows, change the property and you’ll see those operations that exceed the value that you supply on the bar on the left side of the screen. Again, very handy. Next, you can search for operators. Want to know if you have a Sort operation in that mess of icons? Click the button and type in the term. You’ll see any and all Sort operations.
But, it gets better. What if you’re curious that the primary key was used in the query.
Type that in and you’ll see results like Figure 8: Figure 8. I left the tooltip up so that you can see that SSMS Tools Pack searches inside the operators to find the things you were interested in. Now, what about this tuning help? I’ll quote Mladen on this one: It goes through your plan finding most common problems and gives you the usual solution for each one. This feature isn’t meant to replace manual analysis but it will find the usual problematic spots that you can fix up fast.
The query I gave it is very simple and has a couple of issues, primarily structural. You can see that SQL Server thinks I need a different index. Let’s see what SSMS Tools Pack says I ought to do about it. Figure 9: It called out two issues, the Merge Join, and the Clustered Index scan that you can see in Figure 9. On both it pointed out that my estimated number of rows and my actual number of rows differed by a significant amount. This is true. I use this query to demonstrate bad parameter sniffing.
The suggested solutions were to update the statistics on all tables used in the query or to check for missing indexes. These are excellent suggestions. Neither will work in this case because I’ve got a skewed data set (like I said, this is my demo code and it’s broken on purpose), but nonetheless, based on the information provided, these are the same recommendations I’d make myself. I’m impressed. And More Yes, there’s more.
I can’t cover everything without generating about 50 pages of documentation to go through all the functionality and all the control over that functionality that you get. Here’s a quick run-down on some of the stuff I didn’t cover: SQL SnippetsSearch Table/View/Database DataRun Scripts on Multiple ServersSearch Results in GridCustom Scripts from Object Explorer Mladen did a nice job of, including the parts I didn’t mention. Conclusion I like this piece of software.
I use it regularly. I’ve had to turn off a couple of pieces of functionality because they interfered with some of the work being done by my Red Gate tools (there’s a code formatter that capitalizes key words, but I’m getting that from SQL Prompt, and the snippet manager steps on SQL Prompt too. Neither is a bad thing, just that SQL Prompt does more, so I use that instead). But those were very minor pieces. All the major pieces of functionality integrate extremely well with SSMS and with my Red Gate tools. In fact, I was doing a demo of SSMS and I started talking about some of the SSMS Tools Pack functionality like it was a part of SSMS and then caught myself.
It’s that good. Excellent Obviously written by someone who has to work with SSMS every day, very nice. One thing I did find – if you normally run as a non-privileged user, installation requires admin rights. Once installed, you may find that the window content and tab sessions saves generate a user access error because you’re unable to create the necessary directories in c: Logging in as a user with admin rights and creating the directory c:SSMSTools, then assigning full rights to that directory to your workaday, non-privileged log-in account fixes things. A couple of comments on the Regions feature When using the Regions feature to fold blocks of code, regions are folded by default when opening the script. As far as I know, there is no command to un-fold all code regions. That feature would be useful for something like a code review, when one needs to browse through a very long script with everything revealed.
Also, when using the SSMS Quick Find dialog to find occurances of a text string, remember to enable the “Search hidden text” option, if you want to find within folded regions. That’s not a missing feature, but just a FYI to end users. Connection Coloring – Top & Bottom I already was using the connection coloring feature built into SSMS – the one you access via Registered Servers (right clickPropertiesConnection Properties tabUse custom color). But that only put a custom color on the bottom status bar. Adding SSMS Tools’ top bar coloring gives me both and makes sure I don’t miss the glowing red strip at the bottom in my haste to put out that next fire.
SSMS Tools also works better because the standard connection coloring only seems to work when I open the connection from Registered Servers. Good stuff, Mladen.
And thanks for writing it up Grant.
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. I am planning new awesome features for the next version so be on the lookout. The biggest change is that for SSMS 2012 is no longer free. For previous SSMS versions it is still free. Now offers following options: Per machine license.
($29.99) Perfect if you do all your work from a single machine. This license is valid per major release of SSMS Tools Pack (e.g. V2.x, v3.x, v4.x). Fully transferable license valid for 3 months.
($99.99) Perfect for work across many machines. It's not bound to a machine or an SSMS Tools Pack version. 30 days license.
Time based demo license bound to a machine. You can view all the details on the. If you want to receive email notifications when new version of SSMS Tools Pack is out you can do that on the or on the. This is also the last version to support SSMS 2005 and 2005 Express.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |