LabMice.net - The Windows 2000\XP\.NET Resource Index
Home | About Us | Search

Last Updated December 16, 2003

SQL Server 2000
Where to Start
Backup and Recovery
Install & Configuration
Performance Tuning
Troubleshooting

 

 

 

 

 

 

 

SQL Server Administration

Where to Start

Building a Highly Available Database Cluster
Read this article for a discussion on the technology of clustering and the steps involved in setting up a cluster for an e-commerce site.

Designing a Data Warehouse
The purpose of a data warehouse is to consolidate and organize data so it can be analyzed and used to support business decisions. Before implementing a data warehouse, careful planning is required. Source: Microsoft.com

Careful Planning Can Make Your Data Warehouse a Success
This article examines analysis and design roadblocks that you must overcome on your road to a successful data warehouse deployment. Source: Microsoft.com

Creating a Manageable Security Plan
Learn how to build a security plan for SQL Server 2000 or SQL Server 7.0 that is not only manageable and flexible but also verifiably secure. Source: Microsoft.com

 

Implementing Security in SQL Server
Read about SQL Server security features and ways to protect your valuable data. Source: Microsoft.com

Physical Database Design
A successful database implementation usually requires careful planning at the early stages of your project. Learn about factors to consider in planning the physical database design. Source: Microsoft.com

Database Design Considerations
It is important to accurately design a database to model the business because it can be time consuming to change the design of a database significantly once implemented. A well-designed database also performs better. Source: Microsoft.com

Application Design
Application design plays a pivotal role in determining the performance of a system using SQL Server 2000, so it is important to make the correct decisions during the application design phase. Source: Microsoft.com

Implementing SQL Server in an OLTP Environment
This article is an introduction on how to write optimized online transaction processing (OLTP) applications for SQL Server. It includes sections on determining the OLTP roadmap, designing the data model, designing stored procedures, and more. Source: Microsoft.com

Planning Replication
Careful planning before replication deployment can maximize data consistency, minimize demands on network resources, and prevent the need for troubleshooting later. Source: Microsoft.com

SQL Server 2000 Auditing
Microsoft has made each version of SQL Server more secure and easier to administer than the previous one. In August 2000, an independent testing facility found that SQL Server 2000 meets the US Department of Defense's C2 security requirements. If your company needs to meet C2 security standards or you need to audit usage of your SQL Server 2000 installation for other reasons, you'll find this discussion of auditing helpful. Source: Microsoft.com

SQL Server tips and scripts
150+ free scripts that will make your life as a SQL Server DBA or database developer just a tad easier.

Troubleshooting Planning
Get some valuable tips that will minimize the effects of a server failure or other troubleshooting situation. Source: Microsoft.com

Using Stored Procedures to Identify Common Administrative Issues
Learn about stored procedures that can be used to identify server and database configurations outside the recommended configuration parameters for SQL Server 2000. These stored procedures can be used "as is" or modified by a database administrator to fit the specific needs of your enterprise. Source: Microsoft.com

A Look at Eight-Way Server Scalability
Read this article from Dell to learn if an eight-way configuration is right for your organization. Source: Microsoft.com

 

Entire contents
© 1999-2003 LabMice.net and TechTarget
All rights reserved

This site and its contents are Copyright 1999-2003 by LabMice.net. Microsoft, NT, BackOffice, MCSE, and Windows are registered trademarks of Microsoft Corporation. Microsoft Corporation in no way endorses or is affiliated with LabMice.net. The products referenced in this site are provided by parties other than LabMice.net. LabMice.net makes no representations regarding either the products or any information about the products. Any questions, complaints, or claims regarding the products must be directed to the appropriate manufacturer or vendor.