Tools for SQL Developers

Question

Tools for SQL Developers

dina berry-193710

SSC Journeyman

Points: 83
More actions
December 15, 2005 at 9:06 am

#102986

There are been a couple of great articles about the "top ten tools" for .net developers recently. These are great tools and I'm thrilled to learn about them so easily. What I'm wondering is about the same type of list for SQL developers or SQL Admins. Generally the tools are free or open-source and fill a small-niche that is otherwise a pain to deal with. Any suggestions out these?
Thanks,
Dina

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

David.Poole SSC Guru Points: 76078 More actions · Answer 1

Well the APEX stuff isn't free but it is very good. If you start with a shrink wrapped ApexSQL Doc and a cup of coffee it will pay for itself by the time you finish your coffee.

LinkedIn Profile

Steve Jones - SSC Editor SSC Guru Points: 737004 More actions · Answer 2

Most SQL Server tools aren't free and some aren't that cheap, but they are very useful and since you tend to buy fewer copies (less DBAs v developers) it works ok.

The Red Gate and Apex tools get great reviews and aren't expensive.

dina berry-193710 SSC Journeyman Points: 83 More actions · Answer 3

Hi Steve and David,

Thanks for replying. Seems I need to look into APEX and Red Gate.

How about top 10 sql statements? Seem like there are a couple I keep readily available. How about you?

Also, is there a listing on SQl server central about it's design/development/objects. This HTML control is great. Is it home grown or 3rd party?

Thanks again,

Dina

Steve Jones - SSC Editor SSC Guru Points: 737004 More actions · Answer 4

SQLServerCentral.com is built on a fw things. The forums are InstantForums (http://www.instantasp.com/) and has some controls. Other parts are custom developed. We use Lyris for mailing and BannerManPro for ads.

I have some SQL statements, but they have mostly varied by job. The types of things are the same (checking data, qty of changed records, etc.) but they are different. Most of the similar stuff I use is sp_who2, etc., system functions.

David.Poole SSC Guru Points: 76078 More actions · Answer 5

Strangely enough you can achieve quite a bit with just SQL Query Analyser and the template functions.

Right-clicking on an option and choosing "Script to new window as..." allows the rapid building of standard queries.

I did see a brief demonstration of something called TOAD but I haven't gone into it in any details.

One product I would love to get hold of is Intelisense for SQL Query Analyser.

LinkedIn Profile

David A. Long SSCrazy Eights Points: 8421 More actions · Answer 6

Here are some great free tools, I found this looking for a way to search the LAN for all of those instances of MSDE, did you know that Office 2003 Business Contact Manager installs MSDE?

I found that 70 laptops had it installed, and no one knew it because these were OEM installations from Dell!

http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=26

SQLRecon was a lifesaver. It is also useful for finding the version each SQL Server, etc..

Andy

Johnny Ortega Grasshopper Points: 13 More actions · Answer 7

I'm going to plug the Toad for SQL Server freeware because I think it's a great free tool (I'm partial to it because I'm Dev Team Lead for it!) Check it out:

Freeware version:

http://www.toadsoft.com/toadsqlserver/toad_sqlserver.htm

Commercial version information is at:

http://www.quest.com/toad_for_sql_server/index.asp

From this commercial link, view the online demo and tutorial (tips and tricks) to get a feel for the power of Toad.

dina berry-193710 SSC Journeyman Points: 83 More actions · Answer 8

Thanks for the toad software mention. I've tried it out. Wow, it really packs punch for freeware. I like the ability to tell what sps depend on the sp i'm viewing.

K. Brian Kelley SSC Guru Points: 114703 More actions · Answer 9

PromptSQL? Oh, it's nice. Very nice.

K. Brian Kelley
@kbriankelley

michanne SSCrazy Points: 2329 More actions · Answer 10

On intelisence... Ultraedit has a form of intellisence and you can pretty easily edit the source file. I still use it over management studio (for a lot of reasons:-).