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

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 | 19,619 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 | 155 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 | 5,927 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 | 993 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 | 14,926 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,550 reads

Minimal Logging

This article discusses minimal Logging in SQL Server.  
By Harsha Majety 2013/08/26 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 5,815 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,534 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,413 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,614 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,004 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,846 reads

How to Change the SQL Server Name after Renaming the Windows Host

This article shows how to change a SQL Server name after changing the Windows machine name.  Read more...
By Shashank Srivastava 2013/05/16 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 6,798 reads

Loginless In Seattle

Identify orphaned Database Users and differentiate them from "Loginless" Database Users.  Read more...
By Orlando Colamatteo 2013/05/13 | Source: | Category: security
Rating: |  Discuss |   Briefcase | 2,914 reads

Throttle a Query in Mid-Execution

Resource Governor provides a great mechanism for throttling resources, but it doesn't always allow granular control. Read about this trace flag that allows you to dynamically alter the resource usage of a query.  Read more...
By Steve Jones 2013/04/01 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 5,484 reads

Resetting DMVs

Steve Jones asks the question why so much data in SQL Server is cleared when we restart an instance.  Read more...
By Steve Jones 2013/03/13 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 129 reads

Brent Ozar's Six Scary SQL Surprises

In lesson 3 of the Top 5 Hard-earned Lessons of a DBA series, Brent Ozar exposes six common but scary surprises that can lurk behind the façade of SSMS. Read it now, and learn hard lessons the easy way.  Read more...
By Additional Articles 2013/03/08 | Source: Red-Gate | Category: administration
Rating: (not yet rated)  Rate this |   Briefcase | 6,597 reads

Working with SQL Server Recovery Models

The recovery models of SQL Server define how different backup and restore tasks will be performed on your database. When choosing a recovery model,   Read more...
By Prett Sons 2013/03/05 | Source: | Category: recovery model
Rating: |  Discuss |   Briefcase | 3,441 reads

Troubleshooting and Fixing SQL Server Page Level Corruption

Corrupt SQL Server databases are the worst nightmare of any SQL Server professional. In any environment, from small business to enterprise, the compromise of integrity and availability of the data can constitute a business emergency. This is especially the case in those organizations reliant on an OLTP data model, for a high-volume website. SQL Server database corruption and disruption of the transaction processing system can cause business repercussions such as large financial losses, a drop in reputation or customer retention, or contractual SLA problems with the service provider, if not managed in-house.  Read more...
By Additional Articles 2013/02/18 | Source: | Category: corruption
Rating: (not yet rated)  Rate this |   Briefcase | 2,389 reads

Moving Database Files in SQL Server

A short article that talks about the isues with moving SQL Server database files around on your storage subsystem.  Read more...
By Perry Whittle 2013/02/11 | Source: | Category: files and filegroups
Rating: |  Discuss |   Briefcase | 7,726 reads
<< Newer    Items 21 to 40 of 805    Older >>