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

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,619 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 | 196 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,449 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,951 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,672 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 | 9,057 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,666 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 | 29,692 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 | 189 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,982 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: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 20,808 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: SQLServerCentral.com | 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: SQLServerCentral.com | Category: blocking
Rating: |  Discuss |   Briefcase | 6,248 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,616 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: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 15,046 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: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 16,630 reads

Minimal Logging

This article discusses minimal Logging in SQL Server.   Read more...
By Harsha Majety 2013/08/26 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,392 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,786 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: SQLServerCentral.com | Category: upgrading
Rating: |  Discuss |   Briefcase | 3,437 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: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,755 reads
<< Newer    Items 21 to 40 of 815    Older >>