Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags administration, sql server 7 Rss

<< Newer    Items 21 to 40 of 389    Older >>
 

SQL Server Job Scheduling

The scheduling system in SQL Server is quite flexible and powerful, but can be confusing at times. Peter He looks at some of the advanced options you have in automating the various jobs on your server.   Read more...
By Peter He 2007/11/16 (first published: 2006/03/08) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 37,514 reads

usp_ShowOrphanUsers - SQL 2k

Check Orphaned logins ie, not associated with any database on the current instance.  Read more...
By Pedro Lopes MS 2007/10/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 867 reads

Changing Service Credentials

One day, you may need to change those service credentials under which your SQL Server services normally run. If you have a number of servers, then you'll really want to read about Rodney's solution.   Read more...
By Additional Articles 2007/09/21 | Source: SimpleTalk | Category: administration
Rating:  Rate this |   Briefcase | 2,239 reads

Monitoring Disk Space and Sending Alerts with TSQL

Haidong discusses the importance of monitoring disk usage over a period of time and has some great TSQL code to help you do the monitoring!   Read more...
By Haidong Ji 2007/09/14 (first published: 2003/08/13) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 50,394 reads

Server Farm Reporting - Part 2

Building on his first article examining management of a large server farm, Mark Tierney brings us part 2 in which he examines the data gathering process.   Read more...
By Mark Tierney 2007/08/06 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,794 reads

Using Non-Standard Port for SQL Server

Greg Larsen examines setting up SQL Server to listen on a different port number than 1433.   Read more...
By Additional Articles 2007/08/03 | Source: Database Journal | Category: administration
Rating:  Rate this |   Briefcase | 2,774 reads

Beginning SQL Server - Logins and Users

Part 3 of Steve Jones' series on beginning SQL Server from the perspective of a system administrator or someone not used to working with SQL Server. If you've been designated the new administrator, take a look at this series for some help in coming up to speed on this product. This article looks at logins and basic security.   Read more...
By Steve Jones 2007/08/03 (first published: 2004/09/02) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 40,999 reads

Pop Rivett and the Expanding Log

When your database transaction log is out of control, there is only one man who can tame it.   Read more...
By Additional Articles 2007/07/06 | Source: SimpleTalk | Category: administration
Rating:  Rate this |   Briefcase | 2,378 reads

How to use trace flags in SQL Server 2000

SQL Server 2000 trace flags can dramatically alter the behavior and functionality of the server. There are a number of ways that they can be enabled and Chris Hedgate brings us a tutorial on their use and benefits.   Read more...
By Christoffer Hedgate 2007/06/21 (first published: 2005/05/04) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 25,000 reads

Starting SQL Server in Minimal Configuration

Have you ever misconfigured your SQL Server's memory and been unable to start it? That happened to new author Jay Dave, who has the Data Center edition of SQL Server 2000 with a whopping 36GB of RAM. Here's how to get your instance back up and running.   Read more...
By Jay Dave 2007/05/10 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,087 reads

Auditing with SQL Profiler

SQL Server includes a great auditing tool: Profiler. It's not the easiest tool to use, however, and it's one that takes some getting used to. Our resident security export, Brian Kelley looks at a simple example of using this tool to audit logins.   Read more...
By Brian Kelley 2007/04/20 (first published: 2004/09/01) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 33,761 reads

Twiddling the knobs: The Default Backup directory

What's the best way to change the default backup directory for a server, using SSMS or Enterprise Manager, without changing all the default directories at the same time? What is the TSQL to do it? A prize for the best correct solution.  Read more...
By Additional Articles 2007/04/06 | Source: SimpleTalk | Category: administration
Rating:  Rate this |   Briefcase | 2,875 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: administration
Rating: |  Discuss |   Briefcase | 9,405 reads

Citrix MetaFrame, SQL Server, and the DBA

In this article, Brian looks at how Citrix MetaFrame can use SQL Server for its internal data repository. The basic operation of SQL Server in a Citrix MetaFrame installation is covered. In addition, Brian looks at how a DBA is an integral part of the support team for a successful Citrix MetaFrame farm.   Read more...
By Brian Kelley 2007/03/02 (first published: 2002/05/13) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 26,390 reads

Using BACKUP and RESTORE in SQL Server

This article covers the basics of full backup backups and restores in SQL Server. The examples are from SQL Server 2005 however it applies to SQL Server 2000 and SQL Server 2005. This is a very basic article covering full database backups, database restores and the simple and full recovery models.   Read more...
By Additional Articles 2007/02/27 | Source: SQLTeam.com | Category: administration
Rating:  Rate this |   Briefcase | 5,043 reads

Pop Rivett and the Suspect Database

Pop Rivett tackles a torn page in a suspect database.  Read more...
By Additional Articles 2007/02/13 | Source: SimpleTalk | Category: administration
Rating:  Rate this |   Briefcase | 2,524 reads

Searching Syscomments Accurately

As a SQL Server DBA you should know that your code is stored in syscomments by default. While most DBAs use version control systems, there are times you might want to look through the code on the server for comparison purposes. Robert Cary brings us an article on how you can do this in 2000 and 2005.   Read more...
By Robert Cary 2007/01/22 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,878 reads

Customizable Error Log Scanning

Monitoring your servers for issues and alerts is something every DBA should be doing on a regular basis. However even with a small number of servers, a DBA can easily be overwhelmed if some level of automation is not implemented. Thomas LaRock brings us a method of scanning your error logs automatically and notifying the DBA of problems.   Read more...
By Thomas LaRock 2006/12/27 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,492 reads

Indexes and Fragmentation in SQL Server 2000 Part 2

Most DBAs are constantly looking for ways to tune their servers to run better. Joe Doherty brings us the second part of his series on indexes with an in depth look at how the indexes are stored in your database.   Read more...
By Joe Doherty 2006/12/20 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 14,296 reads

Implementing Encrypting File System (EFS) with SQL Server

EFS provides a mechanism for encrypting files completely transparent to higher level applications such as SQL Server. In this article by Brian Kelley, he shows you how to implement this type of security in your environment.   Read more...
By Brian Kelley 2006/12/01 (first published: 2002/12/09) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 29,042 reads
<< Newer    Items 21 to 40 of 389    Older >>
 
Tags
configuring (63)    
t-sql (56)    
miscellaneous (52)    
strategies (35)    
security (34)    
programming (30)    
monitoring (27)    
sql server 2005 (26)    
performance tuning (20)    
backup / restore (16)    
sql server 6.5 (16)    
advanced querying (13)    
database design (12)    
visual basic 6 (12)    
installation (11)    
disaster recovery (dr) (10)    
replication (10)    
stored procedures (10)    
dts (9)    
sql-dmo (8)    
best and worst practices (7)    
indexing (7)    
news (7)    
availability (6)    
worst practices (6)    
ado (5)    
.net (4)    
basics (4)    
naming standards (4)    
career (3)    
distributed queries (3)    
service packs (3)    
state of the business (3)    
triggers (3)    
auto-growth (2)    
automated dba (2)    
data file management (2)    
data warehousing (2)    
logins (2)    
maintenance (2)    
maintenance and management (2)    
product reviews (2)    
reviews (2)    
routine database growth (2)    
routine growth (2)    
storage (2)    
system development life cycle (2)    
user defined function (udf) (2)    
utility (2)    
advanced (1)    
analysis services (ssas) (1)    
best practices (1)    
bugs (1)    
data types (1)    
databases (1)    
english query (1)    
grant (1)    
olap server (1)    
openxml (1)    
other (1)    
permissions (1)    
rants (1)    
role (1)    
script (1)    
scripting (1)    
sql puzzles (1)    
system databases (1)    
updategrams (1)    
user (1)    
xml (1)    
xsl (1)