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.
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.
answered Jul 12, 2010 at 10:01 AM
Grant Fritchey ♦♦
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.
You can also refer this questions discussed here in this site before:
answered Jul 12, 2010 at 11:24 AM
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 :)
answered Jul 12, 2010 at 12:32 PM
Matt Whitfield ♦♦