Solved

A better solution to SSMS for MS SQL for DB administration

Posted on 2016-09-13
11
237 Views
Last Modified: 2016-09-29
I am looking for an all in one MS SQL tool for my MS SQL servers.  The one that I am looking at is DBForge.  But I am not sure if this is a good choice or if there is a better tool out there that would be better and more robust to using SSMS.

Does anyone have any suggestions of alternative tools to SSMS?

Thanks
0
Comment
Question by:GabicusC
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +2
11 Comments
 
LVL 13

Assisted Solution

by:Nakul Vachhrajani
Nakul Vachhrajani earned 83 total points
ID: 41797309
I have worked with colleagues who used Toad For SQL from Dell. One of the reasons they used Toad was because they came from an Oracle background and they were familiar with the Toad product already.

Another alternate that you can look at is Idera (they have different "suites" which you can license based on the usage, e.g. Infrastructure teams can get the Maintenance and Security suites, whereas development teams can get performance suite).
0
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 41797835
SSMS will allows you to connect to SQL Server instances, SSAS and SSIS as well.
Any other that you'll use to replace it will limit you to connect mostly to the databases.
0
 
LVL 2

Assisted Solution

by:larryh
larryh earned 83 total points
ID: 41798093
What about SSMS is causing you to look elsewhere?
0
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 41820066
Can't really understand why a comment with a question should be marked as a solution.
0
 
LVL 2

Expert Comment

by:larryh
ID: 41820136
I thought it odd I could vote to add my own comment as a solution.  My reasoning for including this as a solution was that we didn't have a good spec on what the OP wanted.  To me asking a good question is sometimes just as helpful.
0
 

Author Comment

by:GabicusC
ID: 41820209
Hey Everyone,

Was in crises mode and did not get back to this question.

To answer larryh question.  I was monitoring our website that was losing connection to the DB.   I usually use profile to do this kind of troubleshooting.  Like I always have.

But recently I have been on job interviews where I keep getting called out because I using SSMS and Profile and not the "cool tools".  Because I work in a non-profit and have not been in an environment with other SQL guys.  I thought maybe I am missing something that would make my job easier.

From what I have seen, no, I am doing things correctly and have been for the past 15 years.  I can see that the interviewers are young and inexperience.  The only way they can make them self look good is to call out others

Not for sure how to close this question.

Best
0
 
LVL 39

Assisted Solution

by:Aaron Tomosky
Aaron Tomosky earned 83 total points
ID: 41820805
IMO
SSMS does management of SQL server just fine.

Now if you want to do advanced monitoring/performance/etc... there are additional tools for that, not meant to replace SSMS. Personally I use 3rd party backup tools, monitoring tools, merging tools, etc... but I still use the heck out of SSMS for normal stuff.

Redgate has all kinds of awesome things, I've never used this tool personally but I've used the rest and highly recommend them
http://www.red-gate.com/products/dba/sql-monitor/

http://www.solarwinds.com/topics/sql-server-monitor/
https://www.manageengine.com/sql-performance-monitor/sql-server-monitoring-index.html
Already mentioned above but here is the link
https://www.idera.com/productssolutions/sqlserver/sqldiagnosticmanager
1
 
LVL 50

Accepted Solution

by:
Vitor Montalvão earned 251 total points
ID: 41821245
I'm working with SQL Server for 20 years and never had the need to use any 3rd party tool to do my job.
1
 

Author Closing Comment

by:GabicusC
ID: 41822336
Thank you, everyone, for your input.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Display SQL maintenance plan SQL Code 3 45
SQL Lag Function DateDiff 2 25
Migration of public folders - Exchange 2010 2 33
Sql server query 8 19
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question