![]() It's not as sexy, but beyond that I've got a number of helper routines I've written that I use nearly every day. Figured if I was paying for it I might as well try to get the most I could. ![]() Used to use SSMS Tools Pack, but once it moved to a pay version that's when I moved on to a more robust add-on. I also use Red Gate's SQL Search (and SQL Monitor & backup, though not SSMS add-ons :). I know I sound like a total shill for the company, but I can't help it - it's changed the way I develop! ![]() It's $120 US per license, with some discounts if you buy more. With those things alone I almost never manually go into Object Explorer anymore and that's a good thing :) There are lots of other included features that are found in other products, but having them all in this one add-on makes it my new favorite SQL dev tool. SQL-based migrations are typically used for. It gives you access to the full set of capabilities of your database and eliminates the need to understand any intermediate translation layer. This makes it easy to get started and leverage any existing scripts, tools and skills. That takes you straight to the object in Object Explorer similar to the behavior in Visual Studio. Migrations are most commonly written in SQL. You can also hit F12 to go to definition on any object: tables, views, SPROCs, functions, etc. You hit TAB and it brings in the SPROC definition. Besides all the vastly improved "normal" intellisense business, you can do things like: alter procedure SomeProcedureName ![]() It's essentially intellisense on massive steroids. My latest find has been SQL Complete by devart.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |