SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
Home Articles Editorials Forums Scripts Blogs QotD SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us
 

Content with tag Administration Rss

Refine your search with one of the following additional tags (with number of items):

SQL Server 2005 (147)     Maintenance and Management (2)     Career (1)     Programming (1)    
SQL Server 7, 2000 (23)     Miscellaneous (2)     Data Warehousing (1)     Scalability (1)    
Administering (18)     News (2)     DMF (1)     SMO (1)    
Reporting Services (16)     SQL Server 2000 (2)     DMVs (1)     SQL 2005 (1)    
Development (6)     2005 Compact Edition (1)     Indexing (1)     SQL Server 2005 - Security (1)    
Monitoring (5)     addition (1)     INFORMATION_SCHEMA (1)     SQL Server 2005 - SSIS (1)    
Backup and Recovery (4)     Advanced (1)     Installation (1)     SQL Server 2005 Express (1)    
Performance Tuning (4)     Advanced Querying (1)     Jobs (1)     SQL Server 2008 (1)    
Index Management (3)     Architecture (1)     Maintenance (1)     Storage (1)    
Strategies (3)     Auditing (1)     Management (1)     String Manipulation (1)    
T-SQL (3)     Automation (1)     Normalization (1)     Table Valued Function (1)    
Database Design (2)     Backup (1)     Performance Monitoring (1)     tables (1)    
Disaster Recovery (2)     Backup / Restore (1)     Performance Tuning and Scaling (1)    
   Items 1 to 20 of 416    Next 20 >>
 

SQL Server 2005 Service Accounts

Are you aware that SQL Server 2005 can have up to ten services running? Working with that many service accounts can be a challenge. Steve Jones takes a look at these services and a few of the things that you will want to know before setting up SQL Server 2005.   Read more...
By Steve Jones 2008/07/11 (first posted: 2006/03/23) | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 30,741 reads

Delete files older than n-days via T-SQL

Delete files on a fileshare leaving behind files not older than n-days.  Read more...
By Gordon 2008/06/05 | Source: SQLServerCentral.com | Category: Administration
Rating: (not yet rated) |  Discuss |  Briefcase | 115 reads

When sp_depends fails

sp_depends may not always return accurate information  Read more...
By Jano Petras 2008/05/27 | Source: SQLServerCentral.com | Category: Administration
Rating: (not yet rated) |  Discuss |  Briefcase | 28 reads

SQL 2005 - List Primary Key Columns

Will list Table Name, Constraint name and Primary Key Column Name  Read more...
By Sandeep Saretha 2008/05/16 | Source: SQLServerCentral.com | Category: Normalization
Rating: (not yet rated) |  Discuss |  Briefcase | 100 reads

Moving Databases

SQL Server trainer and longtime expert, Andy Warren brings us a great article on one basic skill that every DBA should know.  Read more...
By Andy Warren 2008/05/12 | Source: SQLServerCentral.com | Category: Administration
Rating: (not yet rated) |  Discuss |  Briefcase | 11 reads

Statistics

Read more...
By SveG 2008/05/09 | Category: Administration
Rating: (not yet rated) |  Discuss |  Briefcase | 1,629 reads

The Differences Between SQL Server 2000 and 2005

What are the differences between SQL Server 2000 and 2005? It's a question that DBAs are often asked by those who don't work with SQL Server on a daily basis. Steve Jones begins a short series on the differences by examining some of the core administrative differences.   Read more...
By Steve Jones 2007/08/31 (first posted: 2007/05/15) | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 65,362 reads

Upgrading a Database SQL 2000 to SQL 2005

Performing an upgrade to the next version of SQL Server is something more and more of us will be doing as the support for SQL Server 2000 wanes. New author Sachin Samuel brings us an overview of the process and options that you have for performing an upgrade.   Read more...
By Sachin Samuel 2007/05/16 | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 30,376 reads

An easy way to track the growth of your database

This query gives you an idea of the growth of your database over time.  Read more...
By Sylvia Moestl Vasilik 2008/05/07 | Source: SQLServerCentral.com | Category: Backup
Rating: |  Discuss |  Briefcase | 1,004 reads

DAC Port

Read more...
By Site Owners 2008/04/30 | Category: SQL Server 2005
Rating: (not yet rated) |  Discuss |  Briefcase | 2,186 reads

Verify Last successful CHECKDB on all databases

Creates a resultset that expresses the last time a successful CHECKDB was performed on every database in the instance. Does not work on SQL 2000.  Read more...
By Kyle Neier 2008/04/29 | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 726 reads

SQL Server Express DAC

Read more...
By Site Owners 2008/04/24 | Category: SQL Server 2005 Express
Rating: (not yet rated) |  Discuss |  Briefcase | 2,253 reads

SQL Server 2005 Build List

Build List Updated with Cumulative Update 7 for SP2.   Read more...
By Steve Jones 2008/04/23 (first posted: 2007/04/23) | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 43,865 reads

Backups

Read more...
By Site Owners 2008/04/21 | Category: Backup and Recovery
Rating: (not yet rated) |  Discuss |  Briefcase | 2,804 reads

SQL agent question

Read more...
By samiksc 2008/04/16 | Category: Administration
Rating: (not yet rated) |  Discuss |  Briefcase | 2,957 reads

Deploying Reports

Longtime SQL Server expert Raj Vasant takes a look at various ways in which you can deploy reports for Reporting Services 2005.   Read more...
By Vasant Raj 2007/06/05 | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 10,164 reads

SQL Server Script to Create Windows Directories

An interesting script to handle file tasks from within SQL Server.  Read more...
By Additional Articles 2008/04/16 | Source: MSSQLTips.com | Category: Administration
Rating:  Rate this |  Briefcase | 3,453 reads

SQL Server 2005 - Backup, Integrity Check and Index Optimization

Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005.  Read more...
By Ola Hallengren 2008/04/15 | Source: SQLServerCentral.com | Category: Backup / Restore
Rating: |  Discuss |  Briefcase | 2,739 reads

Analyze and Correct a large SQL Server MSDB Database

It has come to my attention that some of our MSDB databases are getting what I would consider large for a system database. Some of our MSDB databases are over 2 GB which is a little perplexing because I know we do not create any user defined objects in that database. Can you give me some insight into the issue? I know we have this issue with both SQL Server 2000 and 2005 instances.  Read more...
By Additional Articles 2008/04/14 | Source: MSSQLTips.com | Category: Administration
Rating:  Rate this |  Briefcase | 2,573 reads

Backups

Read more...
By 2008/04/11 | Category: Administration
Rating: (not yet rated) |  Discuss |  Briefcase | 3,019 reads
   Items 1 to 20 of 416    Next 20 >>
 
Most popular

The Differences Between SQL Server 2000 and 2005

What are the differences between SQL Server 2000 and 2005? It's a question that DBAs are often asked by those who don't work with SQL Server on a daily basis. Steve Jones begins a short series on the differences by examining some of the core administrative differences.   Read more...
By Steve Jones 2007/08/31 (first posted: 2007/05/15) | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 65,362 reads

SQL Server 2005 Build List

Build List Updated with Cumulative Update 7 for SP2.   Read more...
By Steve Jones 2008/04/23 (first posted: 2007/04/23) | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 43,865 reads

Upgrading a Database SQL 2000 to SQL 2005

Performing an upgrade to the next version of SQL Server is something more and more of us will be doing as the support for SQL Server 2000 wanes. New author Sachin Samuel brings us an overview of the process and options that you have for performing an upgrade.   Read more...
By Sachin Samuel 2007/05/16 | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 30,376 reads
 
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use