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 805    Older >>
 

Kill SPID (SQL Spackle)

How to find and kill a runaway or blocking session.  Read more...
By Kenneth Fisher 2014/07/01 | Source: SQLServerCentral.com | Category: kill
Rating: |  Discuss |   Briefcase | 2,607 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: SQLServerCentral.com | Category: maintenance plans
Rating: |  Discuss |   Briefcase | 2,144 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: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 2,935 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: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 5,977 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: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 94 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: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 6,020 reads

Mini-Me

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: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 552 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: SQLServerCentral.com | 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: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 429 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: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 164 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: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 2,598 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: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 190 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,239 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: MSSQLTips.com | Category: administration
Rating:  Rate this |   Briefcase | 3,758 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: MSSQLTips.com | Category: configuration repository
Rating:  Rate this |   Briefcase | 3,495 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,972 reads

The PoSH DBA - SQLPSX: SQL Server PowerShell Extensions

Every DBA needs to know about SQLPSX, the PowerShell module library that is built by DBAs for DBAs, and designed to provide intuitive functions around the SMO objects. Laerte Junior, who is one of the developers on the open-source project, describes how to use it.  Read more...
By Additional Articles 2013/12/27 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,487 reads

Moving Large Table to Different File Group

How to Move Large Table to Different File Group  Read more...
By Raj Gujar 2013/12/06 (first published: 2008/10/16) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 27,731 reads

The Future of Auditing

Auditing is a weak point in SQL Server according to Steve Jones. He looks at a few of its flaws.  Read more...
By Steve Jones 2013/12/05 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 182 reads

The PoSh DBA – Getting Airborne with PowerShell

Maybe the best way of helping the busy database professional to get started with practical PowerShell-based administration is to pull together all the essential community cmdlets into a toolkit for the POSH DBA, and explain how and why you'd use them.  Read more...
By Additional Articles 2013/11/11 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,835 reads
   Items 1 to 20 of 805    Older >>