This weekend, while working on performance testing of various data layer strategies, I ran across the SSMS Tools Pack. I downloaded and installed it because it contained a tool to auto-generate all of the CRUD operations for a given table. So far, I have been impressed. I am not a DBA, so maybe I am naive and there are better tools on the market. But this free plug-in for SQL Management Studio and SQL Management Studio Express has a number of nice features. I really like the query history. SSMS Tools Pack keeps a history, on disk, of every query you run. I cannot count the number of times that I needed to go back in time to find a query I had been using, something really complex or tedious to type in, that I closed.
The CRUD generation of stored procs is nice. A new query window is opened with the insert, update, delete and select queries generated. At this point I usually do a few tweaks and execute.
Try it out yourself. Download it and let me know what you think.
