SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag Administration Rss

Search for any content tagged administration

<< Newer    Items 41 to 60 of 825    Older >>

Automate Your Backup and Restore Tasks

A new article that shows how you can automate a basic function that many environments need: the backup of a production database and the restore on a development system.  Read more...
By Philip Horan 2013/09/20 (first published: 2010/10/05) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 15,950 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,593 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,656 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,123 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,713 reads

Minimal Logging

This article discusses minimal Logging in SQL Server.  
By Harsha Majety 2013/08/26 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,990 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 | 5,201 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,454 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 | 3,003 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: SQLServerCentral.com | Category: maintenance plans
Rating: |  Discuss |   Briefcase | 1,651 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: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 4,858 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: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,994 reads

Loginless In Seattle

Identify orphaned Database Users and differentiate them from "Loginless" Database Users.  Read more...
By Orlando Colamatteo 2013/05/13 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 3,032 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: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,614 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: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 133 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: Redgate | Category: administration
Rating: (not yet rated)  Rate this |   Briefcase | 6,746 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: SQLServerCentral.com | Category: recovery model
Rating: |  Discuss |   Briefcase | 3,551 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: MSSQLTips.com | Category: corruption
Rating: (not yet rated)  Rate this |   Briefcase | 3,066 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: SQLServerCentral.com | Category: files and filegroups
Rating: |  Discuss |   Briefcase | 8,043 reads

Evaluating Policies on Multiple SQL Server Instances using Central Management Server

you have created a SQL Server Policy to check database recovery models. Now you need to check the databases on all of your SQL Server instances. In this tip we will show how you can evaluate a SQL Server policy against multiple instances.   Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,650 reads
<< Newer    Items 41 to 60 of 825    Older >>