I know I keep using the word "intuitive", but that's because that's the word that kept coming to my mind the first few times I used it there's simply no better word to describe it (plus I lost my thesaurus :)! Oh, and if all of that intuitiveness isn't enough for ya, guess what happens when you highlight, say, a table or a view while in this dialog? It shows you that object's schema! Yeah. Then, if you know you're looking for a specific type of object, you can use the intuitive Ctrl-left & right keystrokes to change which tab you're on, allowing you to filter out all of the objects except for a particular type. are all listed in the same list, each with a little icon indicating what type they are. In the initial view, tables, views, stored procs., etc. What's more, we're not just talking about a single drop-down with available choices, but a full-blown contextual dialog that intuitively shows you what you're most likely looking for. The first thing you'll notice when you first kick up Management Studio after installing is a little, unobtrusive dialog box pops up at the bottom right hand corner of your screen, letting you know that it's parsing through your databases, determining their schema so that it can provide you with the coolest feature: IntelliSense (though they don't call it that. Just simple tab-completion of the typical commands (SELECT, UPDATE, DELETE, FROM, WHERE) would've been a godsend, but when I finally found SQL Prompt, I got a lot more than just that. The structure of SQL statements are such that it seems like you keep writing the same things over and over again, substituting a few words here and there. For years I've been doing SQL development as part of my larger coding projects and every time I'd write a piece of SQL I'd think to myself, "ugh - this is so inefficient". So, in case you hadn't noticed, I think SQL Prompt is awesome. In this post, I'm going to give more of a high-level review/overview of all my favorite features without all the screenshots and captions, and (hopefully) follow this post up with a more in-depth post drilling down into the specifics at some point in the near future. It's not really an understatement to say that this tool has changed the way I do database development.
The reason I didn't finish was not because I lost interest or became bored, but simply because there was so much I wanted to write about.
SQL PromptĪ few weeks ago, I tried reviewing SQL Prompt and I never finished. Along with its companion, SQL Compare, I can be sure that all my databases are exactly the same at any given time, from schema to data, all with a real nice user experience. Another tool that I use on a daily basis - so much so that it's actually become a part of my standard release process - is SQL Data Compare, which has been a wonderful help in keeping all of my databases synchronized. For that reason, this review will focus primary on SQL Prompt, which is the one thing I use on a daily (hourly!) basis, and has saved me untold amounts of time since I first installed it. Seriously, there is a LOT of stuff in there, and I just don't have that kind of time. I'm gonna follow that intro off with an admission of guilt: I haven't fully explored everything in the Toolbelt. If it has anything to do with working with databases, you can be sure that Red Gate has something that'll help you do it. I'm gonna start out this review with: "Wow, that's a LOT of stuff!" Red Gate's SQL Toolbelt package has a whole slew of tools that'll keep you happy for some time.
0 kommentar(er)
