Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Central Management Server (CMS) Rss

   Items 1 to 11 of 11   
 

Using Extended Properties To Keep Everyone Informed

Use CMS and Extended Properties to store information about multiple servers, including the stakeholders who should know about any maintenance you are planning.  Read more...
By E Bond 2014/01/01 (first published: 2010/11/30) | Source: SQLServerCentral.com | Category: central management server (cms)
Rating: |  Discuss |   Briefcase | 8,962 reads

Central Management Server Security

By Steve Jones 2013/12/24 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,194 reads

Powershell - Query SQL Servers Operating system details

The script works through the CMS you have set up to manage your environment and gathers various server information.  Read more...
By Justin Manning 2013/02/26 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,393 reads

Evaluating Policies on Multiple SQL Server Instances using Central Management Server

you have created a SQL Server Policy to check database recovery models. Now you need to check the databases on all of your SQL Server instances. In this tip we will show how you can evaluate a SQL Server policy against multiple instances.   Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,140 reads

Central Management Server Daily Script

These are scripts I run each morning on my registered CMS servers to check immediate health.  Read more...
Rating: |  Discuss |   Briefcase | 2,346 reads

Manage your environment with CMS

How to setup and use Central Management Server to manage a disperse environment.  Read more...
Rating: |  Discuss |   Briefcase | 4,847 reads

Centralized management: Tips for Managing Backups on Multiple Servers

Managing backups on a handful of servers should be a relatively straightforward process, but what about DBAs that need to automate to stay on top of large numbers of servers? What options are available, and how do they compare? Grant Fritchey looks at what's out there.  Read more...
By 2011/12/16 | Source: SimpleTalk | Category: central management server (cms)
Rating: (not yet rated)  Rate this |   Briefcase | 5,175 reads

SQL Server Central Management Server Security

I have seen several tips on SQL Server Central Management Server and I want to implement the technology for my team. The only thing holding me back is security. Can you explain how security works with Central Management Server? What security access is needed to manage CMS? How about connecting to CMS? How about running a query using CMS? Check out this tip to answer these questions.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,230 reads

Using Extended Properties To Keep Everyone Informed

Use CMS and Extended Properties to store information about multiple servers, including the stakeholders who should know about any maintenance you are planning.  Read more...
By E Bond 2014/01/01 (first published: 2010/11/30) | Source: SQLServerCentral.com | Category: central management server (cms)
Rating: |  Discuss |   Briefcase | 8,962 reads

Policy-based Management and Central Management Servers

Whilst it may be more exciting as a DBA to rush around fixing broken databases, it is far better to forestall problems by making sure that your servers conform with best-practices. It is even better if you can also manage your servers centrally, and monitor that they are all adhering to company policies.  Read more...
Rating:  Rate this |   Briefcase | 1,886 reads
   Items 1 to 11 of 11   
 
Tags
administration (5)    
policy based management (pbm) (2)    
security (2)    
extended properties (1)    
powershell (1)    
simple-talk series (1)