question

Brimstedt avatar image
Brimstedt asked

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?

developerdevelopmentclient-tools
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

CirqueDeSQLeil avatar image
CirqueDeSQLeil answered

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)

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
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.
0 Likes 0 ·
Matt Whitfield avatar image
Matt Whitfield answered

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 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image Fatherjack ♦♦ commented ·
+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 :)
0 Likes 0 ·
Fatherjack avatar image
Fatherjack answered

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.

3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Matt Whitfield avatar image Matt Whitfield ♦♦ commented ·
+1 - you are one majorly tooled up developer!
0 Likes 0 ·
Fatherjack avatar image Fatherjack ♦♦ commented ·
So thats what they meant!!!
0 Likes 0 ·
TimothyAWiseman avatar image TimothyAWiseman commented ·
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.
0 Likes 0 ·
Håkan Winther avatar image
Håkan Winther answered

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.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image
ThomasRushton answered
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!
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

AlexTheDeveloper avatar image
AlexTheDeveloper answered
I recommend [**SQL Hunting Dog**][1] It is a plugin for SQL Server Management Studio 2008 or 2012 and it gives you quick search and smooth navigation between your tables, stored procedures, functions and view. [1]: http://www.sql-hunting-dog.com
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·
You should add a disclaimer that this is your own product, otherwise this could be removed as advertising spam
1 Like 1 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.