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

<< Newer    Items 21 to 40 of 813    Older >>

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,437 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,941 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,653 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: | Category: central management server (cms)
Rating: |  Discuss |   Briefcase | 9,055 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,654 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: | Category: administration
Rating: |  Discuss |   Briefcase | 29,534 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: | Category: editorial
Rating: |  Discuss |   Briefcase | 188 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,972 reads

Stairway to Transaction Log Management in SQL Server, Level 1: Transaction Log Overview

The transaction log is used by SQL Server to maintain data consistency and integrity. If the database is not in Simple-recovery mode, it can also be used in an appropriate backup regime to restore the database to a point in time.  Read more...
By Tony Davis 2013/10/30 (first published: 2011/06/17) | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 20,693 reads

The Ratio

How many developers does it take to overwhelm a DBA? It's an interesting question, and this week Steve Jones asks how many you actually support.  Read more...
By Steve Jones 2013/10/04 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 156 reads

Blocking Chain (SQL Spackle)

Problems with blocking processes can be easy to identify with SQL Server DMV's.  Read more...
By Paul Lambert 2013/09/19 | Source: | Category: blocking
Rating: |  Discuss |   Briefcase | 6,223 reads

SQLServerCentral Webinar #27 - Daily DBA Tasks

Grant Fritchey will cover the key tasks DBAs should be tackling, including backup & recovery, performance monitoring, change management and much more. He’ll also show how these tasks can be made easier using Red Gate’s SQL DBA Bundle.  Read more...
By 2013/09/18 | Category: webinar
Rating: (not yet rated) |  Discuss |   Briefcase | 1,605 reads

SQL Server Error Log Scanning

This article will show you how to scan SQL Server Error Logs with ease and track important information that is stored there.  Read more...
By Rudy Panigas 2013/09/06 (first published: 2011/02/14) | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 15,044 reads

Drive Space Monitoring Gets An Update

Monitoring drive space is something every DBA ought to be doing. Shaun Stuarts brings us a method that can easily be used to keep track of your SQL Server instance  Read more...
By Shaun J. Stuart 2013/08/30 (first published: 2010/10/04) | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 16,628 reads

Minimal Logging

This article discusses minimal Logging in SQL Server.  
By Harsha Majety 2013/08/26 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 6,338 reads

Eight Steps to Effective SQL Server Monitoring

If you need to start monitoring your SQL Server instances and database, and there are many good reasons to do so, Tony Davis gives you the eight essential steps to diagnosing problems quickly.  Read more...
By Additional Articles 2013/08/26 | Source: SimpleTalk | Category: monitoring
Rating:  Rate this |   Briefcase | 4,762 reads

Upgrading the GIS application and database.

In this article I will mention a specific issue that I experienced during my last GIS application and database upgrade.  Read more...
By Hilda E 2013/08/20 | Source: | Category: upgrading
Rating: |  Discuss |   Briefcase | 3,435 reads

Orphaned Distribution Transactions

Learn about orphaned distribution transactions in SQL Server and how you can clear them.  Read more...
By Shashank Srivastava 2013/07/16 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 2,746 reads

Change the Maintenance Plan Owner

This article shows how you can change the maintenance plan owner in SQL SERVER  Read more...
By Shashank Srivastava 2013/07/02 | Source: | Category: maintenance plans
Rating: |  Discuss |   Briefcase | 1,257 reads

The Importance of Reading Comments

Read when you search for help on the internet. You might miss a very important part of what you must do.  Read more...
By Manie Verster 2013/06/10 | Source: | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 4,853 reads
<< Newer    Items 21 to 40 of 813    Older >>