question

IT1 avatar image
IT1 asked

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

HI 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
dbacareerclient-tools
10 |1200 characters needed characters left characters exceeded

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 answered
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.
10 |1200 characters needed characters left characters exceeded

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

IT1 avatar image
IT1 answered
THanks a lot will surely try and get my hands on those tools. is there any tool for synchornizing databases and also for DTS
3 comments
10 |1200 characters needed characters left characters exceeded

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

Just a point for using the web site here. Instead of answering your question as part of the comments, use the "add new comment" button just below my answer to comment on that answer. And if you like an answer, click on the little hand with the thumb pointing up. Same thing with comments. Define "synchronizing database" if you mean comparing two databases, yes, SQL Compare is the tool for comparing structure. They also have SQL Data Compare which compares data. DTS is SQL Server 2000 technology. Unless someone is holding a gun to your head, don't work on that. Get involved with SSIS, SQL Server Integration Services.
1 Like 1 ·
Thnks again ... by synchronizing i mean i have 2 instance of the same database ... one is on the live server ,other is kind of a back up...I wanted to update the backup database with all the changes made in the live database without having to backup the whole live database again........ I hope it doesnt sound confusing
0 Likes 0 ·
@IT1: Best way to refresh your test/DEV server is to take a backup and restore it. But if it has to be refreshed everyday(like for a report server) and the size of your database is huge, you can build SSIS package to move data from one instance to the other and schedule it.
0 Likes 0 ·
DaniSQL avatar image
DaniSQL answered
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][3]. 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][1] and [Free Tools for the SQL Server DBA Part 2][2]. You can also refer this questions discussed here in this site before: [Tools Must have for a DBA][4] [3rd Party SQL Server management tools][5] [What tools do you use to increase efficiency and productivity for SQL Development][6] Good Luck! [1]: http://www.sqlservercentral.com/articles/Miscellaneous/2959/ [2]: http://www.sqlservercentral.com/articles/Tools/64908/ [3]: http://ola.hallengren.com/ [4]: http://ask.sqlservercentral.com/questions/5975/red-gate-tools-must-have-for-a-dba [5]: http://ask.sqlservercentral.com/questions/7480/3rd-party-sql-server-management-tools [6]: http://ask.sqlservercentral.com/questions/4738/what-tools-do-you-use-to-increase-efficiency-and-productivity-for-sql-development
1 comment
10 |1200 characters needed characters left characters exceeded

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

really appreciate all the help u ppl are giving out ! Thnks
0 Likes 0 ·
Matt Whitfield avatar image
Matt Whitfield answered
Here's a list for you... For synchronising schema changes - you can use: - [Schema Inspector][1] (my tool) - [SQL Compare][2] (Red Gate's tool) - [Apex SQL Diff][3] (Apex's tool) - [Visual Studio][4] (Microsoft's tool, Premium or ultimate only) For synchronising data changes - you can use: - [Data Inspector][5] (my tool) - [SQL Data Compare][6] (Red Gate's tool) - [Apex SQL Data Diff][7] (Apex's tool) - [Visual Studio][8] (Microsoft's tool, Premium or ultimate only) For code completion you can use: - [SQL Everywhere][9] (my IDE) - [SQL Prompt][10] (Red Gate's SSMS plugin) - [Apex SQL Edit][11] (Apex's IDE) For refactoring you can use: - [SQL Everywhere][12] (my IDE - but only basic refactoring in this) - [SQL Refactor][13] (Red Gate's SSMS plugin - some of which is in SQL Prompt) - [Apex SQL Refactor][14] (Apex's SSMS plugin - probably best in class) For running scripts on multiple targets you can use: - [SQL Everywhere][15] (my IDE) - [SQL Multi Script][16] (Red Gate's tool) 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 :) [1]: http://www.atlantis-interactive.co.uk/products/schemainspector/default.aspx [2]: http://www.red-gate.com/products/SQL_Compare/index.htm [3]: http://www.apexsql.com/sql_tools_diff.aspx [4]: http://msdn.microsoft.com/en-us/vstudio/default.aspx [5]: http://www.atlantis-interactive.co.uk/products/datainspector/default.aspx [6]: http://www.red-gate.com/products/SQL_Data_Compare/index.htm [7]: http://www.apexsql.com/sql_tools_datadiff.aspx [8]: http://msdn.microsoft.com/en-us/vstudio/default.aspx [9]: http://www.atlantis-interactive.co.uk/products/sqleverywhere/default.aspx [10]: http://www.red-gate.com/products/SQL_Prompt/index.htm [11]: http://www.apexsql.com/sql_tools_edit.aspx [12]: http://www.atlantis-interactive.co.uk/products/sqleverywhere/default.aspx [13]: http://www.red-gate.com/products/SQL_Refactor/index.htm [14]: http://www.apexsql.com/sql_tools_refactor.aspx [15]: http://www.atlantis-interactive.co.uk/products/sqleverywhere/default.aspx [16]: https://www.red-gate.com/products/dba/sql-multi-script/
10 |1200 characters needed characters left characters exceeded

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
To get a quick search and smooth navigation between objects (tables/stored procedure) - use [**SQL Hunting Dog**][1] It is a free Addin for SQL Server Management Studio 2008 / 2012. I have built it. [1]: http://www.sql-hunting-dog.com
4 comments
10 |1200 characters needed characters left characters exceeded

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

You should add a disclaimer that this is your own product, otherwise this could be removed as advertising spam
1 Like 1 ·
Kev, I have added information that it is my product.
0 Likes 0 ·
@AlexTheDeveloper Thanks! We look forward to your participation here.
0 Likes 0 ·
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/
0 Likes 0 ·
Håkan Winther avatar image
Håkan Winther answered
I would like to recommend two scripts, sp_blitz and sp_index_blits from [Brent Ozar][1] [1]: http://www.brentozar.com/blitz/
2 comments
10 |1200 characters needed characters left characters exceeded

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

Oh, I agree on those. Particularly given that they take user submissions for additional checks. They even took one from me!
0 Likes 0 ·
The second one is called, sp_BlitzIndex. And I second the recommendation, these scripts make you look very good.
0 Likes 0 ·

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.