What are some good tools to know for a new SQL admin..??


I have just started my career as an SQL admin I wanted to know some good tools i can learn also any other things whcih i need to learn to enhance my career opportunities.

thank you

more ▼

asked Jul 12, 2010 at 08:30 AM in Default

avatar image

388 27 33 37

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

6 answers: sort voted first

You have to start with the basics. Microsoft provides you with most of what you need. SQL Server Management Studio, while clunky & weird in places, is the tool for maintaining your servers and databases. It's also where you're going to run most of your T-SQL queries from. You need to learn SQL Agent, how to create and schedule jobs. Depending your employment siituation you'll need to learn either Integration Services or Reporting Services or both. I'd also recommend taking the time to pick up on Policy Based Management. Microsoft has also provided you with a great "tool" in the PowerShell language. Start working on learning it even though you're just getting started. For monitoring you can't go too far wrong using the Data Collector.

These are all fantastic tools that come, free, out of the box. I'd learn them first.

But what you're asking for is third party products. One that I would not want to live without is Red-Gate's SQL Prompt. It's a functional intellisense for all versions of SQL Server. Red-Gate also has a fantastic tool for comparing schema's SQL Compare. They just came out with a new tool that I'm still evaluating but I can safely recommend, SQL Source Control. SQL Source Control plugs into TFS or AVS and lets you treat your database like code. It's fantastic. Those are the ones I'd start with. DISCLAIMER: I'm a "Friend of Red Gate" which is a program where I get copies of their software and take part in their beta programs. I got there because I love their products, but I feel I should mention it when I'm singing their praises.

more ▼

answered Jul 12, 2010 at 10:01 AM

avatar image

Grant Fritchey ♦♦
137k 20 47 81

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

I agree with Grant that you should master the basics and for the most part you can do your job only using the native tools provided by Microsoft: SSMS, Profiler, Perfmon, Performance Dashboard, etc.

And take a look at this mainenance script by Ola Hallengren: SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization. Its the best script out there tested by many DBA's and I would definitely recommend you add it in your toolbox.

Also you can check out this article from SQL Server Central; Free Tools for the SQL Server DBA and Free Tools for the SQL Server DBA Part 2.

You can also refer this questions discussed here in this site before:

Tools Must have for a DBA

3rd Party SQL Server management tools

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

Good Luck!

more ▼

answered Jul 12, 2010 at 11:24 AM

avatar image

4.9k 33 39 43

really appreciate all the help u ppl are giving out !


Jul 12, 2010 at 11:32 AM IT1
(comments are locked)
10|1200 characters needed characters left

Here's a list for you...

For synchronising schema changes - you can use:

For synchronising data changes - you can use:

For code completion you can use:

For refactoring you can use:

For running scripts on multiple targets you can use:

All of the vendors mentioned have other tools too which are worth checking out. Obviously I'd like it if you checked out my tools, but to be fair to Red Gate and Apex - they have both done a fantastic job, and I just hope that my tools come close :)

more ▼

answered Jul 12, 2010 at 12:32 PM

avatar image

Matt Whitfield ♦♦
29.5k 62 66 88

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

I would like to recommend two scripts, sp_blitz and sp_index_blits from Brent Ozar

more ▼

answered Aug 12, 2013 at 08:55 AM

avatar image

Håkan Winther
16.6k 38 46 58

Oh, I agree on those. Particularly given that they take user submissions for additional checks. They even took one from me!

Aug 12, 2013 at 09:09 AM ThomasRushton ♦♦

The second one is called, sp_BlitzIndex.

And I second the recommendation, these scripts make you look very good.

Aug 12, 2013 at 09:17 AM raadee
(comments are locked)
10|1200 characters needed characters left

To get a quick search and smooth navigation between objects (tables/stored procedure) - use **SQL Hunting Dog**

It is a free Addin for SQL Server Management Studio 2008 / 2012.

I have built it.

more ▼

answered Aug 09, 2013 at 08:16 AM

avatar image

50 2 3

You should add a disclaimer that this is your own product, otherwise this could be removed as advertising spam

Aug 09, 2013 at 10:41 AM Kev Riley ♦♦

Kev, I have added information that it is my product.

Aug 12, 2013 at 05:07 AM AlexTheDeveloper

@AlexTheDeveloper Thanks! We look forward to your participation here.

Aug 12, 2013 at 08:15 AM Kev Riley ♦♦

I've tried Alex addin and it is really good, quick and slim.

I did a quick test and wrote a tiny review about it http://sqlraid.wordpress.com/

Aug 12, 2013 at 09:19 AM raadee
(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: Jul 12, 2010 at 08:30 AM

Seen: 3024 times

Last Updated: 2 days ago

Copyright 2018 Redgate Software. Privacy Policy