What tools do you use to increase efficiency and productivity for SQL Development

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?

more ▼

asked Mar 11, 2010 at 07:21 AM in Default

avatar image

226 4 5 7

(comments are locked)
10|1200 characters needed characters left

6 answers: sort voted first

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)

more ▼

answered Mar 11, 2010 at 07:25 AM

avatar image

5.5k 11 13 20

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, 2010 at 10:46 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Mar 11, 2010 at 08:05 AM

avatar image

Matt Whitfield ♦♦
29.5k 62 66 88

  • 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, 2010 at 08:08 AM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Mar 11, 2010 at 08:07 AM

avatar image

Fatherjack ♦♦
43.8k 79 102 118

  • you are one majorly tooled up developer!

Mar 11, 2010 at 08:20 AM Matt Whitfield ♦♦

So thats what they meant!!!

Mar 11, 2010 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, 2010 at 11:02 AM TimothyAWiseman
(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Mar 11, 2010 at 09:44 AM

avatar image

Håkan Winther
16.6k 38 46 58

(comments are locked)
10|1200 characters needed characters left

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!

more ▼

answered Dec 15, 2010 at 02:05 AM

avatar image

ThomasRushton ♦♦
42.4k 20 60 54

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 11, 2010 at 07:21 AM

Seen: 3580 times

Last Updated: Aug 09, 2013 at 10:42 AM

Copyright 2018 Redgate Software. Privacy Policy