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