<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
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
Articles with tag
Administration
Refine your search with one of the following additional tags (with number of items):
SQL Server 2005
(137)
Disaster Recovery
(2)
Career
(1)
Performance Monitoring
(1)
SQL Server 7, 2000
(23)
Miscellaneous
(2)
Data Warehousing
(1)
Performance Tuning and Scaling
(1)
Administering
(18)
News
(2)
DMF
(1)
Scalability
(1)
Reporting Services
(16)
2005 Compact Edition
(1)
DMVs
(1)
SMO
(1)
Development
(6)
addition
(1)
Index Management
(1)
SQL Server 2000
(1)
Monitoring
(5)
Advanced
(1)
Indexing
(1)
SQL Server 2005 - Security
(1)
Performance Tuning
(4)
Advanced Querying
(1)
INFORMATION_SCHEMA
(1)
SQL Server 2005 - SSIS
(1)
Strategies
(3)
Architecture
(1)
Installation
(1)
SQL Server 2008
(1)
Backup and Recovery
(2)
Auditing
(1)
Jobs
(1)
T-SQL
(1)
Database Design
(2)
Search for
any
content tagged
Administration
Items 1 to 20 of 172
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,746 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:
|
Discuss
|
Briefcase
|
1,144 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,437 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,411 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,881 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,165 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
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
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,881 reads
Find blocking processes using recursion in SQL Server 2005
Blocking occurs in SQL Server 2005 when one process has one or more records locked, while another process tries to acquire locks on the same set (or subset) of records. This can create a daisy-chain of processes waiting to complete their work.
Read more...
By
Additional Articles
2008/04/03
|
Source:
Builder.com
|
Category:
SQL Server 2005
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,877 reads
Write your own sp_lock system stored procedure in SQL Server 2005
The sp_lock system stored procedure is a great tool for checking the amount of locking that occurs on your database system. It returns the number and types of locks that are being held by current active SQL Server sessions.
Read more...
By
Additional Articles
2008/03/31
|
Source:
Builder.com
|
Category:
SQL Server 2005
Rating:
Rate this
|
Briefcase
|
1,807 reads
Job Execution System
ever want to allow people to execute jobs bot not be admins?
Read more...
By
TJay Belt
2008/03/27
|
Source:
SQLServerCentral.com
|
Category:
Jobs
Rating:
|
Discuss
|
Briefcase
|
3,921 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,881 reads
SQL Server Scalabilty - An Introduction
A brief introduction into the world of scalability, presenting at a high-level the various options
Read more...
By
Kev Riley
2008/03/19
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
1,622 reads
Dynamic Management Views and Functions in SQL Server 2005
DBAs have always been warned against using system tables in their code, but often there has been no other way to get information about the server. In SQL Server 2004, Dynamic Management Views have been provided that give you insight into almost every aspect of SQL Server. S. Srivathsani brings us a look at some of the DMVs and functions you can use.
Read more...
By
S. Srivathsani
2007/04/23
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
9,057 reads
SQL Server DBA Fights a Demon
An interesting tale of David Bird's fight with tempdb.
Read more...
By
David Bird
2008/03/17
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
5,777 reads
SQL Server 2005 Best Practices
With SQL Server 2005 recently released, one of the things that many people are looking for are some guidelines for working with the new product. New author Nanda Kishore brings us a list of best practices that should give you a start.
Read more...
By
Nanda Kishore
2008/03/14 (first posted: 2006/01/04)
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
96,057 reads
Reporting Services Makes Server Support Easier
Reporting Services is one of the most widely used subsystems in SQL Server and there have been some very creative solutions invented by DBAs around the world. New author Carolyn Richardson is one of those, bringing us a implementation that tracks uptime and disk space for her SQL Servers
Read more...
By
Carolyn Richardson
2007/03/12
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
7,227 reads
Open Source SQL DDL Scripting Tool
Keeping track of your DDL is something that is critical and some sort of VCS system should be used. However pulling out your scripts from SQL Server sometimes entails a bit more than the standard scripting. New author Richard Sutherland brings us an open source project that can help you get this done. Complete with code.
Read more...
By
Richard Sutherland
2007/03/06
|
Source:
SQLServerCentral.com
|
Category:
Administering
Rating:
|
Discuss
|
Briefcase
|
7,480 reads
Querying the INFORMATION_SCHEMA
Using a macro to query the INFORMATION_SCHEMA
Read more...
By
Mike DiRenzo
2008/03/03
|
Source:
SQLServerCentral.com
|
Category:
INFORMATION_SCHEMA
Rating:
|
Discuss
|
Briefcase
|
7,549 reads
Items 1 to 20 of 172
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,437 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,881 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,411 reads
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
