1

While working with DB, I find useful using some tools, that help me to solve DB problems.

Some of them are:

1) Insert generator

2) A tool that can execute a script on a list of DB's

3) Finding a text in stored procedures and functions.

4) DB Back up scripts

My question is, what are most useful tools, scripts(anything else), that help you to work with SQL Server?

Thanks in advance.

UPDATE

I assume, there are no other tools for SQL Server 2008 or any other version?

Improve this question
0

3 Answers 3

Reset to default
2

Redgate has a collection of quite powerful tools for Sql Server.

Improve this answer
Sign up to request clarification or add additional context in comments.

9 Comments

$1,995$? Maybe I should add word "free" to my question?
@hgulyan: first, you didn't specify free, and second those Red-Gate tools are worth their price - every penny of it!
@marc_s, I didn't say that this answer isn't useful. It's really is and there're some free tools on this site too. All I was saying, that I can't afford that kind of tool. That's the only problem, but I'm surely interested in all tools, that are useful.
@marc_s, I'd be happy to have this tool and some others, but I can't afford it by myself and my boss doesn't want to spent money on tools either.
@marc_s, at some places it is easier to get blood from a stone than get the software tools you need. I worked at a place that upgraded all user PCs (a few hundred) from Windows 3.1 only because of Y2K (and it was in December 1999 when they upgraded). I'm sure they would still be on win 3.1 if it weren't for Y2K.
|
2

Check out the SMSS Tools Pack.

Improve this answer

Comments

1

I have stored procedures that do the following:

system utilities:

  • find and list every occurrence and info about a given column name or partial column name
  • find and list every occurrence and info about a given object name or partial object name
  • list out all the information for a given table, all columns, computed columns, column data types, nullability, defaults, identity, check constraints, index, pk, fk, triggers, and column comments.
  • find every trigger, view, stored procedure, or function that contains a given string

business utilities:

I also make stored procedures that work with business info. When working on an area of our application I'll make a procedure that displays out all the related info of a given thing. I'll usually display all the info using multiple PRINTs and SELECTs for everything that can join to the given PK (not if there are thousands or rows though). For example, one utiltiy would take a DoctorID as a parameter and list out all the doctor's info, offices that they work at, insurance they accept, etc. I like to include the table names in the output so I can remember where the data comes from without looking at the code. I also join in all the codes tables in these displays, so I'm not looking "A" but "Active (A)". After working on a system for a while, I have loads of these utilities, which greatly helps when a support call comes up or you need to debug a problem, etc. I usually build these as I develop, it is difficult to find time to go back and make them.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.