<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,799 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
|
7,978 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,794 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,670 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
|
44,024 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,189 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,459 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,578 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
|
44,024 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,886 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,816 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,928 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
|
44,024 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,628 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,086 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,792 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,174 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,241 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,488 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,563 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,794 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
|
44,024 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,670 reads
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
