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

Articles with tag administration Rss

Search for any content tagged administration

   Items 1 to 20 of 810    Older >>

How Often Does Production Drift?

Database drift is the difference between two database schemas. Today Steve Jones discusses the concept and wonders how often it happens.  Read more...
By Steve Jones 2014/11/24 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 114 reads

The Best Database Administrators Automate Everything

Do you understand the value of your time? I mean really understand it. Time is your absolute number one most valuable asset. Once it's gone, that's it, gone forever.  Read more...
By John Sansom 2014/08/22 (first published: 2012/04/06) | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 18,057 reads

Automate Your Central Management Server Registrations

Easily register SQL Servers in your inventory to your CMS for easy multi-server queries.  Read more...
By S. Kusen 2014/08/18 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 2,444 reads

Spackle: Making sure you can connect to the DAC

The DAC is an important tool and several things can go wrong when trying to connect to it.  Read more...
By Kenneth Fisher 2014/07/31 | Source: | Category: dac
Rating: |  Discuss |   Briefcase | 2,951 reads

Monitoring for Non Existent Events

Many DBAs monitor for those events they expect to happen, either successfully or failed. However many DBAs wouldn't be aware of an event never occurring.  Read more...
By Steve Jones 2014/07/31 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 137 reads

Kill SPID (SQL Spackle)

How to find and kill a runaway or blocking session.  Read more...
By Kenneth Fisher 2014/07/01 | Source: | Category: kill
Rating: |  Discuss |   Briefcase | 2,840 reads

Logging in Maintenance Plans

Enabling and Configuring Reporting and Logging for Maintenance Plans in SQL Server 2012  Read more...
By C.J. Garcia 2014/06/12 | Source: | Category: maintenance plans
Rating: |  Discuss |   Briefcase | 2,248 reads

Display All Errors Fired in a Restore Procedure

Display all errors thrown within a catch block by a restore statement in a stored procedure using extended events  Read more...
By Brian Awe 2014/06/10 | Source: | Category: restore
Rating: |  Discuss |   Briefcase | 3,066 reads

Index Utilization Trending

An important part of regular database maintenance is to monitor index usage and make adjustments as needed. How can we monitor, store, and trend this data effectively over time?  Read more...
By Edward Pollack 2014/05/05 | Source: | Category: indexing
Rating: |  Discuss |   Briefcase | 6,347 reads

Consolidation Matters

Consolidating SQL Server instances is something Steve Jones has done in the past and he thinks we'll all do more of in the future.  Read more...
By Steve Jones 2014/04/21 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 98 reads

Automate Sliding Window Partition Maintenance: Part III

Part 3 of Hugh Scott's series on automating sliding window partitions in SQL Server using PowerShell  Read more...
By Hugh Scott 2014/03/21 (first published: 2010/12/28) | Source: | Category: partitioning
Rating: |  Discuss |   Briefcase | 6,097 reads


This Friday Steve Jones asks if you build your own mini-me's to help you manage your database systems.  Read more...
By Steve Jones 2014/03/07 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 562 reads

Backup and Housekeeping with Maintenance Plans

Get an idea of how to handle the housekeeping tasks associated with backups, like removing old backup and log files.  Read more...
By Gethyn Ellis 2014/02/17 (first published: 2011/01/26) | Source: | Category: backup / restore
Rating: |  Discuss |   Briefcase | 11,286 reads

The DBA is Dead

Is the DBA Dead? Steve Jones scoffs at the notion put forth in an article and says we'll be using DBAs for a long time. He does, however, admit the role is changing.  Read more...
By Steve Jones 2014/01/29 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 436 reads

Management at Scale

Could you manage 20,000 databases? That's how many servers each person at Facebook has to manage in operations.  Read more...
By Steve Jones 2014/01/27 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 171 reads

Leveraging Constraint Evaluation Sequence in SQL Server

Constraints on a table in SQL Server are evaluated in a specific sequence. Knowing this sequence can help us leverage them to realize various business requirements.  Read more...
By Nakul Vachhrajani 2014/01/27 | Source: | Category: sql server
Rating: |  Discuss |   Briefcase | 2,617 reads

Common Checks

This Friday Steve Jones wants to know what types of things are you checking for on your instances. What items can cause you issues if you don't proactively monitor for them.  Read more...
By Steve Jones 2014/01/24 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 193 reads

The PoSh DBA - Reading and Filtering Errors

DBAs regularly need to keep an eye on the error logs of all their SQL Servers, and the event logs of the host servers as well. When server numbers get large, the traditional Windows GUI approach breaks down, and the PoSH DBA reaches for a PowerShell script to do the leg-work.   Read more...
By Additional Articles 2014/01/20 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,354 reads

Creating a DBA's Library

A DBA Library: it's not the library in traditional terms where you have books and journals stacked on your desk; rather it's a centralized and integrated repository of knowledge, information and applications for the DBA.  Read more...
By Additional Articles 2014/01/17 | Source: | Category: administration
Rating:  Rate this |   Briefcase | 3,846 reads

Keeping Track of your SQL Servers with a DBA Configuration Repository

SQL Server DBAs are often responsible for managing large number of database instances. This article talks about the concept of a Configuration Repository where DBAs can manage all the information related to their SQL Servers  Read more...
By Additional Articles 2014/01/03 | Source: | Category: configuration repository
Rating:  Rate this |   Briefcase | 3,579 reads
   Items 1 to 20 of 810    Older >>