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 6.5 Rss

   Items 1 to 20 of 31    Older >>
 

SQL Server Security: Server Roles

As yo probably know, Brian covers security topics for us and does a great job. This week he looks at the fixed roles and points out a few things you may not have thought about.   Read more...
By Brian Kelley 2007/05/04 (first published: 2003/10/29) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 53,973 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,043 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,709 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,957 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,815 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,709 reads

Review of Review of SQL Server 2000 Administrators' Companion

Nice write up on the Admin Companion. Should you add it to your bookshelf? Frank offers his frank opinion.   Read more...
By Frank Kalis 2004/03/26 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,118 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,634 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,043 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,434 reads

Using Xp_cmdshell

One of the most handy extended stored procedures in SQL Server is xp_cmdshell. This article will show you how to use it.   Read more...
By Brian Knight 2003/11/14 (first published: 2001/05/03) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 38,821 reads

SQL Server Security: Server Roles

As yo probably know, Brian covers security topics for us and does a great job. This week he looks at the fixed roles and points out a few things you may not have thought about.   Read more...
By Brian Kelley 2007/05/04 (first published: 2003/10/29) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 53,973 reads

SQL Agent Problem

Andy takes us through a recent troubleshooting session that includes a call to PSS. Ever run agent from the command line? Have a good idea of what justifies a call to PSS? Read this to learn more.   Read more...
By Andy Warren 2003/07/09 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,771 reads

Example VSS Framework - Source Code Management - Part 1

We asked Chris to put together some information on how he uses VSS, a subject that comes up a lot as we have articles and discussions that involve change management. Change management isn't easy, you definitely need a pattern to work from. This two part article gives you a pattern you can start with and customize to your needs.   Read more...
By Chris Kempster 2003/07/07 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,484 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,547 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,957 reads

SQL Server 6.5: Index Statistic Details

This article examines how index statistics are used in SQL Server 6.5   Read more...
By Alexander Chigrik 2001/10/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 3,245 reads

Undocumented Stored Procedures in SQL Server 6.5

This article examines some useful undocumented stored procedures in SQL Server 6.5   Read more...
By Alexander Chigrik 2001/09/21 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 3,224 reads

SQL Server 6.5 Data Page Structure

This article presents the technical details of the page layout for data in SQL Server 6.5   Read more...
By Alexander Chigrik 2001/07/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,681 reads

Locking in SQL Server 6.5

This article examines how locking occurs in SQL Server 6.5   Read more...
By Alexander Chigrik 2001/07/13 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,856 reads
   Items 1 to 20 of 31    Older >>
 
Tags
sql server 7 (16)    
monitoring (7)    
security (5)    
miscellaneous (2)    
programming (2)    
best and worst practices (1)    
configuring (1)    
dts (1)    
miscellaneous (1)    
performance tuning (1)    
sql-dmo (1)    
stored procedures (1)    
t-sql (1)    
worst practices (1)