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

Content with tags Administration, Installation Rss

   Items 1 to 20 of 20   
 

12 Essential Steps After Installing SQL Server

Rolling out SQL Servers is a key task for DBAs, this articles provides 12 essential post-installation steps.  Read more...
By Additional Articles 2009/08/03 | Source: SQL Server Performance | Category: installation
Rating:  Rate this |   Briefcase | 6,594 reads

Step-by-Step Guide to Clustering Windows 2000 and SQL Server 2000

In this next article of the SQL Server in the Enterprise Series, we'll explore how to cluster Windows 2000 and SQL Server 2000 in a step-by-step manner. After this article, you should be able to cluster a SQL Server 2000 machine for failover availability in an Active/Active cluster.   Read more...
By Brian Knight 2008/01/18 (first published: 2002/07/12) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 152,874 reads

Distributing SQL Server Databases

Longtime SQL Server author Raj Vasant brings us a technique for delivering databases along with an application. As more and more systems take advantage of SQL Server or Express, this is a technique that can come in very handy.  Read more...
By Vasant Raj 2007/10/22 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,422 reads

Services for SQL Server 2000

In this article, Brian Kelley focuses on learning the various services in SQL Server. He also covers the security needed to make them work.   Read more...
By Brian Kelley 2006/05/12 (first published: 2002/01/03) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 49,933 reads

SQL Server 2000 SP 3: What's New in Security

Service Pack 3 for SQL Server 2000 is huge. There are significant changes in it and they apply to all three products: the core SQL Server, MSDE, and Analysis Services. Because there are so many changes, this first article in the series will only focus on the security changes.   Read more...
By Brian Kelley 2005/12/09 (first published: 2003/06/05) | Source: SQLServerCentral.com | Category: service packs
Rating: |  Discuss |   Briefcase | 29,969 reads

Troubleshooting Cannot Generate SSPI Context Errors

As a DBA you do not need to know how to setup an Active Directory domain or a DNS server, but you still need to know how Kerberos, Service Principle Names, and hostnames are used to perform integrated authentication to a SQL Server. This article by new columnist Chad Miller shows you some of the more integral parts of troubleshooting running Windows Authentication security in a SQL Server environmnet.   Read more...
By Chad Miller 2005/08/19 (first published: 2003/02/27) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 65,282 reads

Data Dictionary from within SQL Server 2000

Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!   Read more...
By Mindy Curnutt 2005/02/04 (first published: 2002/02/11) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 35,783 reads

Step-by-Step Guide to Clustering Windows 2000 and SQL Server 2000

In this next article of the SQL Server in the Enterprise Series, we'll explore how to cluster Windows 2000 and SQL Server 2000 in a step-by-step manner. After this article, you should be able to cluster a SQL Server 2000 machine for failover availability in an Active/Active cluster.   Read more...
By Brian Knight 2008/01/18 (first published: 2002/07/12) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 152,874 reads

Clustering SQL Server 2000 from 500 Feet

Clustering a SQL Server machine was one of the most frustrating tasks a DBA and Windows administrator had to accomplish in SQL Server 7.0 and Windows NT 4.0. With the maturity of both the OS and the DBMS in Windows 2000 and SQL Server 2000, this operation has been simplified tremendously. This first article in the series of article on clustering SQL Server will explain the general architecture of clustering.   Read more...
By Brian Knight 2004/11/25 (first published: 2001/07/02) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 68,100 reads

Building a Demo Server

Everyone does demos. Selling software relies upon people viewing your software in action and being confident it will work. Managing a demo server can be a challenge and this series will look at different problems and options you have.   Read more...
By Steve Jones 2004/01/14 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 6,509 reads

SQL Server 2000 SP 3: What's New in Security

Service Pack 3 for SQL Server 2000 is huge. There are significant changes in it and they apply to all three products: the core SQL Server, MSDE, and Analysis Services. Because there are so many changes, this first article in the series will only focus on the security changes.   Read more...
By Brian Kelley 2005/12/09 (first published: 2003/06/05) | Source: SQLServerCentral.com | Category: service packs
Rating: |  Discuss |   Briefcase | 29,969 reads

Review of SQL 2000 Fast Answers

A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!   Read more...
By Andy Warren 2003/04/18 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 18,205 reads

Ways to Determine the Version and SP of SQL Server

There may be more ways than you realize to determine the version and service pack of SQL Server. This quick article by Dinesh Priyankara will show you 3 of those methods.   Read more...
By Dinesh Priyankara 2003/02/28 | Source: SQLServerCentral.com | Category: service packs
Rating: |  Discuss |   Briefcase | 21,846 reads

Troubleshooting Cannot Generate SSPI Context Errors

As a DBA you do not need to know how to setup an Active Directory domain or a DNS server, but you still need to know how Kerberos, Service Principle Names, and hostnames are used to perform integrated authentication to a SQL Server. This article by new columnist Chad Miller shows you some of the more integral parts of troubleshooting running Windows Authentication security in a SQL Server environmnet.   Read more...
By Chad Miller 2005/08/19 (first published: 2003/02/27) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 65,282 reads

Step-by-Step Guide to Clustering Windows 2000 and SQL Server 2000

In this next article of the SQL Server in the Enterprise Series, we'll explore how to cluster Windows 2000 and SQL Server 2000 in a step-by-step manner. After this article, you should be able to cluster a SQL Server 2000 machine for failover availability in an Active/Active cluster.   Read more...
By Brian Knight 2008/01/18 (first published: 2002/07/12) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 152,874 reads

Review of SQL Server 2000 Programming (MSPress)

Andy sits down with an entry level book to see if he should use it at work as a teaching aid. Did he like it? Should you buy it? Read the review now!   Read more...
By Andy Warren 2002/06/04 | Source: SQLServerCentral.com | Category: installation
Rating: (not yet rated) |  Discuss |   Briefcase | 6,398 reads

Data Dictionary from within SQL Server 2000

Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!   Read more...
By Mindy Curnutt 2005/02/04 (first published: 2002/02/11) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 35,783 reads

Services for SQL Server 2000

In this article, Brian Kelley focuses on learning the various services in SQL Server. He also covers the security needed to make them work.   Read more...
By Brian Kelley 2006/05/12 (first published: 2002/01/03) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 49,933 reads

Clustering SQL Server 2000 from 500 Feet

Clustering a SQL Server machine was one of the most frustrating tasks a DBA and Windows administrator had to accomplish in SQL Server 7.0 and Windows NT 4.0. With the maturity of both the OS and the DBMS in Windows 2000 and SQL Server 2000, this operation has been simplified tremendously. This first article in the series of article on clustering SQL Server will explain the general architecture of clustering.   Read more...
By Brian Knight 2004/11/25 (first published: 2001/07/02) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 68,100 reads

Moving Databases to a New Server

Got a plan for moving your data to the new server? Try this one! Andy Warren offers step by step instructions on how to move your data without doing a backup/restore or using detach and attach.  Read more...
By Andy Warren 2001/04/30 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 9,326 reads
   Items 1 to 20 of 20   
 
Tags
sql server 7 (11)    
configuring (7)    
security (4)    
t-sql (4)    
miscellaneous (3)    
stored procedures (3)    
backup / restore (2)    
disaster recovery (dr) (2)    
dts (2)    
indexing (2)    
service packs (2)    
strategies (2)    
triggers (2)    
user defined function (udf) (2)    
basics (1)    
database design (1)    
distributed queries (1)    
english query (1)    
monitoring (1)    
openxml (1)    
performance tuning (1)    
programming (1)    
replication (1)    
updategrams (1)    
visual basic 6 (1)    
xml (1)    
xsl (1)