Tool for SQL DBAs

Posted on 2011-10-14
Last Modified: 2012-05-12
I currently in a team where we manage about 50 SQL servers which have the same schemas and each time we need to make changes we have to go server by server to do that. Is there some kind of tool for DBAs that I need to be aware of. Especially this tool should be able to deploy scripts across the servers.

Question by:mamlaide
    LVL 25

    Expert Comment

    you can do it by:-
    1. Powershell scripting
    2. Registered servers
    LVL 69

    Expert Comment

    by:Éric Moreau
    LVL 23

    Expert Comment

    by:Racim BOUDJAKDJI
    LVL 8

    Accepted Solution

    In SQL Server 2008, you can query multiple servers at the same time by creating a local server group, or a Central Management Server and one or more server groups, and one or more registered servers within the groups, and then querying the complete group. The results that are returned by the query can be combined into a single results pane, or can be returned in separate results panes. The results set can include additional columns for the server name and the login that is used by the query on each server. Central Management Servers and subordinate servers can be registered by using only Windows Authentication. Servers in local server groups can be registered by using Windows Authentication or SQL Server Authentication.

    To execute statements against multiple configuration targets simultaneously

    In SQL Server Management Studio, on the View menu, click Registered Servers.

    Expand a Central Management Server, right-click a server group, point to Connect, and then click New Query.

    In Query Editor, type and execute a Transact-SQL statement, such as the following:

    USE master
    SELECT * FROM sysdatabases;

    Open in new window

    To change the multiserver results options

    In Management Studio, on the Tools menu, click Options.

    Expand Query Results, expand SQL Server, and then click Multiserver Results.

    On the Multiserver Results page, specify the option settings that you want, and then click OK.

    LVL 2

    Expert Comment

    Reg-Gate.  They have a free 14-day trial for their tools for you to evaluate them.  Also, they will grant you a free  extension to you trial, if you need it.  You can get the extension by sending an email, without dealing with a sales rep.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Viewers will learn how the fundamental information of how to create a table.

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now