|
What tools do you use to increase SQL development productivity? For writing procedures, doing ad-hoc queries, etc, I find SSMS the best tool of those that I've tried, but I still find it a poor tool for many reasons (bad intellisense, to limited in aspects to external tools and keybaord shortcuts, to mention a couple) So, what tools and plugins do you use, free and commercial, big or small?
(comments are locked)
|
|
Redgate has an intellisense (SQL Prompt) that seems to be decent - but a resource hog. TOAD for SQL is nice to help give you a plethora of alternative ways to write the same query (helps in tuning sometimes) Other than those, for writing TSQL, I use SSMS (2005 and prefer 2008) I'm not excited by TOAD, but I had to give you the vote up for SQL Prompt. Probably the best productivity and development tools for writing TSQL.
Mar 11 '10 at 10:46 AM
Grant Fritchey ♦♦
(comments are locked)
|
|
My T-SQL IDE! Surprisingly enough, I get on with it quite well - but I'm very focused on writing T-SQL, and not really managing / using visual table editors etc. The idea was to bring the intellisense level up to Visual Studio standards - although the language definition of SQL doesn't make that possible sometimes because of it's vagueness (a very basic example being the three different ways to assign an alias to a column). But it is free for personal use, so the price tag is good. :) For generation of lots of client side code at once, I've been using Apex SQL Code a bit recently too - they've released it free now, and it's quite richly featured, definitely worth a look. +1 - thanks for the tipoff about Apex, I didnt know it was free now, I also didnt know you have a TSQL IDE. Off to d/l now :)
Mar 11 '10 at 08:08 AM
Fatherjack ♦♦
(comments are locked)
|
|
I use SSMS but with SQL Prompt that CirqueDeSQLeil mentions. In fact I have the whole SQL Toolbelt from RedGate so I have tools that sit within SSMS to give me lots of extra functionality - object level restores, smart renaming of objects (dependant objects get re-scripted too), Test data generator, SQL Prompt 'intellisense' (**), Data comparison + Database schema comparison with script generation to synchronise, Database documentor and so on. I also install LogParser, Idera's Job Scheduler, Winmerge, and PowerShellAnalyser to list a few of the free apps that are available. ** - I havent experienced any resource issues using SQL Prompt personally but accept that everyones mileage may vary. I would say try the 14 day trial and see how it goes. +1 - you are one majorly tooled up developer!
Mar 11 '10 at 08:20 AM
Matt Whitfield ♦♦
So thats what they meant!!!
Mar 11 '10 at 08:36 AM
Fatherjack ♦♦
I was a huge fan of SQL Prompt with SSMS 2005. With SSMS 2008 connecting to a 2008 server I find it less useful, but some of its re factoring tools still come in handy at times. I am also a huge fan of Red Gate SQL Backup and SQL Compare.
Mar 11 '10 at 11:02 AM
TimothyAWiseman
(comments are locked)
|
|
I use SQL Server Management Studio (Intellisence in SQL server 2008) or Microsoft Visual Studio 2008 DB Edition. Sometimes, when I am not developing for SQL server 2008, I use Red-Gate Toolbelt.
(comments are locked)
|
|
I've just started using TOAD. Not yet getting fully into the swing of it, but it does seem to do the Intellisense stuff better than SQLWB / SSMS. Which is helpful. Just seen an in-built "take-your-results-and-build-your-own-pivot" thing which I may have to play with later. That could make it worth every penny, if you do a lot of that sort of thing. No idea how it delivers in terms of "bang per buck", because of a rather decent licence deal!
(comments are locked)
|
