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

Content with tags SQL Server 7, SQL Server 6.5, Administration Rss

   Items 1 to 20 of 20   
 

SQL Server Security Part 2

In part one Chris Kempster covered a variety of security recommendations primarily for production systems. In Part two of this series he continues to explore security at a variety of levels where you may not realize you are vulnerable.   Read more...
By Chris Kempster 2005/11/04 (first published: 2004/01/30) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 35,069 reads

Help! My Database is Marked Suspect.

If your database is marked suspect, this will show you a step-by-step guide in how to fix the problem.   Read more...
By Brian Knight 2005/10/28 (first published: 2004/03/31) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 57,730 reads

SQL Server Security Part 1

In this series of articles, Chris Kempster will discuss some of the finer aspects of SQL Server security and also touch on OS, physical and application security to open up this science for general discussion.   Read more...
By Chris Kempster 2005/02/11 (first published: 2002/01/14) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 49,987 reads

Moving Logins - A Gotcha!

This article by Andy Warren talks about using sp_addlogin to move logins from one server to another. It also points out a problem you may run into if you have a SQL 7 server that was upgraded from 6.5   Read more...
By Andy Warren 2004/05/12 (first published: 2001/05/01) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,819 reads

Help! My Database is Marked Suspect.

If your database is marked suspect, this will show you a step-by-step guide in how to fix the problem.   Read more...
By Brian Knight 2005/10/28 (first published: 2004/03/31) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 57,730 reads

Dump SQL Permissions

We saw a note from Chad about a tool he wrote in the forums and asked him to write up some notes. Not only did we get notes, we got the source code! See what a DBA can do with some DMO.   Read more...
By Chad Miller 2004/03/17 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 17,642 reads

SQL Server Security Part 2

In part one Chris Kempster covered a variety of security recommendations primarily for production systems. In Part two of this series he continues to explore security at a variety of levels where you may not realize you are vulnerable.   Read more...
By Chris Kempster 2005/11/04 (first published: 2004/01/30) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 35,069 reads

Automatically Gathering Server Information Part 2

The second part of Steve Jones's series on having SQL Server automatically report information to a DBA.   Read more...
By Steve Jones 2003/12/25 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,448 reads

SQL Server Encryption Best and Worst Practices

In this article by Neil Weicher, he talks about encryption of data and files for SQL Server.   Read more...
By Neil Weicher 2002/01/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,560 reads

SQL Server Security Part 1

In this series of articles, Chris Kempster will discuss some of the finer aspects of SQL Server security and also touch on OS, physical and application security to open up this science for general discussion.   Read more...
By Chris Kempster 2005/02/11 (first published: 2002/01/14) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 49,987 reads

Sweeping Up The Slackers

Have you ever worked with an application that forgot to close its connections? Ever run out of connections on your SQL Server and had to manually go remove the ones that are not in use? This article will present a technique for keeping the database clean.   Read more...
By Steve Jones 2001/05/07 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,991 reads

Moving Logins - A Gotcha!

This article by Andy Warren talks about using sp_addlogin to move logins from one server to another. It also points out a problem you may run into if you have a SQL 7 server that was upgraded from 6.5   Read more...
By Andy Warren 2004/05/12 (first published: 2001/05/01) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,819 reads

Log Your Changes

How can you maintain a stable environment? Keeping track of all changes is the time-tested and proven technique. Read about it here.   Read more...
By Steve Jones 2001/04/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,336 reads

Automatically Gathering Server Information Part 8

The eighth part of Steve Jones's series on having SQL Server automatically report information to a DBA.   Read more...
By Steve Jones 2001/04/29 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,481 reads

Restoring the Master Database

This article shows you in a step-by-step manner how to restore the master database.   Read more...
By Brian Knight 2001/04/29 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,790 reads

Automatically Gathering Server Information Part 6

The sixth part of Steve Jones's series on having SQL Server automatically report information to a DBA.   Read more...
By Steve Jones 2001/04/25 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,480 reads

Automatically Gathering Server Information Part 5

The fifth part of Steve Jones's series on having SQL Server automatically report information to a DBA.   Read more...
By Steve Jones 2001/04/24 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,672 reads

Automatically Gathering Server Information Part 4

The fourth part of Steve Jones's series on having SQL Server automatically report information to a DBA.   Read more...
By Steve Jones 2001/04/22 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,702 reads

Automatically Gathering Server Information Part 3

The third part of Steve Jones's series on having SQL Server automatically report information to a DBA.   Read more...
By Steve Jones 2001/04/20 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,935 reads

Process Tracking

It is not always possible to run a process on a set schedule. This article by Steve Jones looks at a technique for ensuring that your processes can run on whenever you need them to without any loss of data.   Read more...
By Steve Jones 2001/04/18 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,634 reads
   Items 1 to 20 of 20   
 
Tags
monitoring (7)    
security (4)    
best and worst practices (1)    
configuring (1)    
dts (1)    
programming (1)    
sql-dmo (1)    
worst practices (1)